Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better, and more efficiently. In this Geek Sync, Monica Rathbun will go over some of her go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. This session will cover memory optimization, isolation levels, trace flags, statistics, configuration changes, and more. Monica will go over real life scenarios we come across as consultants and the changes we made to fix them.

Speaker: Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com.

Topics: Database Administration, Database Performance, SQL Query Performance, Database Diagnostics, Database Monitoring
Products: SQL Diagnostic Manager for SQL Server