Dear All, I need your help for below requirement asked by one of our client- utilization alert for database growth of a particuler database on clustered (two node cluster) SQL servers. Database name: ABC SQL instance name: DEF Cluster group name: XYZ Is it possible to do. if yes can you provide steps for the same. your kind help will be highly appreciated.Rakesh Kumar

Hey Kumar You need two MP's, Windows server and SQL. With the two of them installed you will get database and log file free space and growth, including a critical alert on sudden rush growth. Let me know if you need more detailsPaul Keely

Hi, Please also refer to: SQL Server 2008 Cluster Monitoring Using SCOM 2007 R2 http://blogs.technet.com/b/birojitn/archive/2010/04/14/sql-server-2008-cluster-monitoring.aspx Regarding SQL Server MP, I would like to share the following with you: Microsoft SQL Server Management Pack for Operations Manager 2007 http://www.microsoft.com/downloads/details.aspx?FamilyId=8C0F970E-C653-4C15-9E51-6A6CADFCA363&displaylang=en#filelist Hope this helps. Thanks. Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Paul Thank you for your prompt reply. Paul Says - You need two MP's, Windows server and SQL. My reply - I have already installed both MPs. Paul Says - With the two of them installed you will get database and log file free space and growth, including a critical alert on sudden rush growth. My reply - We have five different database configured on the same instance and only need to monitor one database (ABC). Also required one scheduled report to be generated that will show the utilization for last one week. Rakesh Kumar

Hi Rakesh Go to the opsmgr console, and go to the operator section open the sql MP and open up "databases" and then select your database. On the right hand side you have a reports section, with your DB highlighted, select the report "SQL database space report" Run it on friday and select the previous monday as the start day. It should run and give you 2 pages, %MB free space on the data and log file and the actual Mb size of the data file on page two. Easy as you like Paul Keely

Hi Paul, it provides the report as below - Rule,instance, Object Scale Simple Count Min value Max value Average value Standard deviation i would like to have report as below - Instance name database name Day total Space(MB) used Space(%) free space (%) growth per day(MB) growth per day(%) DEF ABC monday 5000 50 50 5 .1 for all day should be like this. is it possible. your kind help will be highly appreciated. Rakesh Kumar

Hi, Can anyone help me on above request. your kind help will be highly appreciated.Rakesh Kumar

Hi, I will mark this as answer as no activity for a long time. Feel free to re-open the thread. ThanksAnders Bengtsson | Microsoft PFE | blog at http://www.contoso.se