Welcome to Management Pack Wiki! Your documentation pro for SCOM Management Packs
0 comment(s) Post a comment
  • Management Pack:  SQL Server
  • MP Version:  6.1 for SQL Server 2008
  • Released:  8/5/2010
  • Publisher:  Microsoft

SQL 2008 DB File Group Class

  • ID:  Microsoft.SQLServer.2008.DBFileGroup
  • Description:  Microsoft SQL Server 2008 database file group
  • Class Hierarchy: 
    Entity
    Logical Entity
    Application Component
    Windows Application Component
    SQL Component
    SQL DB File Group
    SQL 2008 DB File Group

  • Attributes:  Public, Hosted
Login
Monitors the auto close setting for the database Monitors the auto create statistic setting for the database Monitors the auto shrink setting for the database Monitors the auto update statistics async setting for the database Monitors the auto update statistics setting for the database Monitors the DB chaining setting for the database Monitors the trustworthy setting for the database Monitors the page verify setting for the database. Monitors the recovery model setting for the database. Monitors for a large change in value of database available space over a set number of sample periods. Monitors the space available in the database and on the media hosting the database in percentage terms. This monitor checks the status of the database as reported by Microsoft® SQL Server™. This monitor checks the status of the SQL Database Engine service. This monitor detects when a log shipping destination has not had a log restored to it within the threshold defined as a part of the log shipping configuration. This monitor detects when a log shipping source has not had its logs backed up within the threshold defined as a part of the log shipping configuration. This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log in percentage terms. This monitor is DEPRECATED. Monitors the space available on the log files and on the media hosting the log files in megabytes. This monitor is DEPRECATED. Monitors for the free space left in the database in terms of megabytes. Monitors the space available on a database file and on the media hosting the file in percentage terms. Monitors the free space percentage left on a disk drive. Microsoft SQL Server 2008 database file group Microsoft SQL Server 2008 database Microsoft SQL Server 2008 database file

Download diagram as a Visio file

Properties

Display Name Description
Display Name Display name of monitoring object.
Group ID (Key)  
Group Name  
Read Only  
Size (MB) (Deprecated)  

Discovered By

Name Description
Discover File Groups This object discovery discovers the file group groupinformation for each SQL Server 2008 Database.

Relations

Health Source
NameClassType
SQL Server 2008 File Group Hosts File SQL 2008 DB File Group Hosting
Entity Watched By Perspective Entity Reference

Health Target
NameClassType
SQL Server 2008 Database Hosts File Group SQL 2008 DB File Group Hosting

Class Knowledgebase

Summary
This class does not contain any summary.
External References
This class does not contain any external references.

See Also for SQL Server Management Pack


Downloads for SQL Server Management Pack

Post a comment
Comments to other elements of this Management Pack:
Article Message Posted By
Overview
We are providing a platform for those who want to join this profession.
writing jobs
jobs
shahid.afraid111@gmail.com at 10/29/2014 11:48:42 AM
Overview
Is Management Pack inventory available for SQL Server 2012 MP version 6.5.1.0?
milmanfm@gmail.com at 9/23/2014 11:36:42 AM
Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQ
Due to over storage of SQL database files the memory allocation refuses and creates some errors which are responsible for SQL database inaccessibility. You must go through this to learn more about resolving solutions:- http://www.sqlrecoverysoftware.net/blog/sql-error-926-and-945.html
enriquemallon@gmail.com at 6/28/2014 10:10:17 AM
Database consistency errors found
I recommend you to read this article which serve you how get rid of this consistency error:- http://www.sqlrecoverysoftware.net/blog/fix-database-consistency-errors.html
elliswhite43@gmail.com at 5/10/2014 11:06:07 AM
Overview shantal@list.ru at 7/2/2013 11:57:28 AM
Overview
Where can i get the Management pack Inventory for SQL 2008
vivakhangloo@gmail.com at 4/4/2013 8:32:16 AM
Overview
According to the Pinpoint catalog, the SQL MP was updated to include SQL 2012 monitoring as of 4/2/2012. Do you have an ETA for when this MPwiki entry will be updated? Keep up the great work; thanks!
bdady@denaliai.com at 5/30/2012 2:47:22 PM
DB File Space
You should keep in mind that file-level monitoring works rather good now but in case of extremely loaded server (e.g. which works all the time about 99% of CPU) or you have really huge number of DBs and files (e.g. 500 databases consist of 1000-2000 files) - you should think about Database-level space monitoring.
legolasishe@mail.ru at 3/21/2012 1:39:09 PM
Overview shantal@list.ru at 11/4/2011 3:29:24 PM
Overview igrudina@viacode.com at 10/26/2011 4:12:53 PM