How do you get database response time?

[vnad]

We are in contract negotiations and our customer wants to base their contract off a service level agreeement that has database response time in it. I need to find out how long it takes for them to process a transaction on our server. If we know how long it takes to return the transaction, we can then base the SLA off this. So I need to know how to measure the time it takes for them to do a successfull transaction. This would be something that would be able to continually run or be scheduled to run. Thanks,

Dan

 

[TheBugSlayer]

Profiler is the answer to your question. Create a trace on your server and monitor all transactions, sql statements, stored procedures, etc. While running the trace make sure you run the front-end application so you can record it's activity. The trace data can be saved to a text file or a table in a database.

Performance Monitor could also help you if you wanted to monitor how many IOs it takes and other SQL Server or Windows variables.

Here are a few useful links:

http://vyaskn.tripod.com/analyzing_profiler_output.htm

http://www.networkcomputing.com/601/601work1.html

Good lock.