Specifying the Performance Query Interval

When you create an instance of Notification Services, Notification Services installs performance objects on each server that runs a generator, hosted event provider, or distributor. Some of these objects are application specific and are updated by querying the application database. You can control how often the performance object's counters are updated by setting a performance query interval.

Notification Services Performance Objects

Notification Services installs application-level, component-level, and instance-level performance objects whenever it creates a Microsoft Windows service for the instance of Notification Services. For a list of these performance objects, see Notification Services Performance Objects.

In the application definition, you specify the query interval for the application-level objects. Other performance objects are not affected by this query interval.

Counters in the application-level objects are updated on the server that hosts the generator, and only when the application is enabled.

Specifying a Query Interval

Querying the application database and calculating the data for the performance counters consumes resources from the application database. When specifying the query interval for your application, balance the need for current performance data with the processing overhead incurred by executing the query to obtain the data.

The default value for the query interval is one minute.

Specifying the performance query interval

See Also

Concepts

Specifying Application Execution Settings
Notification Services Performance Objects
Monitoring Notification Services Performance and Activity

Help and Information

Getting SQL Server 2005 Assistance