We have a data warehouse server running SQL Server 2005 Enterprise Edition. Lately, after a restructure, we're seeing some performance hits. If this is due to what was added during that rebuild, we have no problem with it. However, we are not sure. When a query is run, the disk queue fluctuates greatly, but a lot of memory remains free. We're collecting some counters now, but once we have the data, what conditions can we look for?
January 21, 2009 6:27 PM
January 22, 2009 1:46 AM