I wanted to create my own SQL Server baseline by collecting data with the Performance Monitor.
Among all counters that I have decided to monitor, I also wanted to have a historic trend about data file(s) growth for each database, but, unfortunately, there's no counter for that. I only have a "Data File(s) Size (KB)" counter, but that refers to the space that the database takes in advance, not the one that is actually using.
I know already that i can get the actual used size by doing some queries, in fact my question is not about how to retrieve that information but why can't i get it from the PerfMon.
Is there any official motivation for that? Laziness from Microsoft developers, some technical problem, or maybe something else?
Also note that I can get with no problem the used size for the log(s) file, which is kind of funny in my opinion!