SQL Server Performance Forum – Threads Archive

Space used

Hi all, Just need to find out total space uesed in database server. in SQL 2000 and 2005!! how can i get that please. thanks Thanks!!

---

SP_SPACEUSED @UPDATEUSAGE=’TRUE’ Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Also check out xp_fixeddrives and dbcc sqlperf(logspace) for drive space usage and log space usage respectively.

---

Also refer
http://sqlteam.com/forums/topic.asp?TOPIC_ID=61762 Madhivanan Failing to plan is Planning to fail

---

]]>