BrentOzarULTD/SQL-Server-First-Responder-Kit issues and pull requests

#3581 - sp_Blitz: Error reading sys.traces with specific permissions

Issue - State: open - Opened by Tisit about 1 month ago - 2 comments
Labels: bug, sp_Blitz

#3580 - sp_Blitz: Check 191 avoid false positives in case user doesn't have permissions on sys.master_files

Pull Request - State: closed - Opened by Tisit about 1 month ago

#3579 - sp_Blitz: Fix checks 73 to work with sysadmin permissions

Pull Request - State: closed - Opened by Tisit about 1 month ago

#3578 - sp_Blitz: Check 191 - 'Mismatch between the number of TempDB files in sys.master_files versus tempdb.sys.database_files' falsely reported when run without sysadmin

Issue - State: closed - Opened by Tisit about 1 month ago - 1 comment

#3577 - sp_Blitz: Check 73 - 'No Failsafe Operator Configured' is skipped when run as sysadmin

Issue - State: closed - Opened by Tisit about 1 month ago - 2 comments

#3576 - #3566 sp_BlitzLock better qualify synonym

Pull Request - State: closed - Opened by BrentOzar about 1 month ago
Labels: bug, sp_BlitzLock

#3575 - sp_Blitz: Fix checks 191 and 73

Pull Request - State: closed - Opened by Tisit about 1 month ago - 1 comment

#3574 - #3573 implemented

Pull Request - State: closed - Opened by mikaelljunghorn about 1 month ago - 1 comment

#3573 - sp_BlitzIndex - When no missing index is found in the filtered result, an empty table is displayed instead of "No missing indexes".

Issue - State: closed - Opened by mikaelljunghorn about 1 month ago - 4 comments
Labels: bug, sp_BlitzIndex

#3572 - Enable sp_DatabaseRestore to use Blob Storage

Issue - State: open - Opened by gdoddsy about 2 months ago - 2 comments
Labels: enhancement, sp_DatabaseRestore

#3571 - Question about inclusive language update for sp_BlitzIndex

Issue - State: open - Opened by VladDBA about 2 months ago - 4 comments
Labels: enhancement, sp_BlitzIndex

#3570 - Are there versions of the scripts without creating stored procedures?

Issue - State: closed - Opened by Tony20221 about 2 months ago - 2 comments

#3569 - SqlServerVersions - Added latest CUs and GDRs

Pull Request - State: closed - Opened by VladDBA about 2 months ago - 1 comment

#3568 - Fix for sp_BlitzLock @Debug=1 throwing an error when no plans found in plan cache - #3567

Pull Request - State: closed - Opened by VladDBA 2 months ago

#3567 - sp_BlitzLock throwing an error when ran with @Debug = 1

Issue - State: closed - Opened by VladDBA 2 months ago

#3566 - sp_BlitzLock Throwing an Error when attempting to output to table

Issue - State: closed - Opened by BilliousBT 2 months ago - 5 comments
Labels: bug, sp_BlitzLock

#3565 - sp_BlitzFirst skips plan cache analysis when @ExportMode = 1

Issue - State: closed - Opened by JonasEckerman 2 months ago - 4 comments

#3564 - sp_BlitzLock error - Name cannot begin with the ' ' character, hexadecimal value 0x20.

Issue - State: open - Opened by Sindric1 2 months ago - 1 comment

#3563 - sp_Blitz.sql: Updated #IgnorableWaits to match the 2021 version of Paul Randal's script

Pull Request - State: closed - Opened by ReeceGoding 2 months ago

#3562 - Add the SQL Server 2019+ ignorable waits to sp_Blitz's #IgnorableWaits.

Issue - State: closed - Opened by ReeceGoding 2 months ago - 1 comment

#3561 - sp_BlitzIndex details in separate columns

Issue - State: closed - Opened by Tarjei-stavanger 2 months ago - 1 comment

#3560 - sp_DatabaseRestore: fix backup file selection for @StopAt and non-split full backups

Pull Request - State: closed - Opened by Rob-Hague 3 months ago

#3559 - sp_BlitzLock - empty export to tables

Issue - State: closed - Opened by lduczmal 3 months ago - 3 comments

#3558 - Running sp_blitz with outputtype

Issue - State: closed - Opened by EdwardQuicksall 3 months ago - 1 comment

#3557 - #3556 sp_BlitzIndex missing index processing

Pull Request - State: closed - Opened by BrentOzar 3 months ago
Labels: bug, sp_BlitzIndex

#3556 - sp_BlitzIndex: missing indexes column query processing more data than it should, causing error

Issue - State: closed - Opened by BrentOzar 3 months ago
Labels: bug, sp_BlitzIndex

#3555 - sp_DatabaseRestore: Document the other half of the parameters.

Issue - State: closed - Opened by ReeceGoding 4 months ago - 1 comment

#3554 - sp_Blitz - "Query Store Disabled" false positive on secondary replica

Issue - State: closed - Opened by petervandivier 4 months ago - 1 comment

#3553 - sp_Blitz: Added check for unusual Query Store configuration and Query Store Trace Flags

Pull Request - State: closed - Opened by ReeceGoding 4 months ago

