May 19, 2011 at 10:25 am
hi,
I am trying to measure the performance of queries in SQL Server 2008 with and without auditing feature enabled on specific table.
Basically, I have 1000 queries (inserts) on a table which I run when the auditing is OFF and later when auditing is ON.
I want to measure the performance of these two scenarios, and show whether auditing has impact on the delay of query execution.
I tried with simple timers, including at the beginning of the queries @starttime and at the end putting a variable @endtime, and measure the difference, but the execution varies too much.
Does anyone has an idea what tool to use for this case?
Thank you!
May 19, 2011 at 10:35 am
May 19, 2011 at 10:47 am
Thank you, but this tool I think is not appropriate for this case. Do you have any other idea?
May 19, 2011 at 10:49 am
Profiler?
May 19, 2011 at 10:52 am
I checked a bit that and I think it is not flexible and doesn't include many options. Even more, sometimes blocks the execution of the queries - makes delay.
May 19, 2011 at 10:58 am
asterman_3 (5/19/2011)
I checked a bit that and I think it is not flexible and doesn't include many options. Even more, sometimes blocks the execution of the queries - makes delay.
Not with a server-side trace that tracks only the minimum. More to the point you should be testing that on a test server, not production so I really don't see any reasons to not use the best tool for the job.
Actually I might actaully use both query stress and profiler at the same time for this.
May 20, 2011 at 6:39 am
Take a look at the RML Utilities from Microsoft. You can set up a work load and automate the replay of that workload or use a trace file and automate the replay of the trace file.
"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 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply