Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    44

    Unanswered: Monitoring the db size

    Hi All,

    I'm wonderring if someone has the script which can run on each server to get all dbs size , free space on this server ? Curently I am using the enterprise manager to check the db space usage manually, but this is very frustrated due to a server has many dbs located on it

    Thanks,

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by rosem
    Hi All,

    I'm wonderring if someone has the script which can run on each server to get all dbs size , free space on this server ? Curently I am using the enterprise manager to check the db space usage manually, but this is very frustrated due to a server has many dbs located on it

    Thanks,
    This might be what you are looking for...

    [Edit: some caveats]
    1. Consider also using DBCC SHOWCONTIG WITH TABLERESULTS. You could embed this in the sp_MSForEachDB.
    2. Note that the data may not match reality; you may need to run dbcc updateusage before you run the sizing extract.
    3. YMMV

    Regards,

    hmscott
    Last edited by hmscott; 11-03-05 at 14:35.
    Have you hugged your backup today?

  3. #3
    Join Date
    May 2004
    Posts
    44
    Thanks a lot hmscott, I'll try it. I found a website which has a few scripts , they are very good, for people referecn if need auto manage db size, drive size and free space. It is:

    http://www.sqlservercentral.com/colu...efreespace.asp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •