high response time values for SQL Server components

Question

Hi,

Recently started using Orion APM and so far everything works fine.

I do however have a question about the high response time values in our SQL Server 2005 monitoring component.

What exactly do these mean? They seem awfully high, although our SQL is performing just fine. Anything to do with the fact that the values for both reads/sec and writes/sec are zero?

Thx,

Stijn

macnugetz · Accepted Answer

Stijn,

The calculation for response time includes the time required to connect to the remote node, open a SQL connection, log into SQL, and finally execute the query. In other words APM isn't just measuring the time it takes for the SQL query to execute, it's measuring the entire time it takes the monitor to complete its poll.

HTH,

Craig