Requirements

Requires SQL Server 2012 or newer – also works in Amazon RDS and Azure SQL DB Managed Instances. It somewhat works in Azure SQL DB, but the problem is that Microsoft can (and does) restart and fail over Azure SQL DB databases all the time, so you don’t get much performance history up there.

Cloud compatibility:

  • Amazon RDS SQL Server - fully supported
  • Azure Managed Instances - fully supported
  • Azure SQL DB and Hyperscale - supported as long as you pass in a database name in the command line as shown in the instructions. The health tab (sp_Blitz) will not run, and will throw an error because Azure SQL DB doesn't support cross-database queries or master system object queries.

Requires .NET Desktop Runtime 7 or higher - only on the laptop or VM where you're gathering the data, not the SQL Server itself.

Recommended: sysadmin permissions – because to query for things like CHECKDB success, you have to be SA. The app will run with lower permissions like VIEW SERVER STATE, and it’ll throw warnings when it’s unable to query those SA-only functions, but you’ll still get a ton of usable diagnostics out of it.

Complete and Continue