Red Gate forums :: View topic - What's the table name that holds used space on a volume
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

What's the table name that holds used space on a volume

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sql-lover



Joined: 12 Feb 2013
Posts: 17

PostPosted: Fri Apr 11, 2014 5:09 pm    Post subject: What's the table name that holds used space on a volume Reply with quote

Does anybody know what is the table name in RedGate's Monitoring database that holds the space utilization for a particular volume or drive on a SQL server?

So far I found:

[RedGateMonitoring].[data].[Cluster_Machine_LogicalDisk_Keys] holds the name for the drive and its ID.

[RedGateMonitoring].[data].[Cluster_Machine_LogicalDisk_Capacity_StableSamples] holds the max size for a volume.

But I don't know where the information for space utilization is?

Appreciate any response from RedGate support if they read this.

I do have a 2nd database that holds metrics for my system. I do not want to reinvent the wheel and add more stress on my servers and would like to query those tables and extract information of space utilization for my drives, probably one time every day, and export or save that on my 2nd database.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Mon Apr 14, 2014 12:16 pm    Post subject: Reply with quote

I don't think that the space utilization is stored in the data repository as a distinct entry. I believe that it is calculated as needed using the 'current' _FreeBytes and the _TotalBytes values in the tables you have quoted.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
sql-lover



Joined: 12 Feb 2013
Posts: 17

PostPosted: Wed Apr 16, 2014 7:24 pm    Post subject: Re: Reply with quote

chriskelly wrote:
I don't think that the space utilization is stored in the data repository as a distinct entry. I believe that it is calculated as needed using the 'current' _FreeBytes and the _TotalBytes values in the tables you have quoted.


Thanks Chris,

Let me take a look ...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group