Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-28 : 10:43:09
|
| Mike writes "How do we troubleshoot a slow database ?" |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-28 : 11:09:08
|
| There are many things you need to do.1. The first thing I always do is check for blocking. Check out sp_lock, sp_who and sp_who2 and the current activity window in Enterprise Manager.2. The second thing I do is to look at the Task Manager on the server to check on CPU usage and the other values on the Performance tab and I take a look at the processes tab to see what process might be eating up all of the resources.3. Then you can use Windows Performance Monitor and/or SQL Profiler to monitor problems with the hardware with the former and and to check for long running queries, sql server memory issues, connection issues etc... with the latter.4. Then I try to resolve software problems first and if the applications can not fixed\tuned any further, you address hardware issues identified in step 3.If the performance issue is software based I might take a look at the index tuning wizard and the article entitled Optimizing Database Performance under the contents tab in SQL Server Books Online.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-06-28 : 11:10:26
|
| Are you joking? What kind of a question is that?SQL Books Online is good. As is one of my favourite books "Inside SQL Server".There are so many things that could be slowing your system down - including bad design (in which case you're pretty much screwed).You need to provide more info that that if you want your problem solved on this forum. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-28 : 22:38:53
|
| You might want to read the articles on this site and www.sql-server-performance.com also.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Slow Database