Windows NT Performance Monitor allows you to create charts, alerts, logs, and reports to monitor a computer running Microsoft® SQL Server™.
Charts can monitor the current performance of selected objects and counters (for example, the CPU usage or disk I/O). You can add to a chart various combinations of Windows NT Performance Monitor objects and counters, as well as Microsoft Windows NT® objects and counters.
Each chart represents a subset of information you want to monitor. For example, one chart can track memory usage statistics and a second chart can track disk I/O statistics.
Using a chart can be useful for:
Charts are useful for short-term, real-time monitoring of a local or remote computer, for example, when you want to monitor an event as it occurs.
Using alerts, Windows NT Performance Monitor can track specific events and notify you of these events as requested. An alert log can monitor the current performance of selected counters and instances for objects in SQL Server. When a counter exceeds a given value, the log records the date and time of the event. An event can also generate a network alert. You can have a specified program run the first time or every time an event occurs. For example, an alert can send a network message to all system administrators that the computer running SQL Server is getting low on disk space.
Logs allow you to record information on the current activity of selected objects and computers for later viewing and analysis. You can collect data from multiple systems into a single log file. For example, you can create various logs to accumulate information on the performance of selected objects on various computers for future analysis. You can save these selections under a file name and reuse them when you want to create another log of similar information for comparison.
Log files provide a wealth of information for troubleshooting or planning. Whereas charts, alerts, and reports on current activity provide instant feedback, log files enable you to track counters over a long period of time, thereby allowing you to examine information more thoroughly and to document system performance.
Reports allow you to display constantly changing counter and instance values for selected objects. Values appear in columns for each instance. You can adjust report intervals, print snapshots, and export data. Use reports when you need to display the raw numbers.
For more information about charts, alerts, logs, and reports, or about Windows NT objects and counters, see your Windows NT documentation.