November 2, 2016 at 7:39 am
Can any one help in getting script to get all in one output , we need to collect every week disk total size, free space , used space , datafiles total size , used space, free space , database growth .
Thanks
November 2, 2016 at 8:11 am
For all the DB info
http://www.sqlservercentral.com/Forums/Topic670489-146-1.aspx
For the disk info
SELECT distinct volume_mount_point,total_bytes/1024/1024 total_bytesInMB ,available_bytes/1024/1024 available_bytesInMB
FROM sys.master_files AS f CROSS APPLY
sys.dm_os_volume_stats(f.database_id, f.file_id)
November 3, 2016 at 6:10 am
Here's an article about monitoring drive space. http://www.sqlservercentral.com/articles/Drive+space/134523/
November 3, 2016 at 7:35 am
Please don't cross post. It just confuses things.
the original question is here. http://www.sqlservercentral.com/Forums/Topic1831422-3739-1.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 3, 2016 at 7:39 am
Sean Lange (11/3/2016)
Please don't cross post. It just confuses things.the original question is here. http://www.sqlservercentral.com/Forums/Topic1831422-3739-1.aspx
Doh! And I fell for it. I saw this one and not the other. :crazy:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply