Gavin is a Microsoft Certified Architect, Microsoft Certified Master and a senior consultant for Coeo Ltd, a Microsoft Gold Partner, where he architects, implements and troubleshoots mission critical SQL Server environments.
If you’ve only ever chosen to use Microsoft database products then there’s a chance you might hide a curiosity deep down about the Oracle database platform; or like me a few years ago be told that your next big production system will use it and now’s the time to upskill. This session introduces some key concepts and differences about the Oracle database platform to people like myself who are used to the UI-heavy Windows-based database world and hopefully make you curious enough to want to at least give it a try when you get back home.
Here I share a checklist I created from my experience and theory designed to make sure we’re ready to put our business critical SQL Servers on a virtualised platform and are prepared for the next time we get a database performance issue.
Virtualisation changes the way you need to monitor the performance of a virtualised instance of SQL Server. In this session I will demonstrate a balanced and well-rounded approach to performance monitoring in the virtual world along with best practices to avoid poor virtualised performance.
This session reviews the purpose of NUMA, how it changes the internal behaviours of Windows and SQL Server 2012 and NUMA related performance monitoring.