SQL Server defaults to growing data files by 1MB and transaction logs by 10%; neither of those are best practice. If your database is small
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
Getting Database Data/Log File Growth from Default Trace
How to calculate database growth rate using default trace?
How to implement PAL (Performance Analyis of Log) counters in Windows 2003?
How to implement PAL counters in Windows 2003?
How to find out what is causing page splits?
Client was noticing high number of Page Splits/sec in relation to Batch Request/sec; however could not figure out why. They were not have performance issue but
How to find the log file usage for a transaction in SQL Server 2005?
Word of caution before you try/read this: I am using undocumented function to read the trace file. I do not grantee the results to be
SQL Server System Views Chart
If you are junkie like me you most likely have this already, just in case you don’t; here are some useful links :). SQL Server
SQL Canada (SQLCAN) 