Jonas Olsson JonasNjopOlsson
🏠
JonasNjopOlsson
/ Hallengren - Report on time taken to run commands.sql
Last active
June 1, 2025 06:52
Hallengren SQL Server Maintenance Solution - Report on time taken to run and prepare for running commands
This file contains hidden or 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
| /* | |
| ============================================================================= | |
| Report on time taken to run and prepare for running Hallengren commands | |
| NOTE: Specifically UPDATE_STATISTICS can take a long time on databases with many partitions. | |
| Finding command types get statistics for: | |
| SELECT DISTINCT CommandType FROM dbo.CommandLog ORDER BY CommandType; | |
| ============================================================================= | |
| */ |