{"repo":"VladDBA/PSBlitz","free":true,"listed":false,"github":"https://github.com/VladDBA/PSBlitz","clone":"git clone https://github.com/VladDBA/PSBlitz.git","description":"a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files.","language":"TSQL","stars":158,"topics":["sql-server","sql-server-performance-scripts","execution-plan","wait-stats","deadlock","sp-blitz","sp-blitzcache","sp-blitzfirst","sp-blitzindex","deadlock-graph"],"license":null,"category":"databases-storage","readme_excerpt":"PSBlitz A PowerShell-based SQL Server performance diagnostics and health check tool. Navigation - Intro - Notable Changes - Features overview - Compatibility - Prerequisites - Installation - What it does - Default check VS in-depth check - Output files - Usage examples - Acknowledgments - Contributing - Support - Screenshots - License Intro Since I'm a big fan of Brent Ozar's SQL Server First Responder Kit and I've found myself in many situations where I would have liked a quick way to easily export the output of sp Blitz, sp BlitzCache, sp BlitzFirst, sp BlitzIndex, sp BlitzLock, and sp BlitzWho to Excel, as well as saving to disk the execution plans identified by sp BlitzCache and deadlock graphs from sp BlitzLock, I've decided to put together a PowerShell script that does just that.\\ Notable changes As of version 3.0.0 , PSBlitz is also capable of exporting the report to HTML making Excel/Office no longer a hard requirement for running PSBlitz.\\ As of version 4.0.1 , PSBlitz is also compatible with Azure SQL DB and Azure SQL Managed Instance. \\ As of version 4.3.4 , PSBlitz can be executed using PowerShell on Linux, the output will default to HTML regardless of the option used.\\ As of version 5.3.0 , PSBlitz replaces the non-stred-procedure version of sp BlitzQuery store with a modified, non-stored-procedure, version of sp QuickieStore Features overview - SQL Server health checks - Performance diagnostics - Query analysis - Deadlock investigation - Azure SQL DB support - C","default_branch":null,"files":null,"tree":[],"storefront":"/r/VladDBA","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/VladDBA/PSBlitz/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}