December 20, 2007 at 11:06 pm
I am running a maintenance plan and am curious if the performance should be better running it in single user mode rather than in multiple user mode? I want to say yes, but running them in both modes, there doesn't seem to be any difference in the amount of time it takes.
I kind of thought the amount of time it took to run optimizations and re-indexing was determined by the amount of data in the database. I was recently told that running this maintenance in single user mode would run it faster.
Can someone confirm or disprove this?
Thanks!!
December 21, 2007 at 4:59 am
technically running in single user mode would be quicker as you would not suffer from any contention or user activity. Some commands require single user to run, e.g. rebuilding system table indexes.
but on a server without any users the actual execution would not be quicker in my opinion.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply