On Saturday May 4th I’ll be speaking at SQL Saturday Phoenix. I am excited to be presenting a lively and practical session about Environmental SQL Server Troubleshooting.
When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment.
Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.
In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
If you want a preview of the talk and some supplemental info please look at these:
- Environmental Checks – Overview
- SQL Server Environmental Diagnostics Guide
- Windows Server Environmental Diagnostics Guide
- VMware Environmental Diagnostics Guide
These are all available under the Resources menu at the top of the page.
SQL Saturday Elevator Pitch
SQL Saturday is a free training event for learning about SQL Server. This includes a wide array of topics:
- Enterprise DBA
- Application & Database Development
- Analytics
- BI
- Azure
- Professional Development
- …and many more!
If you’ve never been they are totally worth a few hours on a Saturday afternoon. Make it a point to attend one in your city. If you work with SQL Server this is good quality training for free in a low pressure setting. Yes, even the most introverted will feel at home.
If you like free things you might also like my recent post about Learning SQL Server for Free Starter Pack.
Do you care about InfoSec and Privacy? Then YOU need to use a VPN.