The newly released SQL Server Diagnostics (Preview) can be found here.
Below are the install screenshots
Once installed it is accessible via SSMS
Dumps are usually located in your …MSSQLSERVER\MSSQL\Log folder.
Here I also selected to send an email just to see what it’ll look like.
The email received was
The other Diagnostics options were
Looks a bit of a cover all at the moment
Takes you to the below site (which no longer exists)
It’ll be sad to see the default trace go. It’s help me out numerous times during onsite consults when monitoring has not been in place. It really is one of the good features introduced in SQL Server 2005.
The deprecated features list is a bit of an unknown as there is no fixed version/date set by Microsoft, so when it’ll finally goes is anyone’s guess. Hopefully by that stage extended events will be more palatable.
Troubleshooting performance issues can be challenging and more so when 1 user has issues and another doesn’t for the same application and they both sit in the same room.
This is where SSMS Include Client Statistics may come in handy.
Enable the option and run the query causing issues on both users machines.
Possibly you the results will help point you in the correct direction i.e. network path issues etc..
Remember to unselect the option when finished as it adds extra overhead when used.
“There will be two primary release channels available to Windows Server customers, the Long-term Servicing Channel, and the new Semi-annual Channel.”
When installing SQL Server the key thing to remember is:
“Windows Server products in the Semi-annual Channel will have new releases available twice a year, in spring and fall. Each release in this channel will be supported for 18 months from the initial release.”
18 months = 1.5 years so not very long and given that SQL Server releases are typically every 2 years, I’m not sure how viable this the new Semi-annual Channel will be for hosting SQL Server. Time will tell.
What is really interesting is that, to me, it appears that Microsoft may have gone from a market leader to a follower, I could be wrong:
By default, SSMS saves your queries every 5 minutes and keeps the info for 7 days.
I suspect this has saved many a DBA when unforeseen outages occur.
One quick way to get to this recovery location is shown below and is by right clicking on a Query tab:
As you may have noticed, this provides a quick access method to your hidden AppData folder.