[dba-SQLServer] log file size

JC says he is using 900GB o\f SSD

In which case, the whole concept of fragmentation is immaterail.

He shouldn't even think doing an OS defrag.


-- 
Stuart

On 5 Oct 2012 at 11:51, Francisco Tapia wrote:

> John,
>   While performing a shrinkfile can cause OS file level fragmentation,
> unless you are pre-growing your database files, you've already causing file
> fragmentation, everytime Windows creates a new file, it's NTFS system will
> be super efficient and begin writing to all available blocks, even when
> they are not contiguous... it's the inherent nature of the filesystem...in
> order to avoid fragmentation at all cost, you will want to perform an OS
> level defragmentation prior to creating any new large file on the OS in
> windows.