Length: 1 hour
Modern database administrators have many responsibilities, including perhaps their most important responsibility of performance tuning. Performance tuning takes many forms. It might include tuning server settings, improving database designs, or even extensively tuning queries and query code. This becomes even more important when database workloads moved to the cloud because poor performance increases consumption of resources like CPU, memory, and IOPS.
In this session, we’ll teach you how to conduct a database design review that yields improved storage behavior, consistent table designs, good data types choices, best practices for keys and constraints, and strong indexing. The design review is scripted and does not require the developers to explain their code to you. Instead, you can run a set of scripts on a database that’s actively testing workloads to see if any anti-patterns are in play. We will also show examples of anti-patterns that are the direct result of poor database design choices.
Join us to learn this tips and techniques to improve not only your personal skillset, but also potentially vastly improve your SQL Server and Azure SQL database performance.
Prerequisites: Basic proficiency with core SQL statements, like CREATE, ALTER, DROP, GRANT, SELECT, INSERT, UPDATE, and DELETE
Interested in additional SentryOne webinars? Check our webinar library.