MS SQL reporting incorrect information

[amurrey]

I am having an issue with Hyperic 5.8.0.0

I have the MS SQL driver installed and working.  I have the agent installed and working on an MS-SQL 2008 Server.

One of the metrics, "Database Free Space" is reporting 90 some percent.  When I look in SQL Server Management Studio, it shows around 3% for the database.

What gives here?

[admin]

Hi,

Sorry, but I can't find that metric. Did you mean "Database Free Percent" or "Data File Size" ?

Please verify relevant counters in perfmon and attach screenshots.

Good Luck

[amurrey]

Yes.  Database Free Percent.  Hyperic today is reporting 81%.  SQL Management Studio is reporting 3%.

I'm waiting on some screenshots from the DBA.

[amurrey]

DBNAME      FILENAME           CURRENTSIZE_MB           USEDSPACE_MB               FREESPACEMB               PERCENT_USED PERCENTAGE_FREE         PHYSICAL_NAME                             TYPE_DESC

production     database           1672626                                    1649246.5                          23379.4375                        98.60                                   1.397764652707778        E:\SQLData\sample.mdf               ROWS

production     database_log        358400                                639.132812                        357760.867188                 0.1783                                 99.821670532366071      I:\SQLLog\sample_Log.ldf           LOG

production     database2              1672626                             1622558.875                     50067.125                          97.07                                   2.993313358754438        H:\SQLData\sample2.ndf             ROWS

production     database3              563200                                546207.125                        16992.8125                        96.98                                   3.017189719460227        L:\SQLData\sample3.ndf              ROWS

[admin]

Hi,

Sorry for delay, I was in vacation

Please connect to your SQL Server instance as admin from SQL Management Studio, run attached script and attach output in CSV format.

In addition please make full screenshot (e.g. database name) of hyperic metrics for compare.