How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 11214 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 gets stored inside msdb database?
What is CTE in SQL
What are the disadvantages of using querystrings to send data from one page to another?
Explain about remote stored procedure?
What do you mean by normalisation?
what is the difference between openrowset and openquery?
Does partitioning ssd reduce performance?
How to create a simple table to test triggers in ms sql server?
What are the new features are introduced in sql server 2012 reporting services?
What is forward - only cursors / read only cursor?
Explain about SQL server 2005?
What are different types of database indexes?
what is raid? : Sql server database administration
What is a subquery in a select query statement in ms sql server?
What is the difference between a clustered index and a non-clustered index?
