February 25, 2015 at 1:27 am
Hi Everyone,
i have set auto shrink option true for one of my database, i want to know after which period the autoshrink event triggers and what is performance implication of using autoshrink=true
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
February 25, 2015 at 2:31 am
AUTO_SHRINK kicks in when 25% of the database space is unused. See https://msdn.microsoft.com/en-us/library/bb522682.aspx
Performance implications? Many and nasty. Fragmentation primarily. See this blog for details: http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx
-- Gianluca Sartori
February 25, 2015 at 2:37 am
Autoshrink is one of the very few settings that should only every have a single value, no matter what the DB or system. False.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply