Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DB Free space issue


DB Free space issue

Author
Message
durai nagarajan
durai nagarajan
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1107 Visits: 2771
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
HanShi
HanShi
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3048 Visits: 3625
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’! **
durai nagarajan
durai nagarajan
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1107 Visits: 2771
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
Sean Pearce
Sean Pearce
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1170 Visits: 3432
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

@SeanPearceSQL

About Me
Database admin(DBA)
Database admin(DBA)
SSC Veteran
SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)SSC Veteran (216 reputation)

Group: General Forum Members
Points: 216 Visits: 1309
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
durai nagarajan
durai nagarajan
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1107 Visits: 2771
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
Sean Pearce
Sean Pearce
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1170 Visits: 3432
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

@SeanPearceSQL

About Me
durai nagarajan
durai nagarajan
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1107 Visits: 2771
Thanks all and may i know how application has related to huge free space, any link or suggestions will be helpful.

Regards
Durai Nagarajan
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search