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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-05-18 : 11:54:10
|
| In the middle of last week my users started telling me that the response time of our app had degraded noticeably. A new version of the app had gone out so I assumed it was related to that, then I found out that it was slower from QA!The only other thing that has changed is that there is a new mini app that (alledgedly) calls a (fairly complex) view that is wrapped in a stored procedure, this was originally being called every minute but I have reduced this to every 30 mins. When doing so I noticed that this app seems to hold the connection open all the time.I know I can run a trace to see what is going on but I'm not sure what I'm really looking for, I presume wait time, CPU, IO and memory useage are on the list somewhere but is there anything else I should be looking for to find the cause. Just to add to the complexity we are on SQL Server 7Many thankssteveA sarcasm detector, what a great idea. |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-05-18 : 12:16:11
|
| Steve Why the Sp / View Relationship?Why not just a layered SP?JimUsers <> Logic |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-05-18 : 14:33:12
|
| Perhaps I didn't explain very well. It isn't really a view, it was originally written that way for testing and then I changed it to a stored procedure for security and to ensure the data was read only. Is that what you mean? If there is a better way please let me know. This sproc is called by the mini app but is also called by an even smaller app I have written so that I can check the data it is putting outthankssteveA sarcasm detector, what a great idea. |
|
|
|
|
|
|
SLLLLLOOOOOoooooowwwwww