![[Table of Contents]](/dwicons/b_toc.gif)
|
Introducing Sybase Workplace SQL Server
|
Monitoring and Tuning Performance
After a production database is established, you may want to examine some performance statistics and adjust some performance parameters to tune the system for high performance.
The easiest way to monitor SQL Server performance is with SQL Server Monitor. Monitor Client, which uses data provided by Monitor Server (installed on the same machine as the SQL Server it is monitoring) provides an overall picture of performance with a graphical view of overall performance parameters. It also gives specific details about performance with numeric measurements of cache usage, network traffic, device I/O, and locking activity, which are all discussed in the Performance and Tuning Guide.
Most of your actual tuning efforts ought to address the amount of time it takes for SQL Server to respond to queries. You can achieve high performance by starting out with a well designed database that includes strategic indexes and by learning to work with the SQL Server query optimizer, a SQL Server feature that analyzes queries and database objects and selects the appropriate query plan based on how much time it will take to execute. For more information, see the Performance and Tuning Guide.
![[-]](/dwicons/i_colpse.gif)