November 24, 2008 at 4:34 pm
Hi,
We are recently started using Redgate Sql response to monitor our production servers.We are getting a recommandation about Free space in data files as below.
SQL Response raises the Data file has excessive free space recommendation when the percentage of free space in any of the database’s data files exceeds a specified value. SQL Response determines this percentage by running the DBCC showfilestats command, to determine the space available in each data file.
A data file may be left with an excessive amount of free space after a large amount of data has been deleted. Removing data does not reduce the size of the data file, and leaves the file with a lot of pages that are no longer utilized. To reclaim this space on disk, you can shrink the data file
Filename filesize freespace percentagefree path
ABC_DAT 2.4 GB2.3 GB 95.39 % D:\SQLDATA1\ABC_DAT\ABC.mdf
But I read in Sqlservercentral forums,that many experienced DBA's suggesting that DO NOT Shrink Datafiles and Log files unless if it is an emergency case.could you plz explain me this tradeoff
So plz advice me
November 24, 2008 at 5:28 pm
The recommendation should be to NOT shrink your data or log files on a regular basis as normal daily/weekly/monthly operations.
If you have an unusual event where either the data or the log file has grown, and you know that you will not be filling that data file to that size ever again - then shrink the file down to a more reasonable size as a one-time operation.
Remember that you still want to keep extra space in the data file to manage index rebuilds and normal growth.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply