SQL Profiler for Analyzing Database Performance, Indexes and TransacT SQL Queries
SQL Server performance problems can be caused by a number of different reasons, including insufficient hardware, poor database design, ineffective indexes, poorly written Transact-SQL code, etc.
SQL Server Profiler (part of SQL Server installation) can help you determine the root cause of the problem by identifying troublesome queries and stored procedures. Examining the components of the poorly performing queries is the key to figuring out what is causing the problem and coming up with the solution.[Learn More ...]