Interested to Buy Any Domain ? << Click Here >> for more details...
How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 12398 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 are the approximate numeric data types?
How to install sql server 2005 express edition?
What is a primary index?
Why is normalisation important?
Which tcp/ip port does the sql server run on? How can it be changed?
What do you understand by the denormalisation?
Define self join in sql server joins?
What is the purpose of sql profiler in sql server? : sql server database administration
Explain four layers of abstraction microsoft architectured?
What is a select query statement in ms sql server?
What are the different types of cursor?
what are candidate key, alternate key and composite key? : Sql server database administration
What are the purposes of floor and sign functions?
How to execute stored procedure and set temp table in sql server?
Explain about system stored procedure?
