My database is growing bigger and bigger, and I am afraid it will run out of
disk space later on. I would like to shrink it, but I read somewhere that
shrinking is not a good idea if the database is still growing, because it
will slow down adding new records to the database. Would you please confirm
regarding the disadvantages of shrinking the database ? Thank you.you just nailed it on the head.
If you shrink it, the db will have to "AutoGrow" (Or manually grow) at
somepoint,.
this is an expensive operation.
Furthermore, shrinking and growing a db causes fragmentation which can
dramatically effect system performance.
You are far better off planning for more disk capacity asap.
Greg Jackson
PDX, Oregon|||http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"fniles" <fniles@.pfmail.com> wrote in message news:%23EcwFBAfFHA.2700@.tk2msftngp13.phx.gbl..
.
> My database is growing bigger and bigger, and I am afraid it will run out
of
> disk space later on. I would like to shrink it, but I read somewhere that
> shrinking is not a good idea if the database is still growing, because it
> will slow down adding new records to the database. Would you please confir
m
> regarding the disadvantages of shrinking the database ? Thank you.
>|||Thank you all for your replies.
If I delete a lot of data from the database, the next time new data need to
be added to the database, will it reuse the space from the old data or will
it keep growing the database ?
Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OiKbtLAfFHA.1404@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "fniles" <fniles@.pfmail.com> wrote in message
> news:%23EcwFBAfFHA.2700@.tk2msftngp13.phx.gbl...|||It depends on how the layout of the data is indexes you have, what you clus
ter on, what data you
have deleted). In general, the space will be re-used, how long it will take
(how much you have to
delete) depends on the details.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"fniles" <fniles@.pfmail.com> wrote in message news:uZzEcTAfFHA.1680@.TK2MSFTNGP09.phx.gbl...[
vbcol=seagreen]
> Thank you all for your replies.
> If I delete a lot of data from the database, the next time new data need t
o be added to the
> database, will it reuse the space from the old data or will it keep growin
g the database ?
> Thanks.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:OiKbtLAfFHA.1404@.TK2MSFTNGP09.phx.gbl...
>[/vbcol]
没有评论:
发表评论