Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asterix5
Starting Member
6 Posts |
 Posted - 2011-05-19 : 12:24:51
|
| 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! |
|
|
MichaelJSQL
Constraint Violating Yak Guru
252 Posts |
Posted - 2011-05-21 : 14:28:26
|
| SQL profiler should work for you |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-05-22 : 01:51:11
|
| As well as SQL Profiler , mentioned by MichaelJSQL. The Query Response Time is made up of the CPU (Running) , Wait Time (Suspended),Signal Wait Time(Runnable Queue Time). Consider breaking down the analysis into this reporting - as it can show greater details about the response time . Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Measure Performance: SQL Query time execution