Post reply

DB Free space issue

  • July 17, 2013 at 12:48 am

    #275420

    Hello,

    we have a vendor DB which always keeps around 3GB of free space.

    It is sql 2005 SP3 and DB Data size is 6.5 GB.

    I took used space from

    select fileproperty(Name,'SpaceUsed')/128 from sysfiles

    I took size from

    Select size from SYS.MASTER_FILES where name = 'DBName'

    then calculating free space for each DB

    i tried shrinking the file/DB once but it increased again, i know it is not recommended.

    as if now it is not space crunch but i want to know why a DB keeps huge free space compared to it's data size.

    Regards
    Durai Nagarajan

  • July 17, 2013 at 1:05 am

    #1633095

    I think you should discuss this with the vendor. It could be that the application is keeping its own monitoring of the size and demands such free space. It could also be that there are periodically large imports or large temporarily objects within the database. Heck, the application could even copy all the contents of the data to other objects within the database for some obscure reason.

    The vendor should know what the application is doing and could tell you the specs of the database.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • July 17, 2013 at 1:08 am

    #1633096

    There is no large imports and the data from this we are taking it to a tempory table and then we are processing it for our use.

    any other guess before i take it to the vendor.

    Regards
    Durai Nagarajan

  • July 18, 2013 at 2:06 am

    #1633553

    durai nagarajan (7/17/2013)

    any other guess before i take it to the vendor.

    Select growth from SYS.MASTER_FILES where name = 'DBName'

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • July 18, 2013 at 2:42 am

    #1633562

    Hi,

    better you can talk with Your Vendor because of 1.Its depends on application and Database Configuration and 2.May be Its directly encrypted data from the application ....please find the below link..it will help you

    .....

    https://www.simple-talk.com/sql/database-administration/managing-data-growth-in-sql-server/

    Thanks&Regards,

    DBA

    SQL server DBA

  • July 19, 2013 at 12:02 am

    #1633848

    Sean Pearce (7/18/2013)

    durai nagarajan (7/17/2013)

    any other guess before i take it to the vendor.

    Select growth from SYS.MASTER_FILES where name = 'DBName'

    32000

    Regards
    Durai Nagarajan

  • July 22, 2013 at 4:46 am

    #1634395

    durai nagarajan (7/19/2013)

    Sean Pearce (7/18/2013)

    durai nagarajan (7/17/2013)

    any other guess before i take it to the vendor.

    Select growth from SYS.MASTER_FILES where name = 'DBName'

    32000

    I would agree on contacting the vendor for this one.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • July 22, 2013 at 5:20 am

    #1634408

    Thanks all and may i know how application has related to huge free space, any link or suggestions will be helpful.

    Regards
    Durai Nagarajan

Viewing 8 posts - 1 through 7 (of 7 total)

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