Tips for Evaluating Performance

You evaluate the status of Microsoft SQL Server Notification Services by monitoring the flow of events and notifications through the system. When monitoring the system, you want to ensure the following:

If your application is not operating as expected, see Troubleshooting Notification Services.

Monitoring Production Applications

Notification Services applications typically have peak periods and quiet periods because subscribers tend to want information delivered at similar times and because large batches of events often arrive at the same times each day. For this reason, it is very important to monitor applications during peak periods, establish performance baselines, and then compare performance over time.

For applications in production, you should always monitor critical performance counters and set alerts to notify operators of poor performance. You can set alerts using Performance Logs and Alerts, a feature of the Microsoft Windows Performance tool.

Responding to Performance Problems

When you encounter performance problems, use all the tools available to determine what is causing the problem. Here are some possible remedies for performance problems:

  • Configure indexes for rules (event chronicle rules, subscription event rules, and subscription scheduled rules) to tune the application.
  • Do not run ad-hoc queries against the instance and application databases during peak processing periods because you might be creating temporary locks on resources needed by Notification Services.
  • Ensure that the CPU resources are adequate for distribution, which is typically CPU-bound.
  • Ensure that your server has adequate bandwidth to servers or services that deliver notifications.
  • Ensure that applications are tuned for the best performance. To tune an application, you might need to adjust several elements in the application definition file, especially elements in the ApplicationExecutionSettings element.
  • Place database files, log files, and the tempdb database on three separate physical disks. The performance for generating notifications on the database system is often limited by disk resources.

For any performance problems, it is important to isolate the problem by looking at performance counters, using reports, and examining the application log to see what errors are occurring.

See Also

Concepts

Choosing Monitoring Tools
Notification Services Performance Objects
Using Performance Logs and Alerts
Using Reports to Analyze Performance
Specifying Application Execution Settings

Other Resources

Notification Services Errors and Events

Help and Information

Getting SQL Server 2005 Assistance