Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Spotlight Alarm Action Script to run index defragmentation
설명
How to run alarm action script to rebuild fragmented indexes triggered by the Index defragmentation alarm.
해결 방안
Index defragmentation is one of longest lasting collections. That is why it runs by default only once a time. A better solution is to implement the index maintenance independently and use Spotlight on SQL Server Enterprise only as a monitor.
추가 정보
Use for example maintenance script from Ola Hallengren.
https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
