Поделиться через

How SQL database free space monitoring works in the SQL management pack

  • Статья

<!--[if lt IE 9]>

<![endif]-->

Comments

  • Anonymous
    August 24, 2016
    I've seen this trigger a critical alert where a filegroup is being dropped. I'm not sure if it's meant to auto-close but it seemed that it didn't because the filegroup didn't exist anymore.
  • Anonymous
    October 06, 2016
    Good one!!
  • Anonymous
    November 03, 2016
    I keep getting alerts from this monitor where all possible 'free space' in db file, on disk, within reserved space are >10%. Something still is/feels wrong about this monitor.
  • Anonymous
    November 04, 2016
    Had to disable these monitors, as they were generating Alerts for Db files that were set to auto grow.This was also causing lots of state changes.
  • Anonymous
    January 18, 2017
    Very helpful!They changed the "DB Total Space" to an"DB Space Percentage Space". It monitors the DB Space Change in 5 Samples x 15 minutes.I think a better approach.Carsten
  • Anonymous
    March 01, 2017
    I have written a query from SCOM dbs to collect free space for All drives. I want to select only drives that has MDF or LDF files. How Can I identify those Drives into My Query.My query is select me.path as ServerName,case when c.IsVirtualMachine=1 then 'Virtual' Else 'Physical' END as ServerType, pd.datetime, me.DisplayName as DriveName,id.VolumeName_65571163_F69F_CFDB_49A1_2730285FD2A2 AS Label, [SizeInMBs_E70DED5C_3AE4_BDCD_1635_F40D15E608B7] AS TotalSize, [SizeInMBs_E70DED5C_3AE4_BDCD_1635_F40D15E608B7]-pd.averageValue as UsedSpace,pd.averageValue as FreeSpace, [SizeInMBs_E70DED5C_3AE4_BDCD_1635_F40D15E608B7]-pd.MaxValue as MaxUsed, [SizeInMBs_E70DED5C_3AE4_BDCD_1635_F40D15E608B7]-pd.MinValue as MinUsed, [SizeInMBs_E70DED5C_3AE4_BDCD_1635_F40D15E608B7]-pd.averageValue as AvgUsed , pr.Countername, pr.ObjectName,id.DriveType_67A23C3E_F435_A1B1_DE3E_D8C412E6D9D5 from perf.vPerfDaily pd inner join vManagedEntity me on me.ManagedEntityRowId=pd.ManagedEntityRowId inner join vPerformanceRuleInstance pri on pri.PerformanceRuleInstanceRowId=pd.PerformanceRuleInstanceRowId inner join vPerformanceRule pr on pr.RuleRowId=pri.RuleRowId inner join operationsmanager.dbo.MTV_Microsoft$Windows$Server$10$0$LogicalDisk id on id.BaseManagedEntityid=me.ManagedEntityGUID inner join [OperationsManager].[dbo].[MTV_Computer] C on c.DisplayName=me.Path where pr.ObjectName='Logicaldisk' and pr.CounterName='Free Megabytes'