Monitoring to Troubleshoot Problems
You can monitor the following areas to troubleshoot problems:
- Microsoft® SQL Server™ stored procedures or batches of SQL statements submitted by user applications
- User activity, such as blocking locks or deadlocks
- Hardware activity, such as disk usage
Problems can include:
- Application development errors involving incorrectly written Transact-SQL.
- Hardware errors, such as disk or network-related errors.
- Excessive blocking due to an incorrectly designed database.
SQL Server Profiler can be used to monitor and troubleshoot Transact-SQL and application-related problems. Windows NT Performance Monitor can be used to monitor hardware and other system-related problems.
(c) 1988-98 Microsoft Corporation. All Rights Reserved.