Tue, Jan 06 2015 11:00 UTC
Performance Tuning Pit Stop for DBAs
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).
JOIN PASS then add our Virtual Chapter to your list
Please join this site by creating a user account. This can be accomplished by clicking here. All registered users will be emailed detailed instructions prior to each meeting. Thanks!
Please join this site by creating a user account. This can be accomplished by clicking the 'Register' link at the top of your screen or by clicking here. All registered users will be emailed detailed instructions prior to each meeting. Thanks!
Share your knowlede and skill, become a speaker. If you would like to speak at a future DBA Fundamentals event, please send us an email and we'll get back to you. We are looking for professionals with level 100 presentations in a wide variety of database administration topics. We look forward to hearing from you!!
Meetings At A Glance
Register: Solving the Accidental DBA Problem
Tuesday, 01/06/15 -- Ayman El-Ghazali
Register - Perfromance Tuning Pit Stop for DBAs
Tuesday, 01/20/15 -- Kimberly L. Tripp
Register: Statement Execution and the Plan Cache