Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Mar 28, 2003

Diagnose SQL Server performance problems with SQL Profiler

By DatabaseJournal.com Staff

[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.

The article continues at http://builder.com.com/article.jhtml;jsessionid=0NEE45NLKTUPDTQQAAZCFEY?id=u00320030324lur01.htm&vf=crg&rcode=u001

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM