Interested to Buy Any Domain ? << Click Here >> for more details...
How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 12238 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / guest
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
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is key attribute?
Do comments need to go in a special place in sql server 2005?
How to Sync Two SQL Azure Databases?
What is difference between stored procedure and user defined function?
What are the components of sql server service broker?
What is dbcc command in sql server?
How to list all field names in the result set using mssql_field_name()?
What is field with example?
Explain indexed views?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Why I am getting this error when dropping a database in ms sql server?
Explain left outer join and right outer join?
What do you understand by physical_only option in dbcc checkdb?
What is the user of Primary key?
What is fill factor and pad index?
