I just installed
sp_Blitz and it has been running for an hour and still won't complete. I am able to run
sp_BlitzFirst and it takes about 3 minutes to run but does complete.
Any idea why it won't complete?
It finally failed after 1 hour and 11 minutes
There is insufficient system memory in resource pool 'internal' to run this query.
I have one small test database in Recovery Pending state, could that be the issue?
I have Activity Monitor open but don't see any category maxed out, Proc 32%, Waiting Tasks 0, DB I/O .2 MB/Sec, Batch Req. a few hundred.
sp_Blitz; GO and also selected the common settings in the script at the bottom and tried that with the same results.
- sp_Blitz ver 6.4.
- SQL Server Std 64 bit, 2014, SP2 Build 9600
- 128GB of RAM with max set to 116GB
- Single server with about 25 databases, one large Dynamics database, about 300 GB.