ããVMwareçvCenter Serveræ°æ®åºå°±å¦åVMwareçåå¨åºãå¨vCenteréï¼å åä¸ªè¡¨æ ¼åå¨çèµæºãé群ãVMwareåå¸å¼èµæºè°åº¦ç¨åºãå¿«ç
§ãVMware ESX主æºãèææºãè¦åãæ§è½åæ°ãä»»å¡åäºä»¶çä¿¡æ¯ã
ããé®é¢æ¯å¦æç¯å¢éæ¥æ许å¤VMware主æºæå¡å¨åèææºï¼æ°æ®åºå¢é¿å¾é常大ãä¸è¿å¢é¿ç空é´ä¸»è¦æ¥èªå°æ°å 个å
æ¬ä»»å¡ãäºä»¶ååå²æ§è½æ°æ®çè¡¨æ ¼ï¼åè§ä¸é¢çæè¿°ï¼ãä»vCenter Serveræ°æ®åºå é¤æ å
³çä»»å¡åäºä»¶è½è约空é´ãæåç³»ç»æ§è½ãå éå¤ä»½åæå°åæ°æ®åºå´©æºçæ¦çãå¨æ¬æä¸ï¼TechTargetä¸å½çç¹çº¦èæåä¸å®¶Eric Siebertå°ä»ç»å¦ä½ä½¿ç¨å¾®è½¯çSQL Serverä»vCenteræ°æ®åºå é¤ä¸éè¦çä¿¡æ¯ã
ãã
ããæä½vCenterè¡¨æ ¼æ°æ®
ããä¸è¿å¨æ¸
çæ件ä¹åï¼ä½ åºè¯¥æç½vCenter Serverçè¡¨æ ¼æ°æ®ãä¸é¢æ¯æå
³è¿äºè¡¨æ ¼çä¿¡æ¯ç±»åç®è¦ã
ããä»»å¡ä¿¡æ¯ãè¿ä¸ªè¡¨æ ¼å
æ¬å¨vCenter Serveræ§è¡çææä»»å¡çä¿¡æ¯ã
ããVPX_TASK
ããäºä»¶ä¿¡æ¯ãè¿ä¸ªè¡¨æ ¼å
æ¬ææåçå¨vCenter Serverçäºä»¶çä¿¡æ¯ã对äºæ¯ä¸ä¸ªäºä»¶ï¼VPX_EVENTè¡¨æ ¼éå æä¸è¡ï¼ç±äºEVENT_IDå段ï¼æä¸è¡ææ´å¤è¡å¨VPX_EVENT_ARGã
ããVPX_EVENT
ããVPX_EVENT_ARG
ããåå²åæ°ãè¿äºè¡¨æ ¼å
æ¬vCenter Serveræ管çç主æºä¸èææºçæ§è½è®°æ°ä¿¡æ¯ã对äºvCenter Server 2.0.xæå¡å¨æ¥è¯´ï¼è¿ä¸ªä¿¡æ¯åå¨å¨å个çVPX_HIST_STATè¡¨æ ¼éãä½å¨vCenter Server 2.5éï¼è¿ç§æ¹å¼æ¹åäºï¼æ¯å¤©çæ§è½æ°æ®åå¨å¨VPX_HIST_STAT1éï¼ç¶åèå
¥VPX_HIST_STAT2计ç®æ¯å¨æ°æ®ï¼æåï¼èå
¥VPX_HIST_STAT4计ç®æ¯å¹´æ°æ®ãæ¤å¤ï¼æåä¸ªæ ·æ¬æ¶é´è¡¨æ ¼ç¨äºVMwareè¿ç§»æå·§ââç½ç®ä¹¦åå²æ§è½è¡¨æ ¼ã
ããVPX_HIST_STAT (VC 2.0.x)
ããVPX_HIST_STAT1 (VC 2.5)
ããVPX_HIST_STAT2 (VC 2.5)
ããVPX_HIST_STAT3 (VC 2.5)
ããVPX_HIST_STAT4 (VC 2.5)
ããVPX_SAMPLE_TIME1 (VC 2.5)
ããVPX_SAMPLE_TIME3 (VC 2.5)
ããVPX_SAMPLE_TIME3 (VC 2.5)
ããVPX_SAMPLE_TIME4 (VC 2.5)
ãã使ç¨vCenter Serveræ¸
é¤æ°æ®
ããéè¿æ´æ¹åæ°é´éé
ç½®ï¼è½é´æ¥å°ä½¿ç¨vCenter Serveræ¸
é¤æ°æ®ãå½ä½ æ´æ¹æ个é´éï¼åªæå
³äºè¿ä¸ªé´éçæ°æ®è¢«æ¸
é¤ãä¾å¦ï¼å¦æä½ åªæ´æ¹æ¯å¨é´éï¼å°±æ¸
é¤äºæ¯å¨æ°æ®ï¼ä½æ²¡ææ¸
é¤æ¯å¤©ãæ¯æåæ¯å¹´çæ°æ®ãä½ ä¹è½æ´æ¹ææ¶éçæ°æ®æè
ç¦ç¨é´éï¼è¿å°åå°VPX_HIST_STATè¡¨æ ¼ç大å°ã
ããæå 大åå éè¦å é¤è¿ä¸ªæ°æ®ãé¦å
æ¯ä¸ºäºéä½å¨æ°æ®åºæå¡å¨ä¸ä½¿ç¨ç空é´æ°éãå¨å¤§åç¯å¢éï¼è¿æ ·ççæ°æ®åºå¾å®¹æå°±å¢é¿å°20GBï¼è½ç¶è¿å¯è½å¯¹äºè¿è¡å¨å¤§åæ¬å°ç£çä¸çSQL Serverä¸æé®é¢ï¼ä½å¨ä½¿ç¨ä¸ååå¨åºåç½ç»çç£ç空é´çæ°æ®åºæå¡å¨ä¸å°±æé®é¢ã
ãã第äºä¸ªåå æ¯æ§è½ãæ°æ®åºè¶å¤§ï¼æ寻æ°æ®åå®æå¦æ´æ°ç´¢å¼è¿æ ·çæ°æ®åºæä½å°±æ´è±è´¹æ¶é´ãæåï¼æ¥æçæ°æ®è¶å°ï¼æ°æ®åºè¶ææçï¼åçå´©æºçæ¦çä¹è¶å°ãå¤ä»½æ°æ®åºçæ¶é´ä¹æ´å°ã
ããåºçº¿æ¯é®é®èªå·±æ¯å¦ççéè¦é£ä¹å¤çåå²ä»»å¡ååå²äºä»¶æ°æ®ãä½ å¨ä¸å¹´åæ£æ¥è¿æ°å¹´æ°æ®åï¼æ§çæ§è½æ°æ®å¯¹äºå¶å°çå®ç¹æä»·å¼ãä¸è¿å¦æä¸éè¦è¿ç§åè½ï¼å°±æ¸
é¤æ§æ°æ®ãåæ ·ï¼é¦å
èèä¸è¦æ¶éæ°æ®ãä½ å¯è½åªæ¶éæ¯å¤©åæ¯å¨çæ°æ®ç¨äºæ
éæ£ä¿®çç®çï¼å¹¶ç¦ç¨æ¯è¾ä¹
çæ¯æåæ¯å¹´çæ°æ®ã
ããæ£æ¥è¡¨æ ¼å¤§å°
ãã使ç¨SQLå½ä»¤ï¼è½æ£æ¥è¡¨æ ¼ç大å°ã对äºSQLæ°æ®åºæ¥è¯´ï¼ä½¿ç¨SQL*Plusæå¦å¤çSQL客æ·ç«¯å¨ç»å½å°æ°æ®åºï¼ä½¿ç¨ä»¥ä¸çSQLå½ä»¤ï¼
ããselect count (*) from VPX_EVENT
ããè¿ä¸ªå½ä»¤æ¾ç¤ºäºè¡¨æ ¼éçè¡æ°ï¼æè®°å½ï¼ã对äºå
¶ä»è¡¨æ ¼ï¼æ´æ¹è¡¨æ ¼å称æ¥çã
ããselect num_rows * avg_row_len from user_tables where table_name = 'VPX_EVENT'
ããè¿ä¸ªå½ä»¤ä»¥åèå½¢å¼æ¾ç¤ºè¡¨æ ¼æ£å¨ä½¿ç¨çç£ç空é´æ°éï¼ä¸å
æ¬å©ä½çè¡¨æ ¼ç©ºé´ã
ããselect bytes from user_segments where segment_name = 'VPX_EVENT'
ããè¿ä¸ªå½ä»¤ä»¥åèå½¢å¼æ¾ç¤ºè¡¨æ ¼æ£å¨ä½¿ç¨çç£ç空é´æ°éï¼å
æ¬å©ä½çè¡¨æ ¼ç©ºé´ã
ãã对äºSQL Serversï¼éè¿ä»¥ä¸å½ä»¤ï¼è½ä½¿ç¨SQL Query Analyzerå·¥å
·ï¼ä½ä¸ºSQL serverçä¸é¨åå®è£
ï¼ã
ããå¨Queryçªå£è¾å
¥ï¼
ããuse
ããç¶åè¾å
¥ï¼
ããEXEC sp_spaceused
ããæ¥ä¸æ¥ç¹å»Execute Queryå¾æ ææF5ãè¿å°è¿è¡sp_spaceusedåå¨ç¨åºï¼æ¬è´¨ä¸æ¯ä¸ä¸ªSQLæå¡å¨èæ¬ï¼ï¼æ¾ç¤ºè¿ä¸ªè¡¨æ ¼çä¿¡æ¯ï¼å
æ¬æ£å¨ä½¿ç¨çè¡æ°ãä¿åå¨è¡¨æ ¼é以ååèæ¾ç¤ºçç£ç空é´æ°é以åæ°æ®æå æ®çè¡¨æ ¼ç©ºé´çæ°éãæ³æ¥çå
¶ä»è¡¨æ ¼çè¿äºä¿¡æ¯ï¼åªéè¦ç¨å
¶ä»è¡¨æ ¼å称è¾å
¥ä¸é¢çå½ä»¤ã
ããç°å¨æ们ç¥éäºè¡¨æ ¼çæ
åµåå¦ä½å³å®å®ä»¬ç大å°ï¼æ们就è½æ¸
é¤æ°æ®äºãå¨è¿ç³»åçä¸ä¸ç¯æç« ä¸ï¼æ们å°ä»ç»å¦ä½ä½¿ç¨VMwareææä¾çSQLèæ¬æ¸
é¤æ°æ®ã
温馨提示:答案为网友推荐,仅供参考