Hello, I'm executing a sql sentence on my sql server 2000 sp3, and some times It takes about 3 sec to execute It... and some times It takes about 5 min and later 3 sec again and so on ....
Could you please explain me this behavior ? This is so confusing cause It souldn't be happening and I'm working alone in this server... then no other process is running here...
any suggestion?
Thanks,
is it the same query/procedure ... Update the statistics and check the indexes also... if need rebuilt that
Madhu
|||Hello Julian,
As suggested by Madhu,please reindex and update stats before running the query again.
Is it a select statement with full outer joins and functions like convert etc.
There is a bug in SP3 that causes such behaviour with optimizer.
This has been fixed in SP4 + 2187.
http://support.microsoft.com/default.aspx/kb/830298/EN-US/
regards
Jag
|||Hello Jag...
What does + 2187 mean?
|||refer this:
http://www.microsoft.com/downloads/details.aspx?FamilyID=9C9AB140-BDEE-44DF-B7A3-E6849297754A&displaylang=en
Madhu
|||It means SP4 plus a hotfix to bring it up to build 2187|||Cheers Glen
No comments:
Post a Comment