VMware Solutions Discussions
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
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).
The NetApp Support Site won an Association of Support Professionals Best Support Website in 2022 award.
Live Chat, Watch Parties, and More!