Performance Monitoring
Performance problems can be due to the following:
Application problems
Problems with the logical or physical design of the database
Problems with the server configuration options
Problems with the hardware configuration
Although SQL Server offers tools to diagnose and correct problems, you must look at all of these as potential causes of the performance problems that you encounter. The tools available for performance monitoring include the SQL Server Profiler and the System Monitor (Performance Monitor). The following sections cover each of these tools in detail.
The SQL Server Profiler
The SQL Server Profiler is a graphical tool that allows you to:
Monitor SQL Server performance
Identify and diagnose slow-running queries
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.