The Guru's Guide to SQL Server Architecture and Internals helps SQL ... notification services, DTS, and replication, in the third section. Finally, the fourth section takes you where few can ...

General Purpose is a SQL MI architecture where compute layer (which runs the SQL Server Database Engine process and is being used for query processing & data caching) is separated from the storage ...