15.7. Tuning Using SQL Server Profiler
SQL Server 2005 Profiler is a great resource to use during preproduction to tune long-running queries, fix locking and deadlocking issues, and identify potential bottlenecks related to I/O, memory, and processors. Installed as part of the SQL Server2005 management tools, the profiler comes with a variety of options and selections that can provide the user with highly detailed data as to what is actually happening on the database. SQL Server Profiler also provides the ability to replay server workloads. Although this is a feature that may not be of much use when deploying an application for the first time, it is especially useful when changing hardware.
Get Professional SQL Server® 2005 Performance Tuning 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.
