Pages

Get-DbaSuspectPage

Garry Bargsley (@gbargsley), blog.garrybargsley.com

Get-DbaSuspectPage View Source Garry Bargsley (@gbargsley), blog.garrybargsley.com Windows, Linux, macOS Synopsis Retrieves suspect page records from msdb database for corruption detection and analysis Description Queries the msdb.dbo.suspect_pages table to identify database pages that have experienced corruption events such as checksum failures, torn pages, or I/O errors. SQL Server automatically logs corrupt pages to this system table when encountered during read operations, making this function essential for proactive corruption monitoring and troubleshooting.

Get-DbaWaitResource

Stuart Moore (@napalmgram), stuart-moore.com

Get-DbaWaitResource View Source Stuart Moore (@napalmgram), stuart-moore.com Windows, Linux, macOS Synopsis Translates wait resource strings into human-readable database object information for troubleshooting blocking and deadlocks Description Converts cryptic wait resource identifiers from sys.dm_exec_requests into readable database object details that DBAs can actually use for troubleshooting. When you’re investigating blocking chains or deadlocks, you see wait_resource values like ‘PAGE: 10:1:9180084’ or ‘KEY: 7:35457594073541168 (de21f92a1572)’ in DMVs, but these don’t tell you which actual table or index is involved.