2015-02-06 01:32 AM
At our vSphere 5.1 environment, the SQL Express database has filled up, which led to crash the vCenter service.
The database has been flooded with entries in the tables VPX_EVENT and VPX_EVENT_ARG.
Over a sql query, we found that in 5 minute intervals login and logout sessions are created in both tables.
In the vSphere Web Client it could be analyzed in more detail with the logging events.
An un- and reinstalling of the vsc plugin at least brought the improve, that is no longer a one second frequency interval of the logging, but every five minutes.
After searching the internet, we have the log files of the vsc plugin in windows closer viewed -> " C:\Program Files\NetApp\Virtual Storage Console\ log".
The main reason for the filling of the tables in the vCenter database is the log file named "requests-2015_xx_xx.log".
The following entries in the log file is filling the tables in the database until it comes to a standstill.
Unfortunately i found no configuration option in the vsc plugin, which stops these log entries or reduces them.
I do not know why these entries are created or for which they are needed.
I would be very grateful if someone could propose a solution for it.
Thank you very much
2015-02-09 04:50 AM - edited 2015-02-09 04:54 AM
Hello Turabo. Thanks for your answer, so I'm not alone with my problem.
Here is the solution that I have found and implemented so far.
Add a "Scripts" Folder to your windows server.
Make an sql-query that deletes the entries of the NetApp Plugin from the affected tables (see appendix).
Make a batch file, that executes the sql-query (see appendix)
Add the batch-file to an scheduled task on the windows server an run it every evening.
also add an scheduled task, to shrink and maintenance the vCenter database once a week (sunday evening).