Our users are in constant demand of faster running servers that spill out data before they can blink. Performance can be hard to measure and improve. Before we get in the race we will cover how to get a Performance baseline using the PAL Tools. The first Pit Stop will be to review TempDB setup to improve performance. Before getting into high gear we'll pull over to refuel on some Log File best practices and performance implications of VLFs. Finally before passing the checkered flag we'll make one more stop to talk about Data Files and improving your mileage from there. After this session you'll have a good idea of how to make changes transparent to any application to get your server crossing that finish line in style!
Ayman is a passionate SQL Server DBA, Developer, and Business Intelligence Developer. He is currently a Senior Consultant with Microsoft and lives in the Washington DC Metro Area. His passion for technology started when he was a young boy playing DOS games on his father's computer. He has worked with the SQL Server product since 2006 and holds MCSE Data Platform. He can be reached via his blog or twitter handle and is looking forward to connecting with other SQL Geeks (www.thesqlpro.com | @TheSQLPro).