#3552 - Update sp_Blitz.sql validate logins if we are sysadmin

Pull Request - State: closed - Opened by PowerDBAKlaas 4 months ago - 3 comments
Labels: bug, sp_Blitz

#3551 - sp_validatelogins never executed

Issue - State: closed - Opened by PowerDBAKlaas 4 months ago - 4 comments
Labels: bug, sp_Blitz

#3550 - 2024-07-01 Release

Pull Request - State: closed - Opened by BrentOzar 4 months ago

#3549 - 2024-07-01 Release

Pull Request - State: closed - Opened by BrentOzar 4 months ago

#3548 - `sp_BlitzLock` Lock data

Issue - State: closed - Opened by Imran-imtiaz48 5 months ago - 1 comment

#3547 - sp_BlitzLock failed with a data conversion error

Issue - State: closed - Opened by Aussie-Scum 5 months ago - 8 comments
Labels: bug, sp_BlitzLock

#3546 - Closes #3545

Pull Request - State: closed - Opened by erikdarlingdata 5 months ago
Labels: enhancement, sp_BlitzLock

#3545 - sp_BlitzLock - Add max CPU and elapsed times to available plans section

Issue - State: closed - Opened by erikdarlingdata 5 months ago - 2 comments
Labels: enhancement, sp_BlitzLock

#3544 - Add Point In Time restore parameter

Issue - State: closed - Opened by pge92 5 months ago - 1 comment

#3543 - sp_DatabaseRestore: allow enabling service broker on restore

Pull Request - State: closed - Opened by lowlydba 5 months ago - 1 comment

#3542 - sp_DatabaseRestore: add ability to enable service broker

Pull Request - State: closed - Opened by lowlydba 5 months ago

#3541 - sp_Blitz: Added check for unusual Query Store query capture mode

Pull Request - State: closed - Opened by ReeceGoding 5 months ago - 1 comment

#3540 - sp_Blitz: Should we be actively recommending Trace Flag 3226?

Issue - State: closed - Opened by ReeceGoding 5 months ago - 1 comment

#3539 - sp_Blitz: Added checks for disabled but recommended Query Store Trace Flags

Pull Request - State: closed - Opened by ReeceGoding 5 months ago - 1 comment

#3538 - 3537 removing readme references

Pull Request - State: closed - Opened by BrentOzar 5 months ago

#3537 - README.md: sp_BlitzIndex's docs still mention sp_BlitzInMemoryOLTP, even though it's depreicated

Issue - State: closed - Opened by ReeceGoding 5 months ago

#3536 - sp_Blitz: Added check for Query Store not being in READ_WRITE state and check for it not being in desired state.

Pull Request - State: closed - Opened by ReeceGoding 5 months ago - 2 comments

#3535 - sp_Blitz: Add check for Query Store Wait Stats being turned off

Pull Request - State: closed - Opened by ReeceGoding 5 months ago

#3534 - brentozar.com/blitz/query-store-disabled/ Still Recommends sp_BlitzQueryStore

Issue - State: closed - Opened by ReeceGoding 5 months ago - 1 comment

#3533 - sp_Blitz: Add check for very high Query Store memory usage

Pull Request - State: closed - Opened by ReeceGoding 5 months ago - 1 comment

#3532 - sp_DatabaseRestore: Add param to enable service broker on restore

Issue - State: closed - Opened by lowlydba 5 months ago - 2 comments
Labels: enhancement, sp_DatabaseRestore

#3531 - sp_Blitz: Add more detail to Query Store Trace Flag rows

Pull Request - State: closed - Opened by ReeceGoding 5 months ago

#3530 - README.md: Removed sp_AllNightLog from the table of contents

Pull Request - State: closed - Opened by ReeceGoding 5 months ago - 1 comment

#3529 - README.md: sp_AllNightLog is still in the table of contents

Issue - State: closed - Opened by ReeceGoding 5 months ago - 3 comments

#3528 - sp_BlitzIndex has dependency on depricated procedure sp_BlitzInMemoryOLTP

Issue - State: closed - Opened by netsec4u 6 months ago - 1 comment

#3527 - sp_Blitz: Add more Query Store best practice checks.

Issue - State: closed - Opened by ReeceGoding 6 months ago - 3 comments
Labels: enhancement, sp_Blitz

#3526 - Adds DeadlockType parameter for filtering to regular or parallel deadlocks

Pull Request - State: closed - Opened by erikdarlingdata 6 months ago - 1 comment
Labels: enhancement, sp_BlitzLock

#3525 - sp_BlitzLock - Add the ability to filter to a specific type of deadlock

Issue - State: closed - Opened by erikdarlingdata 6 months ago
Labels: enhancement, sp_BlitzLock

#3524 - 2024-05-22 Release

Pull Request - State: closed - Opened by BrentOzar 6 months ago

#3523 - #3522 sp_BlitzIndex permissions

Pull Request - State: closed - Opened by BrentOzar 6 months ago

#3522 - sp_BlitzIndex fails if you don't have permissions to query sys.sql_expression_dependencies

Issue - State: closed - Opened by BrentOzar 6 months ago

#3521 - 2024-05-22 version numbers

Pull Request - State: closed - Opened by BrentOzar 6 months ago