Jaa


Notification Services Performance Objects

Microsoft SQL Server Notification Services has three types of performance objects: component, application, and instance. These objects contain counters for monitoring performance at different levels of an instance of Notification Services.

  • Component-level objects monitor the state of the components on the local server. You cannot use these objects to monitor a single application on a multiple-application instance or to monitor an entire instance if the instance is scaled-out across multiple servers.
  • Application-level objects monitor the status of a Notification Services application by querying the application database, and can be used on servers that run the NS$instance_name service.
  • Instance-level objects monitor subscriber activity by querying the instance database, and can be used on servers that run the NS$ instance_name service.

Component-Level Objects

Notification Services provides the following component-level performance objects that monitor their components on the local server:

Topic Description

NS$instance_name: Delivery Channels Object

Provides information about one or all delivery channels on the local server.

NS$instance_name: Distributors Object

Provides information about one or all distributors on the local server.

NS$instance_name: Event Providers Object

Provides information about one or all event providers on the local server.

NS$instance_name: Generator Object

Provides information about the generator component on the local server.

Application-Level Objects

The following application-level objects query the application databases, and can be used on any server that runs a Notification Services engine. However, the counter data reflects only the activity that takes place on the local server.

Topic Description

NS$instance_name: Events Object

Provides information about events for an application.

NS$instance_name: Notifications Object

Provides information about notifications created by an application.

NS$instance_name: Subscriptions Object

Provides information about the subscriptions for an application.

NS$instance_name: Vacuumer Object

Provides information about the application vacuuming process.

Instance-Level Objects

The following instance-level object queries the instance databases, and can be used on any server that that runs a Notification Services engine. However, the counter data reflects only the activity that takes place on the local server.

Topic Description

NS$instance_name:Subscribers Object

Provides information about the subscribers for an instance of Notification Services.

See Also

Concepts

Choosing Monitoring Tools
Notification Services Performance Reports
Using Performance Logs and Alerts

Help and Information

Getting SQL Server 2005 Assistance