October 14, 2008 at 3:08 pm
Hi guys
My conern is :
we have a 8 GB of data replicated among 4 SQL server 2000 located across different Location.
But as DB is growing rapidly and moreover people are querying the data with different set of parameters.
When I came to know that SQL Server 2005 is a perfomance booster and moreover we can do a table partition in this.
I set up sql server 2005 as Publisher and Sql Server 2005 a Subscriber, and one another subscriber sql server 2000.
I did table partioning on sql server 2005 DB.
in Brief:
How I can compare the performance of getting results by 2 different servers now.
I need to compare Is Sql server 2005 with partiton is reallt a better option than sql server 2000.
Please advise how?
Thanks in advance.
October 15, 2008 at 6:16 am
Simplest way I can think of is to capture the trace output from your production box and the use the Profiler's ability to replay traces against the test machine. Capture that set of trace events too and then compare the two. You'll see which one is faster, uses less resources, etc.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply