If you use mount points, then the approach outlined here isn't going to do do much for you.

Also, if you are using clusters, then it's often useful to screen...

Actually, if you just want to see the volumes/mount points that are currently in use by this sql instance, you don't need powershell.

I use this query across all my...

This does the same, but a whole lot quicker

SELECT DB_NAME(database_id) AS [DBName],

COUNT(*) * 8/1024.0 AS [CacheUsed]

FROM sys.dm_os_buffer_descriptors

GROUP BY DB_NAME(database_id)

ORDER BY DB_NAME(database_id) ASC