先開啟/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1025914，并下載VCDB_Purge_MSSQL.zip

將下載的VCDB_Purge_MSSQL.zip解壓縮

開啟SQLServerManagementStudio，并登入

在做LOG刪除前請(qǐng)先停止vCenter服務(wù)在@CUTOFF_DATE中輸入30，這是確認(rèn)需刪除多天以前的LOG，在@DELETE_DATA中輸入1變更參數(shù)為刪除，點(diǎn)選執(zhí)行后，檢查執(zhí)行結(jié)果使否成功刪除LOG后請(qǐng)點(diǎn)選vCenterDB，點(diǎn)擊鼠標(biāo)右鍵”工作”壓縮數(shù)據(jù)庫(kù)9.點(diǎn)選確定開始?jí)嚎s數(shù)據(jù)庫(kù)10.最后檢查數(shù)據(jù)庫(kù)容量是否有縮小11）TotruncatethedataintheVPX_EVENTtable:ConnecttoServername\SQLDatabaseandloginwiththeappropriatecredentials.Expanddatabases>VIM_VCDB>Tables.Right-clickthedbo.VPX_PARAMETERtableandclickOpen.

Note:IfyouareusingSQLServer2008,right-clickthedbo.VPX_PARAMETERtableandclickEditTop200Rows.Modifyevent.maxAgeto30,andmodifytheevent.maxAgeEnabledvaluetotrue.Modifytask.maxAgeto30,andmodifythetask.maxAgeEnabledvaluetotrue.Runthebuilt-instoredprocedure:NavigatetoVIM_VCDB>Programmability>StoredProcedures.Right-clickdbo.cleanup_events_tasks_procandclickExecuteStoredProcedure.

Thispurgesthedatafromthevpx_event,vpx_event_arg,andvpx_tasktablesbasedonthedatespecifiedformaxAge.Whenthishassuccessfullycompleted,closeSQLManagementStudioandstarttheVMwareVirtualCenterServerservice.ToensurethatthedefaultStatisticsLevelissetto1:UsingthevSphereClient,logintovCenterServerasanadministrator.NavigatetoAdministrator>vCenterServerSettings>Statistics.UnderStatisticsIntervals,ensuretheStatisticsLevelcolumnissetto1.Tochangethevalue,selecttheIntervalDuration,clickEditandselectLevel1fromthedropdown.Notes:Theexecutionofdbo.cleanup_events_tasks_procmaytakealongperiodoftimedependingonthedatabasesize.Theoperationmayfailduetothetransactionlogsbeingfilledupatmultipleintervalsbasedonthedatat