on 2010 Nov 16 11:26 AM
Hello
We installed the LVS 1.0 in our clients servers. We have one big problem with only one.
We started the LVS service and just starting we can find this message error in the system log (Application):
DataManagerService.ReceiveEventInfo: String or binary data would be truncated.
The statement has been terminated.
This message appears too many times and the result is that msdb database log file grows so fast, and the server has no free space.
Is this issue solved in LVS 2.0?
If it is not, is there any solution? Does anybody have this issue?
TIA
Agustín Marcos Cividanes
Request clarification before answering.
Hello Agustín,
We had the same problem on our own server. We stopped the service and later deinstalled LVS. We had big problems to shrink msdb. We found these links:
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
This helped us to shrink msdb:
We found our problem described here (in german language)
Unexpected massive growing of mdsb
Regards
Bernhard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
39 | |
5 | |
5 | |
5 | |
3 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.