| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-07-24 : 15:57:24
|
| I just modified a stored proc for a customer (removed a result column).The SP runs in 3 sec in query analyzer. Run it from the web and it times out in 30 seconds.I put the result column back in, and it runs great from the web.do do do do do do do do (hum to the twilight zone theme)Any ideas?Sam |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-24 : 16:08:33
|
| I putting money on the fact that you changed in EM...Yes?Brett8-) |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-07-24 : 16:10:21
|
| do do do do - NO |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-24 : 16:13:20
|
quote:
I putting money on the fact that you changed in EM...Yes?Brett8-)
Enterprise Manager actually uses the same scripts that we would use in Query Analyzer. Sometimes when I'm lazy, I'll make the change in EM without saving the change and just copy the script so that I don't have to write it. I'll then modify it if it needs to be modified (maybe constraint names or things like that) and then run it in Query Analyzer.Sam,Was the code modified on the web so that it no longer looks for the result column? I would increase the timeout value to say 5 minutes and see if it errors out. Then at least you'll know what the problem is. Then change the timeout value back. Also, run SQL Profiler to determine what exactly is running.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-24 : 16:15:01
|
| Did you do a DROP PROC/ CREATE PROC or an ALTER PROC?do do do do do do do do do do Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-24 : 16:41:06
|
| I'm still thinking it's a cache thing...Brett8-) |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-07-24 : 17:14:24
|
| I do the drop proc thing.I'm thinking it's user related. The web user is Public, the QA user is dbo, but it shouldn't matter.I'll run some more tests tonight when the users go home. It's a production web and it's busy during the day.Tara's question - it's a datagrid. Removing columns from the result rowset is handled automatically.It sounded a little like the sqlteam performance issue to me. Did we ever find out what that was?Sam |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-24 : 17:17:28
|
quote:
Did we ever find out what that was?
I doubt it considering that performance is still slow here.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-25 : 09:27:42
|
quote:
It sounded a little like the sqlteam performance issue to me. Did we ever find out what that was?
I seriously doubt it's the database...esp with the db not found messages...Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-25 : 14:24:38
|
| SamEver figure it out?Brett8-) |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-07-25 : 14:38:20
|
| Brett Trying to break 2000 before the weekend?????JimUsers <> Logic |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-25 : 15:13:29
|
quote:
Brett Trying to break 2000 before the weekend?????JimUsers <> Logic
Still too many...and it's starting to get late here on the East Coast...Can already here the happy hour bell ringing...or is that just my ears?Either way...doesn't matter to me...I think this weekend it'll beTEQULIAdun da da da-da dun dundun da da da-da dun dunTEQULIAda da daaaaaaaaaaaaaa dada da daaaaaaaaaaaaaa dada da da da da!TEQULIAMaybe I should go now...Brett8-) |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-07-27 : 15:46:30
|
This is the same problem in[url]http://sqlteam.com/forums/topic.asp?TOPIC_ID=27995&whichpage=1[/url] |
|
|
|
|
Twilight Zone