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 |
|
Blin
Starting Member
36 Posts |
 Posted - 2007-04-02 : 11:58:26
|
| We have an application in production which was running great. But, all of a sudden, the response time has become slowly. The development team thinks it is the database problem. What steps would you take to figure out and resolve this performance issue if it is database related.Thank you. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-04-02 : 12:23:26
|
| Check if there is anything else running...Antivirus? Some unnecessary jobs? Perhaps you can restore the prod copy onto a dev envorinment and if you can reproduce the similar slow behaviour, run profiler and identify which procs taking longer time. If you have a baseline copy to compare to, you can identify the procs taking longer time than they should.************************Life is short. Enjoy it.************************ |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-02 : 12:31:28
|
| Also check what recently went into the release? and when you started experiencing this problem? What database side changes went in? Also, check whether this scenario is happening for certain parts of application. If it is, then you can narrow down your search area to that particular functionality.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Slow response time