I'm trying to know how exactly SQL Server works internally. What happens when an instance starts up, how the memory allocation starts like that. I'm trying to find in BOL for SQL Server 2005 Architecture, but it always gives details about individual components of SQL Server 2005 (http://technet.microsoft.com/en-us/sqlserver/bb671443.aspx)