Interested to Buy Any Domain ? << Click Here >> for more details...
How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 12107 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
Can you leave a union at any time?
What are dml (data manipulation language) statements in ms sql server?
How do you use a subquery to find records that exist in one table and do not exist in another?
what is a live lock? : Sql server database administration
Explain about system database?
What is the process of normalization?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Explain powershell included in sql server 2008?
What are rows and columns?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is sub query and its properties?
What is ms sql server service broker?
What does <> symbol mean?
Explain features of analysis services?
What is resource governor in sql server?
