Please Share Feedback


Questions, comments, suggestions? Let us know what you think on our Forum.

To contact us privately, please use our contact form.

Author: Elyse, PMP, CPHIMS
June 19, 2005


Back in January MS released this cool performance tweak to the sp_MSdbuseraccess stored procedure. If you are in an environment that has a lot of db's on one box, originally sp_MSdbuseraccess would check on each db the level of access you have. With the modified procedure, it checks to see the level of access you have only of the dbs you can access, instead of all of the dbs on the server.

Subscribe and Share!

Did you enjoy this article? Your feedback is very important! I'd like to invite you to keep up to date with the latest posts from Anticlue. We offer several venues. If you have some questions, help can be found here.
 

0 Comments to “Slow response with alot of dbs in one SQL Server instance?”


« Barbecue: A Java Barcoding Solution Why IT governance fails »

Please share your thoughts and suggestions