Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

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

What are types of storage modes? : sql server analysis services, ssas

0 Answers  

How to delete exactly duplicate records from a table?

0 Answers  

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

What is difference between index and primary key?

0 Answers  

Explain atomicity?

0 Answers  

What is dataset and its uses

2 Answers  

What do you know about system database? : SQL Server Architecture

0 Answers  

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  

how many clustered indexes can be created on a table? : Sql server database administration

0 Answers  

how to implement locking in sql server

3 Answers   Satyam,

How to execute stored procedure and set temp table in sql server?

0 Answers  

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

For more SQL Server Interview Questions Click Here
Categories