Next Meeting: Thu, Nov 20 2014
20 NOV 2014 NTSSUG Meeting
6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 7:20 - Scaling and deploying SQL Server 2014 on high core count quad socket servers by Maurice De Vidts
7:30 - 8:30 - TBD
8:30 - 8:45 - Raffle and closing
Event Time : Thu, Nov 20 2014 18:00 - 21:00 (GMT-06:00) Central Time (US & Canada)
Your Local Time: Fri, Nov 21 2014 00:00 - 03:00
Microsoft Building LC-1
7000 North Highway 161
Scaling and deploying SQL Server 2014 on high core count quad socket servers
Maurice De Vidts , Performance Engineer HP
The session presents deployment topologies and performance characterization of SQL 2014 OLTP databases deployed on Windows 2012R2 in a quad socket environment. From a deployment perspective the session presents multiple physical deployment models including multi-instance and multi-database NUMA aligned installations. In addition, current best practices related to NUMA alignment for SSIS instance co-deployments are shown in both physical and hyper-v topologies. From a performance perspective the session outlines key best practices to achieve optimum performance in high core count servers. Test results highlight the impact subtle SQL default parameters can have if not addressed when migrating from a smaller core count server to a quad core server. Finally a few examples from the field on what to be particularly aware of during platform migration and scaling and notes of interest regarding new licensing model for SQL 2014.
Maurice De Vidts is a performance Engineer with HP. At HP Mr. De Vidts works developing reference architectures and best practices for SQL databases deployed on HP Converged Systems, servers, and storage platforms. He received his B.S.E.E. from the University of Maryland and has been working with databases over 20 years. Prior to his 7 years working at HP, Mr. De Vidts worked as a database consultant and DBA in a number of industries including Energy, State and Federal government. Throughout his career, he has focused on performance tuning and troubleshooting complex systems where he enjoys maximizing database efficiency by tuning both hardware and software layers in the architecture. On his free time he enjoys alpine sports, aikido and scuba diving. Mr. De Vidts is currently certified as a SQL 2012 Data Expert , and Oracle 9i.