Happy Independence Day from all of us at the Connect IT Community! Our US offices will be closed on Monday, July 4th, 2022 in recognition of the holiday. Limited Support staff in the US will be on-call and available for critical Service(s) Down issues only. Normal Support operations in the US will resume on Tuesday, July 5th, 2022.

Check MS SQL Index Fragmentation

Kaseya Automation Team
Kaseya Automation Team USMember, Kaseya Certified CHOCOLATE MILK
edited January 24 in Solutions

Product Name: Check MS SQL Index Fragmentation

Description : The following Agent Procedure is intended to gather MS SQL DB Index Fragmentation information on the host and save it as a CSV-file on the VSA server.

Using PowerShell, this procedure prompts for the SQL Server IP address, instance name, and username/password to connect and check for index fragmentation.

This procedure checks any databases that the user has access to that has fragmentation.

Instructions :

Please see attached pdf for installation instructions.

Weekly Leaderboard