My Favorite Blogs

Tuesday, December 15, 2009

Using SQL Server 2008 PBM to Monitor Free Space

In this article I’m walking you through how to setup data file free space monitoring using SQL Server 2008 Policy-Based Management feature. You may think “Hey dude this is not a monitoring tool…!” but my answer would be “We can make this feature monitor data files free space on a database or instance”. Initially I wondered about introducing Policy-Based Management in SQL Server 2008. I know little bit about using policy management in Windows to enforce security policies and I felt that it is little complicated. But when I started working on Policy-Based Management in SQL Server 2008, I found it is really a cool and interesting feature which provides lots of options and flexibility to enforce your required policies in a database environment. Read more