SQL Server performing slow,wht to look for? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server performing slow,wht to look for?

Hello DBA’s If we have a situation where we have a SQL server performing slow or somebody complaining that a server is running slow, what do we have to look for and what can we do to improve it? Thanks
What first brought me to this site was an excellent article on doing a performance audit:
http://www.sql-server-performance.com/sql_server_performance_audit.asp This should be a good starting point too …

Read the following topic…from Joe..
Performance audit is the best one so far I have seen. Bear in mind there are few differences if you are running SQL 2000 and 2005 version on the same machine, in this case you need to have a full checkover of server to database in order to eliminate any issues even it is a smaller one. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.