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-patters 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!
Kevin Kline, Principal Program Manager SentryOne
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.