SQL Server Performance

Space used

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by PatDeV, Jun 12, 2007.

  1. PatDeV New Member

    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!!
  2. satya Moderator

    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.
  3. thomas New Member

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

Share This Page