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.- Become a Facebook Fan
- Subscribe to Anticlue
- Follow me on Twitter
- Add to Technorati Favorites
- Digg this post
0 Comments to “Slow response with alot of dbs in one SQL Server instance?”
Please share your thoughts and suggestions
-
Receive Our eNewsletter
The latest Project Management and Healthcare IT practices
-
About Me
Welcome to the Healthcare IT Project Management Blog of Elyse Nielsen. This is the place where I share the ideas I have learned, the things I’d like to remember, and my thoughts for a brighter future. Find out more.
Subscribe to Our Tips
Powered by Movable Type 4.31-en | Elyse Nielsen ©2003 - 2010
This weblog is licensed under a Creative Commons License.
This weblog is licensed under a Creative Commons License.