Already found some information about the why and how. For a week now the System Center Operations Manager Support Team Blog has posted an article about, confirming my own findings. As it turns out, it’s related with the Auto Close setting on those particular databases. 
(Picture is ‘borrowed’ from the same blog posting.)
Want to know more? Go here. Thanks to Vikram Sahay for sharing.
2 comments:
What can you do if the customer will not allow you to make this change to their database?
Hi Jeffrey.
This is an old posting and to be frank, I am not sure whether this issue is still at play. The SQL MP has had many updates since this posting.
Please check the MP guide of the SQL MP for more information and read Kevin Holman's postings about the SQL Server MP and how to tune it. My guess is that the solution to your issue is far more likely to be found there than this old posting of mine.
Cheers,
Marnix
Post a Comment