Internal vs. external fragmentation
It's a snappy instructional exercise in transit SQL Server stores information in 8 KB "pages." In another or remade record, the pages are for the most part full and put away all together. Be that as it may, as more information gets included, pages become part: not all pages are full and they happen faulty. This is the imperative contrast among inward and outside discontinuity:
External fragmentation – refers to pages being out of order
Internal fragmentation – refers to the empty space on a page
Focusing less on page splits
Numerous database experts centre on page parts as a proportion of database fracture, be that as it may, clarified that this number is good for nothing since page parts happen both while adding another column to an unfilled table and while including another page. In this way, it's not useful all things considered.
How external fragmentation can make things worse
Outer discontinuity is certainly not a helpful proportion of database execution since page request doesn't have a lot of an effect on the speed of upkeep errands, running inquiries in RAM or perusing information from plate. Along these lines, database experts who attempt to fix outside discontinuity by redesigning and revamping files are really aggravating execution by swelling reinforcements and spending more support window time.
Database experts who attempt to decrease outer fracture by leaving room on pages through setting a fill factor are additionally causing an issue more awful than the one they're attempting to fix. This is to a great extent since you never need to embed information at a point mid-path in the list. In this way, attempting to maintain pages in control by putting less information on every individual page is really causing interior fracture.
Monitoring wait time
What would it be a good idea for you to do? Setting the fill factor to the default of 100% (or if nothing else 80% or higher) and afterward remaking the records to pack them once more. Next, centre on observing the correct presentation tuning number – hold up time. Probably the most ideal approaches to see different parts of hold up time over your database occasions is by utilizing an exhibition checking instrument to pinpoint precisely where procedures are impeding