azureautomation / runbooks

Sample Automation runbooks
MIT License
154 stars 129 forks source link

Update-SQLIndexRunbook.ps1 Addressing table in other schemas #30

Open techpilot007 opened 6 years ago

techpilot007 commented 6 years ago

Updates for Update-SQLIndexRunbook.ps1 -Increased the the timeout for the execution of the average fragmentation query. We've found that having multiple severely fragmented tables leads to the timeout being reached. -Add another Write-Verbose statement to give feed back on where the script is in it's execution. -Concatenate the schema with the table name so that the script can handle tables with the same name in different schemas.