Overview of Performance Reports
Notification Services has five categories of performance reports: an instance report, diagnostic reports, detail reports, quantum reports, and snapshot reports. Each report is produced by running a stored procedure provided with Notification Services.
Instance Report
The administrative history report is the only report focused at the instance level. This report provides an overview of system health so that system administrators can quickly determine system performance over a period of time. The report contains counts and averages for events, subscriptions, notifications, and notification delivery. TheNSAdministrationHistory (Transact-SQL) stored procedure, which is in the instance database, produces this report.
Diagnostic and Troubleshooting Reports
Diagnostic reports are application-specific reports that provide detailed data for a time interval, such as the past 24 hours or week. Use these reports to analyze application processing. The stored procedures that run these reports are in the instance database.
The event batch list and notification batch list reports provide information about the event and notification batches received and produced. The NSEventBatchList (Transact-SQL) and NSNotificationBatchList (Transact-SQL) stored procedures produce these reports.
The delivery channel diagnostic report provides information about the notifications delivered through a particular delivery channel. Because a single notification class can deliver messages through multiple delivery channels, it can be difficult to diagnose delivery channel issues through applications or notification classes. Use this report to analyze a particular delivery channel. TheNSDiagnosticDeliveryChannel (Transact-SQL) stored procedure produces this report.
The event class diagnostic report provides information about the activity level of a particular event class. Included in this report is information about event batch creation latency, event batch sizes, and the number of pending batches. TheNSDiagnosticEventClass (Transact-SQL) stored procedure produces this report.
The event provider diagnostic report provides information about the events collected through a particular event provider. Because an event class can have events collected by multiple event providers, it can be difficult to diagnose event provider issues through applications or event classes. Use this report to analyze a particular event provider. TheNSDiagnosticEventProvider (Transact-SQL) stored procedure produces this report.
The failed notification diagnostic report provides information about notifications that could not be delivered. The report contains the application, notification class, and delivery channel names for each failed notification. The report also provides the subscriber ID and the device address for the failed notification, and information about failures and retries. TheNSDiagnosticFailedNotifications (Transact-SQL) stored procedure produces this report.
The notification class diagnostic report provides information about the activities of a particular notification class. Included in this report are counts of notifications and notification batches, the average number of notifications created per second, and the delivery success of those notifications. TheNSDiagnosticNotificationClass (Transact-SQL) stored procedure produces this report.
The subscription class diagnostic report provides information about the activities of a particular subscription class. Included in this report are the number of scheduled subscriptions, the subscription processing latency, and the notifications generated from these subscriptions. TheNSDiagnosticSubscriptionClass (Transact-SQL) stored procedure produces this report.
Detail Reports
Detail reports provide detailed information about event batches and their events, notification batches and their notifications, and scheduled subscriptions. After looking at the higher-level reports such as the snapshot and diagnostic reports, you can use these reports to look at the details of individual batches and subscriptions. The stored procedures that run these reports are located in the application databases.
The event batch detail report provides information about a specified event batch. The report contains multiple result sets. One result set contains general information about the event batch, such as the event provider name and the time that the event batch was collected. A second result set displays the events that were submitted in the event batch. TheNSEventBatchDetails (Transact-SQL) stored procedure produces this report.
The notification batch detail report provides information about a specified notification batch. The report contains information about the rule firing that produced the batch and the notifications contained in the batch. Use this report to troubleshoot notification generation and to analyze the progression of notifications through the application. TheNSNotificationBatchDetails (Transact-SQL) stored procedure produces this report.
The scheduled subscription detail report provides information about the scheduled subscriptions for a specified subscription class. The report contains information about when each subscription was created, when it was last modified, and when it is scheduled to run. TheNSScheduledSubscriptionDetails (Transact-SQL) stored procedure produces this report.
The scheduled subscription list report provides information about all scheduled subscriptions for a given subscriber. The report shows the subscription ID, class name, and whether the subscriber and subscription are enabled, along with information about the subscription schedules and time zones. TheNSScheduledSubscriptionList (Transact-SQL) stored procedure produces this report.
Quantum Reports
Quantum reports are application-specific reports that provide detailed data about application processing intervals, or quanta. Examples of quantum data are the quantum execution time, notifications generated during the quantum, and rule firing details. Use the following reports to analyze and troubleshoot application performance related to generator processing. The stored procedures that run the reports are located in the application databases.
The quantum detail report provides detailed information about a specified quantum. Use this report to troubleshoot long-running quanta and to analyze quantum processing. The NSQuantumDetails (Transact-SQL) stored procedure produces this report.
The quantum execution time report provides information to help you identify problematic generator quanta, which you can then use to analyze the quanta in more detail. The NSQuantumExecutionTime (Transact-SQL) stored procedure produces this report.
The quantum failure report provides information about failed generator quanta. A quantum is failed if the quantum could not complete required processing, such as event-triggered or scheduled subscription rule firings. The NSQuantumFailures (Transact-SQL) stored procedure produces this report.
The quantum list report provides information about quanta processed during a specified time period, and displays the quanta in the order in which they ran. The NSQuantumList (Transact-SQL) stored procedure produces this report.
The quantum performance report provides information about quanta in terms of how long each quantum executed. The result set divides execution time into intervals, so you can see how many quanta executed within each time period. This can help you troubleshoot long-running quanta. The NSQuantumPerformance (Transact-SQL) stored procedure produces this report.
The quanta skipped report provides information about skipped generator quantum processing. Quanta can be skipped if the generator falls behind and quantum limits are set in the application definition file (ADF). The NSQuantumsSkipped (Transact-SQL) stored procedure produces this report.
Snapshot Reports
Snapshot reports provide the current health status of an instance. These reports are used primarily by system administrators to generate performance and throughput baselines and to determine the current status of an instance against those baselines. The stored procedures that produce these reports are located in the instance database.
The application snapshot reports provide information about the current state of all applications that are hosted by the instance. The information includes data such as the generator, vacuumer, and subscriber activation states, information about the most recent notification batch and vacuuming occurrence, and information about subscriber data. The NSSnapshotApplications (Transact-SQL) stored procedure produces the reports.
The delivery channels snapshot report provides information about the current state of the delivery channels that are configured across the instance. The information includes data such as the distributor system name, activation state, the last time each delivery channel processed work items, and the number of messages that were sent or that failed. The NSSnapshotDeliveryChannels (Transact-SQL) stored procedure produces this report.
The events snapshot report provides information about the current state of the event classes that are configured for applications within the instance. The information includes data about the application and event provider activation states, the last time the event classes collected data, and how many events have come from the event classes. The NSSnapshotEvents (Transact-SQL) stored procedure produces this report.
The providers snapshot report contains information about the current state of the event providers that are configured for applications within the instance. The information includes data about the server that the event provider is running on, the activation state, the most recent event class and batch that are collected by the provider, and the number of events that are collected. The NSSnapshotProviders (Transact-SQL) stored procedure produces this report.
The subscriptions snapshot report contains information about the subscriptions added to applications that are hosted by the instance. The information includes the application name, the subscription class name, and the time the most recent subscription was added to the application. The NSSnapshotSubscriptions (Transact-SQL) stored procedure produces this report.
See Also
Concepts
Monitoring Notification Services Performance and Activity
Using Reports to Analyze Performance