Wednesday, September 15, 2010

Defragmenting Virtual Center 4.x (Update)

In SQL Server Management Studio:

Use
go
dbcc showcontig (VPX_HIST_STAT1)
dbcc showcontig (VPX_HIST_STAT2)
dbcc showcontig (VPX_HIST_STAT3)
dbcc showcontig (VPX_HIST_STAT4)
go

If fragmented run:
dbcc indexdefrag ('', 'VPX_HIST_STAT1', 'PK_VPX_HIST_STAT1')
dbcc indexdefrag ('', 'VPX_HIST_STAT2', 'PK_VPX_HIST_STAT2')
dbcc indexdefrag ('', 'VPX_HIST_STAT3', 'PK_VPX_HIST_STAT3')
dbcc indexdefrag ('', 'VPX_HIST_STAT4', 'PK_VPX_HIST_STAT4')
go

Monday, September 13, 2010

How to disable DEP fully

bcdedit.exe /set {current} nx AlwaysOff