1 Reply Latest reply on Oct 3, 2017 7:41 PM by mandevil

    Database size report

    sukhjinder.bhullar

      Hi,

      Is it possible to get sql server database size historic data from solarwinds monitoring ?

       

      Regards

        • Re: Database size report
          mandevil

          What product are you using? If DPA, it would be a custom metric.

          Something like:

          SELECT

          cntr_value

          FROM

          sys.dm_os_performance_counters

          WHERE

          object_name LIKE '%:Databases%' AND

          counter_name = 'Data File(s) Size (KB)' AND

          instance_name = '_Total';

           

          Or use whatever you are comfortable. I'd think you could just run this once per day when you set it up, but then it should start plotting size over time.