Post reply

Database Size

  • June 22, 2009 at 8:41 am

    #132030

    Hi,

    I have a database that our developers use only for Views and Stored Procedures for Reporting Services. It is 14 GB which seems entirely to large.

    I looked at the properties of each table in the DB and the total size of all tables adds up to about 4 GB. How can I find out where the space is being used?

    Regards,

    Terry

    A great day starts with a great attitude

  • June 22, 2009 at 8:54 am

    #1013356

    Terry B (6/22/2009)

    I looked at the properties of each table in the DB and the total size of all tables adds up to about 4 GB. How can I find out where the space is being used?

    Regards,

    Terry

    http://www.sqlservercentral.com/scripts/Miscellaneous/30110/

    You can run this query to find spaces used by all tables.

    If this is dev db, you might want to shrink the database/or individual files to reclaim unused space.


    Pradeep Singh

  • June 22, 2009 at 9:31 am

    #1013394

    First, be aware that you want to have free space in your database files. These are not Excel or Word files. Free space is needed for data growth.

    Second, is this all the data file, or are you including the log file in there?

  • June 22, 2009 at 10:17 am

    #1013431

    Only the data file. I understand needing some free space in the DB but 14 GB seems like a lot when it is supposed to be Views and Stored Procedures only. And we do not have thousands of them either ... 246 Views and 23 SP's.

    Thanks,

    Terry

    A great day starts with a great attitude

  • June 22, 2009 at 10:19 am

    #1013435

    There aren't any tables? What are the views of?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply