How do you troubleshoot SQL Server if its running very slow?
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
Do you know the capabilities of cursors?
How to store and query spatial data?
What are different types of raid levels?
How many levels of sp nesting are possible?
Which joins are sql server default?
Write query to return all rows sql?
Difference between LEN() and DATALENGTH() in sql server ?
Which are ddl commands?
how to do partition in sqlserver
What are the transaction properties?
What is side by side migration in sql server?
What is data compression?
Do you know how to implement service broker?
Why do we use trigger?
Explain the properties of a relational table?