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 156: Social Intelligence
Episode 155: Data Science
Episode 154: Test Driven Development
Episode 153: SQL Trail 2018 Retrospective
Episode 152: Do you use Analysis Services?
Episode 151: Azure SQL Database Managed Instance
Episode 150: The SQL Data Partners Team
Episode 149: Managing lots of databases
Episode 148: High Performance SSRS
Episode 147: Always Encrypted
Episode 146: SQL Trail Speakers
Episode 145: Is SSIS still relevant? Part 2
Episode 144: Is SSIS still relevant? Part 1
Episode 143: Transitioning from DBA to Data Warehouse Architect
Episode 142: Do You Have a HEAP of Hurting?
Episode 141: Wait, Wait, What?
Episode 140: Why data types matter
Episode 139: Getting Started with SQL Server in Azure
Episode 138: Meeting of the Minds
Episode 137: You want to work with Analytics?
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