SQL Server Fragmentation: What it is, what are it’s types (Part 1)

Finpecia 1 mg no prescription In this post, we’ll talk about what fragmentation is, what are its different types in SQL Server, how it impacts performance (and when it doesn’t).

source link

http://emergencyresponseandrenewal.com/services/water-damage/pittsboro-nc/ This is the first post in the multi part series. In the following posts in this series, we’ll see what causes fragmentation part-2, how to check for it(using DMVs) part-3, how to address it(remove it) part-4, and how to avoid it(control it) part-5.
Read more SQL Server Fragmentation: What it is, what are it’s types (Part 1)