a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files.
Other
69
stars
17
forks
source link
Index Info - Usage and Diagnostics - warning for instance-wide check on instances with 50+ databases #253
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 info and (extended) index diagnostics for $dbcount databases may cause temporary issues for the instance and/or user.
Are you sure you want to continue? (defaults to N) [Y/N]:
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 info and (extended) index diagnostics for
$dbcountdatabases may cause temporary issues for the instance and/or user. Are you sure you want to continue? (defaults to N) [Y/N]: