Setting db to multi_user taking several minutes

Setting db to multi_user taking several minutes

Post by squiso » Fri, 20 Jul 2007 05:42:12


I'm trying to change a database from restricted_user to multi_user.
In most cases, this finishes in a second or two but at times this
takes 3-5 minutes to complete. I'm running it in the master database
and there are no users in the database I'm trying to switch to
multi_user (not that it should matter). There's no blocking and not
really any activity on the server. Any ideas why this might be
happening?