Resources

Here are some presentations I have done and their associated slides / files.

Environmental SQL Server Troubleshooting

Abstract: 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!

Slides: Environmental SQL Server Troubleshooting

For more information please check out these posts:

  1. Microsoft SQL Server Environmental Checks
  2. SQL Server Environmental Diagnostics Guide
  3. SQL Serer Environmental Diagnostics Guide – OS
  4. SQL Server Environmental Diagnostics Guide – VMware