Tag Archives: How to solve External fragmentation

Disk fragmentation – SQL Server Performance

Question : Does Disk Level fragmentation causes performance issues to SQL Server ? SQL Server Performance affected by Disk fragmentation Answer : Yes, SQL Server also suffer from disk fragmentation. Fragmented objects such as tables, indexes, files or databases exert a heavy hit on performance.  There are different kinds of fragmentation. First type of fragmentation [...]