Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hks
Starting Member
3 Posts |
 Posted - 2006-07-11 : 03:33:01
|
| Hello,I have problem in data files (*.mdf) very big (at 250 GB) and It make very slow the process when I query the database. Every I shrink database needs 2 days. What I can do to make faster the shrink files ? and why data files very big ? thx |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-11 : 03:39:25
|
| do you need to do some archiving perhaps?--------------------keeping it simple... |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-11 : 03:41:12
|
| Check what your growth factor is.The size of the file shouldn't make much difference to the speed of the queries.Sounds like the file needs to be that size so when you shrink it it just has to grow again which will slow everything down.Look at your processing to see what is causing the file to grow - presumably you are adding and deleting data.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
|
|
hks
Starting Member
3 Posts |
Posted - 2006-07-17 : 00:09:53
|
quote:
Originally posted by jen
do you need to do some archiving perhaps?--------------------keeping it simple...
It's not a simple thing...I Have 2 servers which like that...Data servers :Memory 4 GBDual Xeon 3 Ghz (hyper)Hardisk 4x 250 GB SATA ==> full with data baseIf I can smooth the shrink proces ... I can spend my free hardisk...Thx |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-17 : 02:02:55
|
imhe, i am able to shrink a database of 150-200 GB in less than 20 minutes (but we only shrink if this is still in dev environ where we do a lot of testing, if it's production, we assume the growth is due to insertion of data)data files do grow but you can be guided by the Kristen and Nigel's questions, is it worth shrinking everytime? what's contributing to it's growth and 'shrinkage'? what's the growth rate?the archiving will provide you with free spaces within the actual size of the data file, which means you are actually 'maintaining' the db size instead of 'fire fighting' if the data file grows or probably you are more likely to explore disk size expansion?hope this helps  --------------------keeping it simple... |
|
|
|
|
|
|
Shrink Database very low