{"id":247,"date":"2016-12-12T21:46:11","date_gmt":"2016-12-12T19:46:11","guid":{"rendered":"http:\/\/itsimple.info\/?p=247"},"modified":"2016-12-12T21:46:11","modified_gmt":"2016-12-12T19:46:11","slug":"vmware-vcenter-database-over-10-giga","status":"publish","type":"post","link":"https:\/\/itsimple.info\/?p=247","title":{"rendered":"vmware vcenter database over 10 giga"},"content":{"rendered":"
Vcenter running SQL Express. \u00a0“VIM_VCDB” reached 10GB and so crashes Vcenter !!<\/div>\n
To purge the data in the VPX_EVENT<\/span><\/code> table:<\/div>\n
    \n
  1. Connect to Servername<\/em>\\SQL Database<\/span><\/code> and log in with the appropriate credentials.<\/li>\n
  2. Click databases<\/b> to expand and select\u00a0VIM_VCDB<\/strong> > Tables<\/strong>.Note<\/strong>: By default, the vCenter Server database is named\u00a0VIM_VCDB<\/span><\/code>, unless it was renamed during initial creation.<\/li>\n
  3. Right-click the dbo.VPX_PARAMETER table and click Open<\/strong>.Note<\/strong>: If you are using SQL Server 2008, right-click the dbo.VPX_PARAMETER table and click Edit Top 200 Rows<\/strong>.<\/li>\n
  4. Modify event.maxAge<\/span> to 30<\/span> and the event.maxAgeEnabled<\/span> value to true<\/span>.<\/li>\n
  5. Modify task.maxAge<\/span> to 30<\/span> and the task.maxAgeEnabled<\/span> value to true<\/span>.Note<\/strong>:\u00a0To improve the time of the data cleanup, run the preceding steps in several intervals:\n
      \n
    1. Ensure to keep the\u00a0default value of event.maxAge<\/span>\u00a0and\u00a0task.maxAge.<\/span><\/li>\n
    2. Perform step 6 to run the cleanup.<\/li>\n
    3. Reduce the\u00a0event.maxAge<\/span>\u00a0and task.maxAge<\/span>\u00a0value by 60 and run the cleanup.<\/li>\n
    4. Repeat the steps a-c\u00a0until\u00a0the value is\u00a0reached to\u00a030 for the final cleanup process.<\/li>\n<\/ol>\n<\/li>\n
    5. Run the built-in stored procedure:\n
        \n
      1. Go to VIM_VCDB<\/strong> > Programmability<\/strong> > Stored Procedures<\/strong>.<\/li>\n
      2. Right-click dbo.cleanup_events_tasks_proc<\/strong> and select Execute Stored Procedure<\/strong>.This purges the data from the vpx_event, vpx_event_arg<\/span>, and vpx_task<\/span>\u00a0tables based on the date specified for maxAge<\/strong>.<\/li>\n
      3. When\u00a0purging\u00a0is\u00a0successfully completed, close the\u00a0SQL Management Studio and start the VMware Virtual Center Server service.<\/li>\n<\/ol>\n<\/li>\n
      4. Ensure that the default Statistics Level is set to 1:\n
          \n
        1. Using the vSphere Client, log in to vCenter Server as an administrator.<\/li>\n
        2. Go to Administration<\/strong> > vCenter Server Settings<\/strong> > Statistics<\/strong>.<\/li>\n
        3. Under Statistics Intervals,<\/em> ensure the Statistics Level column is set to 1<\/span>.<\/li>\n
        4. To change the value, select the Interval Duration<\/strong>, click Edit<\/strong> and select Level 1<\/strong> from the list.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
          Notes<\/strong>:<\/div>\n