Home » sql server architecture tips

sql server architecture tips

SQL server Architecture: SQL Server Architecture is defined by a  Client Which initiates or open a connection to SQL Server using a SQL Query − SQL query which is high level language. The connection to SQL Server involves Network protocols like TCP/IP used for connections which are in WAN connectivity to the Server, Shared memory  is used for local connections, Named pipes is used for connections which are in LAN connectivity.

SQL Server   is the server where SQL Services are installed and databases is hosted.

Architectural components which makes SQL Server work.


SQL OS lies in-between the Windows OS and SQL Server. All the activities performed on database engine are executed using SQL OS. SQL OS handles the … Read the rest