How do you troubleshoot SQL Server if its running very slow?

Question Posted / guest

2 Answers
12285 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you troubleshoot SQL Server if its running very slow?..

Answer / 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

How do you troubleshoot SQL Server if its running very slow?..

Answer / 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

More SQL Server Interview Questions

Do you know the capabilities of cursors?

0 Answers

What does truncate do?

0 Answers

What is difference between count (*) and count column?

0 Answers

What is Right Outer Join?

2 Answers

How to add an address record into adventureworkslt?

0 Answers

Explain the properties of the relational tables?

0 Answers

When you use @@error and try-catch?

0 Answers

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers

how to connect sybase to sql server 2005?.

1 Answers ABC,

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers TCS,

Explain foreign key in sql server?

0 Answers

State the difference between union and union all?

0 Answers

For more SQL Server Interview Questions Click Here