T-SQL Programming Dennes Torres in T-SQL Programming SQL Server Batch Process Optimization: Auto-Growth, Locks, Log Flushes, and Index Fragmentation Step-by-step performance tuning of a SQL Server batch process - identifying and fixing auto-growth events, lock contention, WRITELOG waits, index... 08 May 2015 33 min read
Greg Larsen SQL Server Autogrowth Settings: Best Practices Configure SQL Server database autogrowth settings for optimal performance. Learn fixed vs. percentage growth, monitoring auto-growth events, and sizing best... 23 November 2011 19 min read
