Query Response Time - SQL Server Replication
-
Hi, I was asked a question the other day which was, does using SQL Server Replication improve query response time. I answered no, because I couldn't quite see how it would. I thought I'd better do a bit of research before giving a definitive answer though :) Thanks,
Personal Blog: A Software Programmer Twitter: JammoD
-
Hi, I was asked a question the other day which was, does using SQL Server Replication improve query response time. I answered no, because I couldn't quite see how it would. I thought I'd better do a bit of research before giving a definitive answer though :) Thanks,
Personal Blog: A Software Programmer Twitter: JammoD
JammoD87 wrote:
I was asked a question the other day
By someone in HR/recruiter I presume, I would be interested if I could see a relationship between the two functions.
Never underestimate the power of human stupidity RAH
-
Hi, I was asked a question the other day which was, does using SQL Server Replication improve query response time. I answered no, because I couldn't quite see how it would. I thought I'd better do a bit of research before giving a definitive answer though :) Thanks,
Personal Blog: A Software Programmer Twitter: JammoD
The question is not a valid question, it is not possible to answer, 'question does not compute'... - it is the equivalent of asking which is colder a banana or a strawberry. In essence there is not enough information being provided within the question in order to answer it. In the circumstances I would have asked for two examples database installations with details, one that is replicated and one that is not, I would then have more of an idea regarding which had an improved response time. To give you some idea I use replication for a reporting server - I replicate the tables and stored procedures from the production server onto the replicated server so that when running reports the production server does not get a performance hit. So in the setup I use replication does improve performance on the production server. However in and of itself replication is nothing but a tool - used well it will help, used poorly it will hinder.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
-
Hi, I was asked a question the other day which was, does using SQL Server Replication improve query response time. I answered no, because I couldn't quite see how it would. I thought I'd better do a bit of research before giving a definitive answer though :) Thanks,
Personal Blog: A Software Programmer Twitter: JammoD
I agree with what the others have said - it is a tool, and may or may not help. In a past position, we used replication and the answer would be - it all depends on where you are and what you're querying. We had replication from the computer room to two 'remote' sites - one about 1/4 mile away, the other about 30 miles away. So, if I queried both the computer room database and the local database while at a 'remote' site on comparable database server hardware, I would expect the local response would be appreciably better. If both systems were local, as suggested with a prodution and reporting server, then it may depend on the system load. For us, data input was a relatively level process, but between 7:00 and 8:30 in the morning, the reporting process hammered the systems.
-
Hi, I was asked a question the other day which was, does using SQL Server Replication improve query response time. I answered no, because I couldn't quite see how it would. I thought I'd better do a bit of research before giving a definitive answer though :) Thanks,
Personal Blog: A Software Programmer Twitter: JammoD