Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

BlitzFirst is missing CHECKDB running #2609

Closed
erikdarlingdata opened this issue Oct 4, 2020 · 2 comments · Fixed by #2610
Closed

BlitzFirst is missing CHECKDB running #2609

erikdarlingdata opened this issue Oct 4, 2020 · 2 comments · Fixed by #2610

Comments

@erikdarlingdata
Copy link
Contributor

Version of the script
SELECT @Version = '7.99', @VersionDate = '20200913';

What is the current behavior?
these cross apply doodads eliminate the row for checkdb. changing them to outer apply fixes it.

    CROSS APPLY sys.dm_exec_query_plan(r.plan_handle) pl
    CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS t

If the current behavior is a bug, please provide the steps to reproduce.
Window one:
DBCC CHECKDB(StackOverflow2013) WITH NO_INFOMSGS, ALL_ERRORMSGS, EXTENDED_LOGICAL_CHECKS, DATA_PURITY, MAXDOP = 8;

Window two:
EXEC sp_BlitzFirst @Seconds = 10, @ExpertMode = 1;

What is the expected behavior?
CheckID 2 should fire for CHECKDB running

Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
Found on 2019 👻

@erikdarlingdata
Copy link
Contributor Author

Will have PR later today!

@BrentOzar
Copy link
Member

Nice catch! Merged into the dev branch, will be in the October release with credit to you in the release notes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants