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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-02 : 11:03:43
|
| Greg writes "I am running SQL Server 2000 with sp3a.I have a stored procedure that runs a number of selects and creates a temp-table, etc.The query returns in about 20 seconds.Once I apply the MS03-031 Security Patch the Query takes 10 minutes, but it does return with the same result set.Opon review of the 2 execution plans I notice that the Parallelism is not being used once the patch is applied.The server has 4 CPU and 4 gig of ram.I ran sp_configure and it is set to 0 with the threshold at 5, same an before.Any thoughts on how to fix this problem?Thanks for any help." |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-02 : 11:17:59
|
| Welcome to SQL Team Greg!I've seen reports of certain queries slowing down when Service Pack 4 is installed. (i.e. things that had been running fine for months before the Service Pack)Does that sound like it may be anything to do with your MS03-031? (I don't know what that patch is for, sorry)Kristen |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-02 : 13:07:25
|
| MS03-031 is the recommended security hotfix to apply on top of SP3. It brings you to build 818 of SQL Server. I have not had any performance problems because of this patch. I wonder if regenerating statistics might fix things.-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-02 : 14:00:04
|
| "regenerating statistics"Sounds like a good plan ECKristen |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-08-02 : 17:21:08
|
| When I read through the fix-list for SQL SP4, I did see a few things that were fixes for MS03-031. You might want to check through, and see if you have any of those problems. Still, I have a feeling there is going to be an updated SP4 in the next month or two, so you may want to hold off on installing SP4, considering the uninstall of a service pack is not pretty. |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-02 : 19:46:21
|
| all of the problems with SP4 do not appear to be resolved yet. see paul's last comment...http://www.dbforums.com/t1174282.html====================================================Regards,Sean RoussyGENERAL ADVICE FOR EVERYONE: Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
|
|
|
MS03-031 Issue