Identifying Bottlenecks and Performance-Tuning SQL Server
Introduction
Database server performance becomes increasingly important as time goes on and businesses grow, making databases larger and busier. For these reasons and others, doing a performance checkup and tuning database servers is essential to the organization's operations.
Using performance counters is the best way to check your SQL server. By understanding each of these counters, you can focus on what really needs to be done to make immediate and necessary performance enhancements. SQL Server 2000 includes many useful counters for looking at access methods, buffering, databases, caching, memory, backup, replication, and more. Knowing which counters to look at is important for determining how SQL Server is taxing system resources. In this article, we'll take a look at some examples. All counters can be viewed using the Performance Monitor snap-in, which is located in Administrative Tools.