on 09-23-2010 4:21 PM
Hi all,
Since we have started the License Validation Service a few days ago on our SQL server the system database msdb grows about 3.2 GB. We have seen that since the service has started the service SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 puts events in a special queue named WMIEventProviderNotificationQueue in database msdb. In the meantime we have over 800.000 events there.
Here it is explained how it works:
Understanding the WMI Provider for Server Events
http://msdn.microsoft.com/en-us/library/ms181893.aspx
We found our problem described here (in german language)
Unexpected massive growing of mdsb
Our productive system is on a vitual machine with 2 drives. Because of this problem on the system drive c is no space available.
Did someone else have seen this problem?
Kind regards
Bernhard Stuebner
Hello Bernhard
LVS does not use WMI. The only objects that are used for collecting information on the server side are SMO objects.
Regards
M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.