How do you troubleshoot SQL Server if its running very slow?

Posted Date: 24 Jun 2009	Resource Type: Tips	Category: General
Author: kingfisher	Member Level: Gold
Rating:	Points: 3

First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

SQL Server .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Blocking Acess To Specific Drives
	Previous Resource: Verify your sql server account using command prompt
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

More Resources