up vote 0 down vote favorite
share [g+] share [fb]

How do you get the average response time for query a SQL 2005 server?

link|improve this question
80% accept rate
Can you define "response time"? – phoebus Jan 28 '10 at 17:31
feedback

1 Answer

up vote 2 down vote accepted

Response time for what? Opening a connection, executing a query, rolling back a transaction...?

You can get most information that you need from SQL Server Profiler traces so long as you have the appropriate permissions on the server. In addition to SQL Profiler there are dozens of performance monitor counters.

Your average response time for query execution is going to depend on a lot of things. Load on the server, size of your database, size and design of your tables and indexes, etc, all of which will change over time (sometimes even an extremely small amount of time).

Unfortunately there isn't a clear cut answer to your question. I'd highly recommend that you read through performance tuning articles and get familiar with SQL Profiler and the perfmon counters.

link|improve this answer
response for query – Sam Jan 28 '10 at 19:51
SQL Server Profiler is the tool to use then: databasejournal.com/features/mssql/article.php/3750161/… – joeqwerty Jan 28 '10 at 20:16
I didn't consider profiler, since it places a load on the server. Was hoping for a DMV or query solution. – Sam Jan 28 '10 at 22:27
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.