Main Content

Data Files and Transaction Logs -- Beyond the GUIs

About the Talk

December 7, 2010 5:00 PM

Microsoft Technology Center 12012 Sunset Hills Rd. Reston, VA 20190

Microsoft Technology Center 12012 Sunset Hills Rd. Reston, VA 20190

Performance of SQL Server poor? One cause may have been that starting file size that you didn't think was important because it will auto-grow. Why is auto-grow bad? Why shouldn't logs be auto-shrunk? Explore the physical structure of a database, how table structure effects use of memory and key mistakes to avoid. Additionally, dive into the transaction log process - VLFs, auto-recovery and lock escalation. Solid foundation for Programmers and Administrators!

Ratings and Recommendations

Avg. Rating

Average based
on 1 rating

comments powered by Disqus