How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 11452 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
How to view existing indexes on an given table using sys.indexes?
What do you understand by check constraint in sql server?
What is the osql utility?
What is simple indexing method?
Can sub report data source be different from that of the parent report?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Explain “@@rowcount” and “@@error” in sql server?
Which is the latest version of sql server and when it is released?
what is the difference between Delete and Truncate command in SQL
What is the bookmark lookup and rid lookup?
What is an expensive query?
Explain nested trigger in sql?
What are the types of stored procedures in an sql server?
Name three of the features managed by the surface area configuration tool? : sql server security
Do you know the cursor optimization tips?
