How to identify Performance Bottlenecks ?
In SQL Server 7.0 and SQL Server 2000, this is an
easy task using the SQL Server Profiler. You can catch my other article where
I've discussed the built-in
SQL Server Profiler Templates.
In SQL Server 2000, which doesn't have a "Create
Trace Wizard," you need to create your own template using this configuration:
Select These Event Classes
SQL:BatchCompleted
Select These Data Columns
Columns
EventClass
TextData
CPU
Application Name
LoginName
NTUserName
SPID
Duration
Select These Filters (as needed)
Application Name
DatabaseName
Duration
Now you can use this as the template to find which
wuery takes tons of time to excute using the Duration as the filter.
|