Explaining SQL Server Architecture in one diagram or Image is very difficult.
Even if we get the same from any blog or website, it is not so easy to understand.
Many of us till date did not even know, what are different engines and their use. Continue reading
Filed under: ADMINISTRATION, Architecture, Quick DBA | Tagged: backup restore commands queries, client protocols query processor optimizer architecture, dirty pages flush memory wal protocol difference checkpoint lazy writer, full simple bulk logged recovery model architecture, quick dba, row page extents filegroups, sql database storage relational engine architecture, sql logical physical data log file architecture, sql security windows mixed mode authentication architecture, sql server acid properties dcm bcm iam pfs boot gam sgam, sql server architecture explained diagram image basics, sql server learn training 2000 2005 2008 2012, sql server popular important interview questions, transaction locking block deadlock isolation level architecture, use of master msdb model tempdb system databases, use spn port 1433 connection pool network protocol shared memory tcp ip named pipe | 1 Comment »