Troubleshooting Applications
SQL Server 2000 comes with many different utilities to help you debug your applications and get the best performance. The SQL Server Profiler (previously SQL Trace) enables you to monitor SQL Server while your applications are executing in a production or test environment. You can use the SQL Server Profiler to look at different events, objects, Transact-SQL statements, locking, and errors. You can save the traces to a file to replay on the server (or a different server). This ability is useful when tuning a server and application or in situations when an event occurs that causes your server or application to behave in an undesirable manner. You can read more about the SQL Server Profiler in Chapter 24.
The SQL Server ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
