Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Space on Server Expand / Collapse
Author
Message
Posted Thursday, August 28, 2008 1:37 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 26, 2014 11:03 AM
Points: 187, Visits: 422
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
Post #560781
Posted Thursday, August 28, 2008 1:47 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 6,466, Visits: 13,921
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"
Post #560789
Posted Thursday, August 28, 2008 2:10 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:38 AM
Points: 1,907, Visits: 2,056
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.
Post #560803
Posted Saturday, August 10, 2013 11:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 4:07 AM
Points: 2, Visits: 13
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

Post #1483038
Posted Saturday, August 10, 2013 6:38 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 6,466, Visits: 13,921
This thread is 5yrs old!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1483065
Posted Monday, August 12, 2013 9:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 26, 2014 11:03 AM
Points: 187, Visits: 422
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!!!
Post #1483379
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse