ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How do you troubleshoot SQL Server if its running very slow?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do you troubleshoot SQL Server if its running very slow?
Answer
# 1
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 0 No
Guest
 
  Re: How do you troubleshoot SQL Server if its running very slow?
Answer
# 2
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 ?    1 Yes 0 No
Abc
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
how will u create "n" possible tables in sql... Oracle1
How to retrieve data from log files in SQL SERVER ?????  1
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju  3
what is for foreign key ?? Sabic3
Which data type can be used only on OUTPUT parameters of the stored proceduer?  2
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... TVS2
what is extended StoreProcedure ? Satyam3
how can i store resumes in database? HCL2
Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance  6
Can Having clause be used without Group by clause? CTS4
Explain the architecture of SQL Server?  2
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
Can you give an example of Stored Procedure?  2
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that TCS5
What are the type of joins? When do we use Outer and Self joins?  3
What is data integrity? Explain constraints? Thinksoft1
What is normalization and what are the different forms of normalizations?  1
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?  5
IN Vs OR operator which is best to use sql server.  3
What is a trigger?  6
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com