By chance, does this thread apply: "Performance improvement after detach/attach"?...
When we still had the prob, we tried the "WITH RECOMPILE" option in the proc, but it didn't help. Also, the execution plans were the same for the...
Update on our situation... We discovered that a batch job executed by an app was responsible for irrevocably causing the proc's performance to tank...
drewm, I'm curious... Have you made any progress on this? Unfortunately, we still have the same prob. & the apps folks are getting a little...
No on calling another proc, but Yes on using a UDF (returns a comma delimmited list of IDs). I recognize that the proc could be optimized....
For us, the exec plans are almost identical between good & bad. We haven't compared disk activity, but we monitored avg disk que length for the data...
mmarovic: It does a select only. Satya: yes, that topic is the same as my issue.
No recent serv packs. I looped "select lastwaittype, waitresource from master..sysprocesses where blocked !=0", and didn't see any "2:1:1" or...
In our case, the performance improvement was noticed on the 1st run after a detatch/attach. quote:Originally posted by joechang if you detach and...
Joe, Thanks for responding. In our case, that might make some sense given that the WHERE clause of the proc's query varies considerably....
HEYYYY!!!! I guess I should have searched the forums first. I just posted about the same issue (see post: "stored proc faster after restore or...
Adriaan, thanks for replying. The PK is on the 1 side. However, there is no FK on the other table. There aren't any nulls for the many table, and...
A little help with this one would be most appreciated. We've got a SQL 2000 prod db on a Win 2K server that has a poor performing stored proc (takes...
Separate names with a comma.
