How do you troubleshoot SQL Server if its running very slow?
- 2 Answers
- 11467 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / abc
we can check for the cpu utilization from the task manager
and if it above 80% then we have to check the status of
indexes or we can say we have to recreate the statics as
well as indexes.
there are many other factors but in production servers
indexing causes a great performance enhancement.Also we
have to check whether large I/o operations are not
hindering the performance.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Introduction of rollup clause using sum and group by clause?
What is SQL Azure Firewall?
How to create indexed view?
What are triggers? How do you invoke a trigger on demand?
What are information schema views?
How to view existing indexes on an given table using sp_help?
Explain what are the database objects? : SQL Server Architecture
How do you manipulate data?
What are a scheduled jobs?
What are the triggers in sql?
In which tcp/ip port does sql server run? Can it be changed?
How to use “drop” keyword in sql server and give an example?
What is difference between delete and truncate commands?
What is the partitioning method?
What is model database? : SQL Server Architecture
