• Management Pack:  SQL Server 2008
  • MP Version:  6.3.173.0
  • Released:  4/2/2012
  • Publisher:  Microsoft

SSAS 2008: Query: Average Time Per Query Rule

Overridable Parameters

Parameter Name Default Value Description Override
Frequency 900  

Run As Profiles

Name
SQL Server Default Action Account
SQL Server Monitoring Account

Rule Knowledgebase

Summary

Average time per query in milliseconds. This counter is based on queries answered since the last counter measurement. This counter is polled every fifteen minutes.

Unlike most performance data collection rules, this rule requires administrator rights on the server in order for the data to be collected by the agent. As such this rule is configured to leverage the "SQL Server Monitoring Account" RunAs profile that is provided with the SQL. For systems where the default agent action account is not an administrator, you must configure the "SQL Server Monitoring Account" RunAs profile accordingly to ensure this performance data is collected.

Causes
This rule does not contain any causes.
Resolutions
This rule does not contain any resolutions.
External References
This rule does not contain any external references.

See Also for SQL Server 2008 Management Pack


Downloads for SQL Server 2008 Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED