PSBlitz
PSBlitz copied to clipboard
VladDBA
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.
Add a sheet that contains aggregate sp_BlitzWho data to make things easier for very active instances.
Avoid issues caused by having a workbook with the same name opened in Excel during PSBlitz execution
There are cases when a user might want to run PSBlitz at the same while their looking at a previously generated output for the same instance. Due to the Excel...
specifically the query that returns the database-scoped configuration
Hi, with v4.0.0 and v3.6.1 i'm getting these errors: ``` Running sp_Blitz... x (Failed) MSg 207, Level 16, State 1, Line 3436 Invalid column name 'deadlock_type'. Running sp_BlitzLock for all...
Purpose: - Get a quick snapshot of what's happening now, without having to wait for index and cache related info to be returned. Usage: - Usable only from the command...
Remove variables containing lots of data when they're no longer needed
Hi @VladDBA, this project sounds promising...I will give it a shot. You write that export to Excel is possible only when Excel is installed on the system. Have you considered...
I've just seen a PSBlitz output for an instance with 28 tempdb data files, all with different sizes and autogrow increments This is the type of information I'd want details...