February 15, 2008 at 1:27 pm
Hello,
A customer of mine experienced a power outage and immediately afterwards noticed a decrease in performance.....but only in certain areas of the application. The last time this happened to them I was able to defrag all indexes and that corrected the issue. It happened again to the same area of the application but this time defragging the indexes did not help. DBCC CHECKDB doesn't return any errors. Any suggestions? Perhaps I need to recompile all stored procedures? :crazy:
Any help would be greatly appreciated!!
February 19, 2008 at 1:43 pm
My guess is that the perf drop is because the buffer pool and procedure cache went cold - i.e. everything that was resident in them from a steady-state workload was lost due to the power outage.
Did they see perf slowly come back up to pre-outage levels?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
February 21, 2008 at 3:05 pm
Thanks for the info Paul - and yes, they did see performance improvements after a couple of days but now it seems to be back to where we were right after the power outage....very strange.
February 21, 2008 at 4:13 pm
Be sure you've looked for hardware errors. I've seen this happen with RAID arrays while a rebuild is taking place. You might have failing drives, so rule this out.
February 21, 2008 at 5:01 pm
Thanks Steve. I'm actually able to reproduce the issues on other servers so that rules out hardware.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply