Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
Can you define "response time"? –  phoebus Jan 28 '10 at 17:31

1 Answer 1

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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