3
It is not compatible. Azure doesn't expose all the dynamic management views that we get in the boxed product.
take a look here:
https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/1970
2
You have two physical NUMA nodes (Memory Nodes), with Automatic Soft-Numa dividing each one into two NUMA nodes in SQL Server.
I'd like to understand the meaning/importance of VAS Reserved
Virtual Address Space (VAS) is reserved as a first step to allocating memory, see: Reserving and Committing Memory. For 64bit processes the VAS is immense, and so it's ...
answered Jan 25 at 22:55
David Browne - Microsoft
30.2k22 gold badges3232 silver badges6767 bronze badges
2
No, sp_Blitz doesn't track that kind of thing. A better approach would be querying LOG_REUSE_WAIT_DESC.
answered Nov 4 '20 at 19:16
Brent Ozar
40.1k2929 gold badges157157 silver badges302302 bronze badges
1
Sure, it's in Markdown here: https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/blob/master/Documentation/sp_Blitz_Checks_by_Priority.md
If you find any inconsistencies with it, check out the Contributor Guide for how to open issues in the GitHub repo, discuss the changes you want to make, and check in changes.
answered Mar 4 '20 at 17:35
Brent Ozar
40.1k2929 gold badges157157 silver badges302302 bronze badges
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
sp-blitz × 61sql-server × 44
sp-blitzfirst × 9
sql-server-2014 × 6
memory × 5
performance × 4
sql-server-2012 × 4
sql-server-2016 × 4
azure-sql-database × 4
sql-server-2008 × 3
sql-server-2008-r2 × 2
t-sql × 2
sql-server-2017 × 2
transaction-log × 2
plan-cache × 2
sp-blitzcache × 2
query-performance × 1
backup × 1
permissions × 1
sql-server-2005 × 1
security × 1
linux × 1
amazon-rds × 1
configuration × 1
performance-tuning × 1