problem slow queries after installing sp4 on sql 2000
in [Server Configuration]
|
Prev: Can you restore a backup from newer version of SQL Server to older version, if in compatibility mode?
Next: Difference between ORDER BY column value and column alias between different version of SQL server.
From: iNewbie on 25 Feb 2010 19:21 hi, we have a sql server 2000 sp3 on a w2003 and some days ago we installed sp4 to that sql instance. We are having some big problems with queries really slow down, taking to much long to complete or locking to themselves, ie. spid 105 locked by spid 105 if you throw a sp_who2. i've read that this was a common problem with sp4, so, is there any way to solve this? some hotfix that i don't know or something? i wouldn't like to detach databases, install sql server again, and reatach all databases.... thanks for any help!
From: Jay on 25 Feb 2010 19:46 This probably isn't it, but have you made sure statistics are updated? "iNewbie" <iNewbie(a)discussions.microsoft.com> wrote in message news:D343B80E-5E55-42B7-A3B4-6BF6134ABB2A(a)microsoft.com... > hi, we have a sql server 2000 sp3 on a w2003 and some days ago we > installed > sp4 to that sql instance. We are having some big problems with queries > really > slow down, taking to much long to complete or locking to themselves, ie. > spid > 105 locked by spid 105 if you throw a sp_who2. > i've read that this was a common problem with sp4, so, is there any way to > solve this? some hotfix that i don't know or something? i wouldn't like to > detach databases, install sql server again, and reatach all databases.... > > thanks for any help!
From: iNewbie on 26 Feb 2010 09:36
no, is not the problem but thanks for your reply. anyone? please some help... "Jay" wrote: > This probably isn't it, but have you made sure statistics are updated? > > "iNewbie" <iNewbie(a)discussions.microsoft.com> wrote in message > news:D343B80E-5E55-42B7-A3B4-6BF6134ABB2A(a)microsoft.com... > > hi, we have a sql server 2000 sp3 on a w2003 and some days ago we > > installed > > sp4 to that sql instance. We are having some big problems with queries > > really > > slow down, taking to much long to complete or locking to themselves, ie. > > spid > > 105 locked by spid 105 if you throw a sp_who2. > > i've read that this was a common problem with sp4, so, is there any way to > > solve this? some hotfix that i don't know or something? i wouldn't like to > > detach databases, install sql server again, and reatach all databases.... > > > > thanks for any help! > > > . > |