Monthly Archives: May 2013

Virtual Log Files and impact on ConfigMgr performance

  VLF (Virtual Log Files) can have a negative effect on database performance. Too many VLFs will slow down the startup, shutdown and read/write performance of any database. VLFs are created when a transaction log file is allowed to auto-grow. … Continue reading

Posted in ConfigMgr, SQL Server | 1 Comment

Optimizing ConfigMgr databases

Installing and configuring the CMMonitor database Background The SCCM 2007 and Configuration Manager built-in site maintenance index rebuild task does not always run. The consequence is a ConfigMgr database with indexes that are fragmented and statistics that are out of … Continue reading

Posted in ConfigMgr, SQL Server | 32 Comments