Friday 29 May 2015

Is it best practice to have auto shrink enable on database?

You can say straight forward NO

Why?

If you have auto shrink enabled in your environment then it increases the fragmentation level of indexes so performance will go down

Even you save some space after auto shrink but it’s not recommendable.

A DBA should have control on shrink, but with auto shrink you won’t be having control on database.


If you have a table with 50 gig and it’s got historical data and you don’t need any more in that database then you got go for truncate whole data in a table then it would be a good practice to shrink data file on that database, if log became huge and you don’t have any other option then you can shrink log but it is preferable to shrink manually 

No comments:

Post a Comment

How to find table row count?

--Use below query to find table row count select so.name,sp.rows from sys.objects so inner join sys.partitions sp on so.object_id = sp.obj...