Main Content

Data Files and Transaction Logs – Beyond the GUIs

About the Talk

November 5, 2011 11:45 AM

Microsoft MTC 5404 Wisconsin Ave Suite 700 Chevy Chase MD 20815

Microsoft MTC 5404 Wisconsin Ave Suite 700 Chevy Chase MD 20815

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 files be auto-shrunk? Why keep that free space in the files? 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

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus