Hannah Vernon HannahVernon
EitanBlumin
/ Check_Index_Fragmentation_Based_on_Page_Fullness_and_Fill_Factor.sql
Last active
July 13, 2023 15:14
Check Index Fragmentation Based on Page Fullness and Fill Factor. Inspired by: https://www.erikdarlingdata.com/2019/10/because-your-index-maintenance-script-is-measuring-the-wrong-thing/
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /************************************************************************** | |
| Check Index Fragmentation based on Page Fullness and Fill Factor | |
| *************************************************************************** | |
| Author: Eitan Blumin | https://www.eitanblumin.com | |
| Version History: | |
| 2020-10-20 Added @MaxDOP parameter, and better comments & indentation | |
| 2020-01-07 First version | |
| Description: | |
| This script was inspired by Erik Darling's blog post here: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # ####################################################################### | |
| # ### Test SQL Server Browser connection and display datagram results ### | |
| # ### to help troubleshoot named instance connectivity problems. ### | |
| # ####################################################################### | |
| # verify UDP port 1433 connectivity and query SQL Server Browser for all instances | |
| Function Get-SqlServerBrowerDatagramForAllInstances($hostNameOrIpAddress) | |
| { | |
| Write-Host "Querying SQL Browser for all instances on host $hostNameOrIpAddress ..." |