Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nextaxtion
Yak Posting Veteran
54 Posts |
 Posted - 2014-03-08 : 07:59:49
|
| 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
3608 Posts |
Posted - 2014-03-10 : 06:28:25
|
| 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. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
analysis of proc