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. While auto-growth will likely be enabled per database, the transaction log file should already be […]

Read More»

SQL Query App-V 5.0 Usage

You can use the following query on your App-V 5.0 reporting server database (AppVReporting) to get application usage information for which users ran which software on which systems and when. Filed under: App-V 5.0

Read More»

SQL Server browser support: No Chrome here

I was researching an issue today where if you try to edit reports for ConfigMgr 2012, it fails.  And, depending on where you attempt to edit them (site server console or console on a client), you get different errors.  Sure enough, there’s a KB Article for this issue already: Editing reports in Configuration Manager may fail when Internet Explorer is...

Read More»

Machines with no CM07 client…

Alright, so if you read my previous post for AD to DB then this post will make more sense.  However if you haven’t; then now would be a good time to… go ahead, I’ll wait. Now one of the primary purposes I had for this data was to leverage it against my v_r_system view and determine which active assets are...

Read More»

ConfigMgr / SCCM 2012 – How to Edit Site Control ( sitectrl ) File

Disclaimer – Directly Editing/Updating Data Base or Site Control (sitectrl) file is NOT supported. We all know that ConfigMgr 2012 doesn’t store the Site Control ( sitectrl ) file in the file system. However, it’s stored in the SQL database (as XML file). Following are the 3 topics that I would like to cover in this post…… ****Only applicable to...

Read More»

ConfigMgr (SCCM) – SLP-MP Health Check Script

I would like to share a very useful script to check the availability/functionality of Management Point (MP) and Server Locator Point (SLP) in a ConfigMgr environment. Download the script and read the full post @ http://anoopcnair.com/2012/01/13/configmgr-sccm-slp-mp-health-check-script/ Usage SLP-MP Health Check Script can be scheduled to run automatically with no user intervention. To run the SLP-MP Health Check Script, download the script...

Read More»