Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DB Free space issue Expand / Collapse
Author
Message
Posted Wednesday, July 17, 2013 12:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1474391
Posted Wednesday, July 17, 2013 1:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:44 AM
Points: 2,397, Visits: 2,935
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’! **
Post #1474399
Posted Wednesday, July 17, 2013 1:08 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1474400
Posted Thursday, July 18, 2013 2:06 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:05 AM
Points: 943, Visits: 2,951
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
Post #1474928
Posted Thursday, July 18, 2013 2:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 1:32 AM
Points: 170, Visits: 740
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
Post #1474938
Posted Friday, July 19, 2013 12:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1475277
Posted Monday, July 22, 2013 4:46 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:05 AM
Points: 943, Visits: 2,951
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
Post #1475932
Posted Monday, July 22, 2013 5:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Thanks all and may i know how application has related to huge free space, any link or suggestions will be helpful.

Regards
Durai Nagarajan
Post #1475947
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse