Developed a report to show all servers that have collection maintenance windows. Very handy for cross checking servers in multiple maintenance windows, or supplying a list to support change control. Here is the query: -- List Computers with Maintenance Window … Continue reading →
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 […]
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 date. The impact is a database that continues to run slower and slower. The CMMonitor [...]
Background (bug previously filed on connect) I’ve found that the indexes on our SQL Server instances for Configuration manager to be severely fragmented. In investigating, I discovered that even though the Rebuild Indexes site maintenance task was set to run 1x /week, it never ran. Our SQL Server installations are remote on the CAS and [...]
As promised, attached are the demo files used for the session ‘UD-B407 – Advanced SQL Queries beyond the basics’ presentation. SQL Demo PowerShell Demo CMMonitor Demo (DB optimization) For those of you that were there, thank you for the session feedback and comments. Thanks to you, this session ranked #8 out of the top 10 [...]
After a lot of time searching for the latest SQL Server service pack and latest CU (Cumulative Update) for different flavors of SQL Server I found the following: Update Center for Microsoft SQL Server http://technet.microsoft.com/en-us/sqlserver/ff8033...
Formatting data within SSRS is fairly easy, for each field there is a format property. By referencing and applying the standard format strings (link below), converting data to something like a percent is simple. The percent is symbolized by a “P” . This reporting case was a little different, as the data was provided as [...]
Kindle version was just released! System Center 2012 Configuration Manager Unleashed “Paperback” (1360 pages!) should be arriving in Pearson’s warehouse next week. Disclaimer: I authored the chapter on Reporting Services, despite that, this is a fine book 😉
Formatting data within SSRS is fairly easy, for each field there is a format property. By referencing and applying the standard format strings (link below), converting data to something like a percent is simple. The percent is symbolized by a “P” . This reporting case was a little different, as the data was provided as numeric and provided as a percentage. If I used the percentage symbol, the data...
Hot off the Microsoft press! The Microsoft System Center team is announcing the release and general availability of the Software Development Kit (SDK) for System Center 2012 Configuration Manager. The System Center 2012 Configuration Manager SDK can be downloaded at no cost today at: http://www.microsoft.com/en-us/download/details.aspx?id=29559.
System Center 2012 offline documentation, now available! http://www.microsoft.com/en-us/download/details.aspx?id=29901
A lot of folks have been asking when will ConfigMgr support SQL Server 2012. Here is the update on that, it is only supported if ConfigMgr 2007 SP2 and R3 are installed on SQL Server 2008, or SQL Server 2008 R2 and then upgraded to SQL Server 2012. An install of ConfigMgr directly to SQL Server 2012 is not supported. For more information, please read http://blogs.technet.com/b/configmgrteam/archiv...