Archive

Archive for the ‘SQL Server Management Pack’ Category

SQL Database – To Grow or Not to grow

November 13, 2009 Leave a comment

The SQL team have released this guide- – Considerations for the “autogrow” and “autoshrink” settings in SQL Server which is useful reading:
http://support.microsoft.com/kb/315512

Of course OpsMgr doesn’t monitor database size of databases set to autogrow (except the OpsMgr database itself) – if you need this functionality, you need to copy the monitors \ rules and edit the scripts.

Advertisements

Disabling SQL Server Discovery

July 27, 2009 Leave a comment

To disable discovery of MSDE \ SQL Express:

http://www.scom2k7.com/disabling-sql-express-instance-discoveries/

http://ops-mgr.spaces.live.com/Blog/cns!3D3B8489FCAA9B51!1914.entry