Architectural Choices That Affect Performance: Why Design Impacts Performance on Microsoft SQL Server


This session takes you through ten common design choices made during the creation of a Microsoft SQL Server database application which hurts performance of your application. 

This session is great for Developers who have not had much training on database and for DBAs who are usually concerned with keeping servers up and running, but not done much database design. We’ll cover a variety of topics, such as:  

  • What are the basics of tables and indexes? How do data type choices directly impact the size, I/O burden, and performance of applications?  

  • What are the most common database design issues that surface in application code? How can you detect them? 

  • What are the primary techniques database designers use to improve performance when optimizing a database design? 

If you are a DBA, do you have scripts you can run to perform these checks? If you are a Dev, do you know which common design choices are actually pitfalls? If not, then you should attend!  This session takes you through a variety of demos that show what sort of anti-patterns are common in applications you buy on the open market, how to detect them and, when possible, how to refactor those problems. Don’t miss out! 

Interested in additional SentryOne webinars?  Check out our webinar library.

Available On Demand

Kevin Kline

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at sentryone.com/blog/author/kevin-kline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Companies with the highest demands for database performance choose SentryOne