Diagnose SQL Server performance problems with SQL Profiler
March 28, 2003[From Builder.com]
You've been told that your SQL Server app is very slow, especially in the morning hours. You're pretty sure the problem is in the database itself, and since you're the only developer, it's your job to fix it. How do you go about that, and where do you start? Your best bet would be to perform some analysis so that you understand the cause of the performance degradation.
The SQL Profiler tool, which ships with SQL Server, provides the most effective way to perform such analysis. If you are using SQL 6.5, you'll know this tool as SQL Trace. But whatever you call it, it's a tool that for monitoring events from a SQL Server. It can report on many kinds of events, such as when a new connection is established, a SQL batch is started, or a SQL batch ends. In fact, there are so many events that to monitor them all would lead to serious information overload.