New SQL MP released – version 6.0.6648.0 and why you NEED it.


 

Get it from the MP catalog:  http://technet.microsoft.com/en-us/opsmgr/cc539535.aspx

 

This is considered a “minor” update.  However, there are some SIGNIFICANT changes you should consider.  Not all of the changes are documented in the guide.

 

I did a XML diff of the files to see what is new:

 

Some of the changes:

  • In previous versions of the SQL MP, event based alerts generated from Windows 2003 based clusters did not work.  This has been fixed in this version of the MP. 
  • SQL 2005 “Database Status” Monitor inspects DB status (online, offline) every hour, from every 2 minutes UnitMonitor ID="Microsoft.SQLServer.2005.Database.DBStatusMonitor"
  • SQL 2005 “Disk Free Space” DB File freespace monitor now runs every hour, from every 2 minutes.  UnitMonitor ID="Microsoft.SQLServer.2005.DBFile.DiskFreeSpace"
  • SQL 2008 “Database Status” Monitor inspects DB status (online, offline) every hour, from every 2 minutes UnitMonitor ID="Microsoft.SQLServer.2008.Database.DBStatusMonitor"
  • SQL 2008 “Disk Free Space” DB File freespace monitor now runs every hour, from every 2 minutes.  UnitMonitor ID="Microsoft.SQLServer.2008.DBFile.DiskFreeSpace"

 

For these reasons alone, anyone running clustered SQL servers should consider rapidly moving to this MP.

I say that – with some caveats: In order to use this MP effectively – your agents must be EITHER:

 

OpsMgr 2007 R2

<OR>

OpsMgr 2007 SP1 with http://support.microsoft.com/kb/959865 applied.

 

The guide is a bit misleading – it states:

In order for this fix to work fully on Windows Server 2003 and Windows Server 2008 operating systems, all agents on clustered nodes need to be running Operations Manager 2007 SP1 or Operations Manager 2007 R2 with the update installed from Knowledge Base article 959865

This is technically misleading – in that it leads you to think you need to apply 959865 to your R2 environment to support this MP.  You don't.  959865 is an OpsMgr 2007 SP1 ONLY hotfix , and does NOT apply to R2.

Now – what if you don't want to apply this hotfix to SP1 – can you still run this MP?  Technically – Yes, however it will not work on Server 2008 failover clusters hosting a SQL instance.  There is a change in the way Server 2008 failover clusters log events… and a module was changed in R2, and in SP1-hotfix-959865, to address this.  That said – I strongly recommend you move to R2.  If you cannot move to R2, and will remain on SP1 for some time, I strongly recommend you apply 959865 to your management group.

Comments (0)

Skip to main content