July 24, 2003 at 11:51 pm
Hi,
A user complained about a report taking much longer to run than it used to. Sure enough - it is a dog so I started working on the sql but really got onto the wrong track so, to recover quickly, I restored my database from my last nights backup. And now the report's execution speed is what it used to be!!
What kind of housekeeping takes place during a restore that changed things so dramaticaly? In our production system the only housekeeping we do is a dbreindex on all tables. Should we, can we, do more?
We run sql2K (sp3) and have a moderate size database with a few tables that are currently in the mllion + row range. The database is only 6 months old and is 1+ Gb in size.
Cheers, Peter
July 25, 2003 at 6:06 am
I'd guess corrupted stats, or maybe you just had bad query plans in memory. If it happens again, those two are easy enough to investigate.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply