Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

Yak Posting Veteran

54 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

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

Flowing Fount of Yak Knowledge

United Kingdom
2179 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

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next 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.03 seconds. Powered By: Snitz Forums 2000