SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 analysis of proc
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nextaxtion
Starting Member

India
30 Posts

Posted - 03/08/2014 :  07:59:49  Show Profile  Reply with Quote
hi team,

there is common interview question that how to check issue in proc that is running good till last evening but suddenly there is slowness occurred.

Kindly provide me help regarding this that how can i answer quickly. also the best way to resolve the issue.

prithvi nath pandey

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 03/10/2014 :  06:28:25  Show Profile  Reply with Quote
If you do not know how to do this, a rote answer is not going to help you much in interviews. I suggest you look up how to determine slow running queries and then how to find out what part of the subsystem is causing that particular query to run for much longer than normal. The wait types will give you an idea of why, but could be many things. It is up to you as a DBA to be able to determine the cause and the fix for things like this.

The only way you are going to be able to answer quickly is to actually learn the many reasons for this type of behaviour and to get the experience of putting the different types of fixes into practice.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2023 Posts

Posted - 03/11/2014 :  02:49:49  Show Profile  Visit jackv's Homepage  Reply with Quote
A sudden drop in performance could be due to many different reasons. Over time you develop experience and methods to approach the problem. This method can assist in preliminary diagnostics http://www.sqlserver-dba.com/2012/11/sql-server-how-to-troubleshoot-a-slow-running-query.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000