On Tue, Jun 22, 2010 at 11:11 AM, Maddin, Peter <[email protected]> wrote: > > Now that it has exceeded 25GB in size there are timeouts on some select > statements and the accumulative affect of these is having a detrimental > impact on the system as a whole.
FWIW, you should be able to run the sql trace (sql server profiler, i think it's called) program to get an idea of what is taking so long to execute. It might be worthwhile to have this run for a period of the day, and then revie the logs (maybe in comparision with general load on the server). Inline with other comments, it wouldn't be surprising to find out that something else is causing the timeouts. -- silky http://www.programmingbranch.com/
