T
TheMadDBA
Guest
Are you seeing any errors in any of the logs? I can see statistics causing performance problems, but not kicking other users out of the system. As far as updating statistics... if you have sample SQL that is causing issues make sure to update those tables first before moving to the others. Either that helps those queries or it doesn't. That would at least give you a hint that your are on the right path or there is another issue (bugs or isolation level). Unless of course your DB is small enough to do them in all very quickly. It would take all day here 
Continue reading...
Continue reading...