If you have ever worked with Microsoft support, you probably came across the PssDiag tool they use to collect information about your environment. My experience with the tool is it always seemed, well--a bit clunky. Now, it does collect lots of information and seemed to be a bit overwhelming when I was first a DBA. Fast forward a few years and PssDiag was not a tool I use anymore and was not sure if anyone outside of Microsoft was using it. I run into Jared Poche in Raleigh and he mentions he really likes the tool and mentions some of the improvements they have made over the years. Well, you can guess where this is heading.
We talk with Jared about his experience with the tool and cover some of the basics about how you might go about using this tool in your environment. There are two pieces to this tool, the first is the utility that collects the data and the second is the reporting piece SQL Nexus.
Are you using PssDiag? Let us know if the comments below.
The show notes for today's episode can be found at http://sqldatapartners.com/2017/11/07/episode-116-are-people-still-using-pssdiag. Have fun on the SQL trail!
Episode 256: The Community Episode
Episode 255: Automate Complex CRUD with sp_CRUDGen
Episode 254: Code Smell Checks with sp_Develop
Episode 253: Go Mobile with Power Apps
Episode 252: The Cumulative Update Dilemma
Episode 251: Azure Cognitive Services
Episode 250: What happens before... “COMPANEROS!”
Episode 249: Data Marts in Power BI
Episode 248: Inventory Documentation
Episode 247: Pushing the Boundaries or Pushing Your Luck
Episode 246: Microsoft Build 2022 Announcements
Episode 245: Tooling Updates
Episode 244: Extended Events vs SQL Server Audit
Episode 243: Choosing What Content To Focus On
Episode 242: Upgrading Your SQL Server
Episode 241: Replicating Data with Azure SQL Data Sync
Episode 240: Azure Synapse Link
Episode 239: Bi-directional HA/DR to Azure SQL
Episode 238: Getting Started with Power BI - Part 2
Episode 237: Getting Started with Power BI - Part 1
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast