September 11, 2009 at 10:49 am
I want to know if there is way to determine the fragmentation of data files on sql server? If there is a way , then how do we defragment them is they are above certain threshold. I know about index fragmentation and all, we have processes to rebuild indexes.
September 11, 2009 at 11:28 am
If you are referring to physical file fragmentation of the mdf and ldf files, then I use the contig utility to check and correct this. See http://technet.microsoft.com/en-us/sysinternals/bb897428.aspx
This should not have to be done often. And even less often if the database is sized properly to begin with so that it seldom needs to physically grow and typically only grows under controlled circumstances.
Francis
September 12, 2009 at 7:03 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply