0

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

Sam
  • 2,020
  • 1
  • 16
  • 22

1 Answers1

2

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.

squillman
  • 37,883
  • 12
  • 92
  • 146
  • response for query – Sam Jan 28 '10 at 19:51
  • SQL Server Profiler is the tool to use then: http://www.databasejournal.com/features/mssql/article.php/3750161/Introduction-to-SQL-2005-Profiler-Part-1.htm – 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