August 28, 2008 at 1:37 pm
Hello all
Is there a way to find out how much space is used on a server. I was going to used sp_spaceused but that is for databases on that server and I am trying avoid having to go through each db and run that sp then having to add all of them up. I am sure there is an easier way to do this???
Any suggestions will be greatly appreciated. Thanks
August 28, 2008 at 1:47 pm
if you want to find disk space used on a server you could try a WMI query to get the info required.
Alternatively try BGInfo utility from sysinternals
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 2:10 pm
There's a view called sys.master_files that has the size of each file in 8k pages, this has all system and user databases in it.
August 10, 2013 at 11:38 am
Hello,
try bginfo4x from bginfo4x.sourceforge.net
it is very easy to get what you want.
check this :
http://4x4w.blogspot.com/2013/06/monitoring-your-mssql-status-with.html
August 10, 2013 at 6:38 pm
This thread is 5yrs old! 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2013 at 9:58 am
Perry Whittle (8/10/2013)
This thread is 5yrs old! 😉
I know right...I looked in my email and saw where somebody posted a new comment...Then I clicked on the link and realized this was a thread I started 5 years ago!!!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply