Geek Sync Webcast : Faster Transactions: Query Tuning for Data Manipulation
Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session we will discuss common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also what techniques you can use to improve performance.
Jeff Iannucci is a Senior Database Administrator for DriveTime in Tempe, AZ. He has over 20 years of SQL Server experience as both a DBA and Developer in diverse environments such as health care, finance, retail sales, and government. He writes about solving problems for database professionals on both twitter (@DesertDBA) and his blog (desertdba.com), and is a 2020 IDERA ACE.
SQL Workload Analysis
- Granular wait state monitoring
- Continuous SQL sampling
- Intuitive drill down to view top activity
- Query plan tuning and recommendations
- Lock and latch resolutions
- Storage visibility and contention resolution