Export (0) Print
Expand All

Using Performance Logs and Alerts

SQL Server 2000

Consistently monitoring performance requires the use of performance logs and alerts. Performance logs collect data from performance counters at regular intervals, enabling you to analyze performance data at your convenience with robust reporting tools, such as Microsoft Excel. Perfomance alerts enable you to define limits for counters, and then receive alerts when the counter values are above or below the limit.

Creating a Performance Log

Create a performance log using Performance Logs and Alerts, a part of the Microsoft Windows Performance tool.

To create a performance log

  1. In Control Panel, open Administrative Tools, and then open Performance.
  2. In the Windows Performance tool, expand Performance Logs and Alerts, right-click Counter Logs, and then click New Log Settings.
  3. Type a name for the counter log, and then click OK.
  4. Click Add to add as many counters as necessary for your Notification Services instance and other important values, such as processor time, disk time, and database counters.

    The number of counters you add does not have a significant impact on system performance.

  5. When you have finished adding counters, click Close.
  6. On the General tab, under Sample data every, configure a sampling interval: start with a moderate sampling interval, such as 5 minutes, and then adjust the interval if necessary.

    The shorter the interval, the more system resources and disk space will be used. Additionally, intervals shorter than the quantum period can cause a performance report to show sporadic performance numbers, because you will have processing spikes mixed with no activity.

  7. On the Log Files tab, configure the properties of the log file. Comma-delimited files can be viewed later in reporting tools such as Microsoft Excel.
  8. On the Schedule tab, configure a monitoring schedule.

For more information about using counter logs, see the Performance Logs and Alerts documentation.

Analyzing Data from the Performance Log

One benefit of collecting counter data in a log file is that you can import the data to an application like Microsoft Excel and then create charts that illustrate performance over time. You can collect these charts on a regular schedule and use them to compare performance over time.

Setting Counter Alerts

Some counter values indicate an application problem. For example, for your application, you might want to know whether the generator is more than 25 quanta behind or the number of failed delivery requests exceeds 20.

Using the alerts available in the Performance Logs and Alerts part of the Microsoft Windows Performance tool, you can write a message to the event log, run an application, or send a network message in response to counters above or below a specified limit.

For more information about configuring performance alerts, see the Performance Logs and Alerts documentation.

See Also
Notification Services Performance Objects
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft