廣告

2012 年 11 月
 1234
567891011
12131415161718
19202122232425
2627282930  

彙整

SQL Server 自動判別索引是否需要重建T-SQL與重建索引方式

參考網址:http://blog.miniasp.com/post/2009/01/18/Let-SQL-Server-Tell-You-Which-Indexes-to-Rebuild-or-Reorganize.aspx

自動查詢與建議索引重建之T-SQL語法:

SELECT ‘ALTER INDEX [‘ + ix.name + ‘] ON [‘ + s.name + ‘].[‘ + t.name + ‘] ‘ +

CASE

WHEN ps.avg_fragmentation_in_percent > 15

THEN ‘REBUILD’

ELSE ‘REORGANIZE’

END +

CASE

WHEN pc.partition_count > 1

THEN ‘ PARTITION = ‘ + CAST(ps.partition_number AS nvarchar(MAX))

ELSE ”

END,

avg_fragmentation_in_percent

FROM sys.indexes AS ix

INNER JOIN sys.tables t

ON t.object_id = ix.object_id

INNER JOIN sys.schemas s

ON t.schema_id = s.schema_id

INNER JOIN

(SELECT object_id […]

ESXi Patche檔案升級方式

ESXi Patche檔案升級方式

ESXi 5.1安裝版為 799733,Patch 為838463,且為個ZIP檔。

一、官網抓Patch檔

二、將檔案放到要升級的 ESXi Server儲存槽上

三、ssh連入要升級的ESXi Server內,下指令升級

~ # esxcli software vib install -d /vmfs/volumes/CS-VM-ESX-Server-Backup/ESXi510-201210001-838463.zip

====================

四、升級完成

Installation Result

Message: The update completed successfully, but the system needs to be rebooted for the changes to be effective.

Reboot Required: true

VIBs Installed: VMware_bootbank_esx-base_5.1.0-0.5.838463

VIBs Removed: VMware_bootbank_esx-base_5.1.0-0.0.799733

VIBs Skipped: VMware_bootbank_ata-pata-amd_0.3.10-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-atiixp_0.4.6-4vmw.510.0.0.799733, VMware_boot bank_ata-pata-cmd64x_0.2.5-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-hpt3x2n_0.3.4-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-pdc2027x_1. 0-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-serverworks_0.4.3-3vmw.510.0.0.799733, VMware_bootbank_ata-pata-sil680_0.4.8-3vmw.510.0.0.799733 , VMware_bootbank_ata-pata-via_0.3.3-2vmw.510.0.0.799733, VMware_bootbank_block-cciss_3.6.14-10vmw.510.0.0.799733, VMware_bootbank_ehci-ehci-hcd _1.0-3vmw.510.0.0.799733, VMware_bootbank_esx-dvfilter-generic-fastpath_5.1.0-0.0.799733, […]

vShere出現Configuration Issues System logs on host XXX are stored on non-persistent storage訊息

http://blog.xuite.net/itwiz/learning/63538884

Configuration Issues : System logs on host XXX are stored on non-persistent storage.

Because of I installed ESXi on USB Storage. So I got the warning message.

How to Fix it ?

1. Create a Directory , named ".locker" in One of datastore. 2. Config the Dir path in Configuration / Software / Advanced Settings […]