Vlad Drumea
Vlad Drumea
Index Info - Usage and Diagnostics - warning for instance-wide check on instances with 50+ databases
In case of an instance-wide check, get the count of user databases on the instance and, if `$dbcount` >= 50, ask for confirmation before proceeding. Warning message: Getting index usage...
Hello Matteo, Details about the `-As` parameter are missing from the [Invoke-Sqlcmd](https://learn.microsoft.com/en-us/powershell/module/sqlserver/invoke-sqlcmd?view=sqlserver-ps) documentation page. #### -As Specifies the output type. | Type: | String | |:---|:---| |Accepted values:| DataSet, DataTables,...
Change behavior of -CheckDB to accept multiple comma separated databases for situations where the database-specific check should target more than one database. Affected checks: - plan cache - query store...
Useful to know, especially if the stored procedures may be executed through clients that don't set those options to ON by default. - For instance wide check it will piggy...
Equivalents for: - `-CacheTop` - `-CacheMinutesBack` - `-OutputDir`
Filtering sessions activity by the database name specified in a database-specific check can lead to missing relevant data points in situations where other databases are hogging resources (noisy neighbors).
Filtering open transactions info by the database name specified in a database-specific check can lead to missing relevant data points in situations where other databases are hogging resources (noisy neighbors).