• Home
  • DBA Scripts
    • Oracle Scripts
    • SQL Server Scripts
  • Knowledge Base
    • Oracle Database
    • MS SQL Server
    • MongoDB
    • MariaDB
  • Troubleshoot
    • Oracle Database Issues
    • SQL Server Issues
  • Interview Questions
    • AWS Interview Questions
    • Oracle DBA Interview Questions
    • SQL Server Interview Questions
  • Courses
    • Oracle Database
    • Oracle DBA L1
    • Oracle DBA L2
    • Oracle DBA L3
  • Home
  • DBA Scripts
    • Oracle Scripts
    • SQL Server Scripts
  • Knowledge Base
    • Oracle Database
    • MS SQL Server
    • MongoDB
    • MariaDB
  • Troubleshoot
    • Oracle Database Issues
    • SQL Server Issues
  • Interview Questions
    • AWS Interview Questions
    • Oracle DBA Interview Questions
    • SQL Server Interview Questions
  • Courses
    • Oracle Database
    • Oracle DBA L1
    • Oracle DBA L2
    • Oracle DBA L3
home/Knowledge Base/MS SQL Server/Client – Server Architecture
Popular Search:Oracle, SQL Server, MongoDB

Client – Server Architecture

752 views 1 August 30, 2019 June 5, 2020 admin

CLIENT – SERVER ARCHITECTURE:

CLIENT (SSMS) COLLECTS THE QUERIES, EMBED THEM INTO “TDS” PACKETS. TABULAR DATA STREAM PACKETS.
THESE PACKETS ARE ENCRYPTED [SECURED] AND TRANSFERRED TO THE SERVER USING PROVIDERS (DRIVERS).

TYPES OF DRIVER PROGRAMS FOR DATABASE CONNECTIONS IN REAL-TIME:

1. SQL NATIVE CLIENT (SNAC) : USED FOR LOCAL SQL SERVER TO REMOTE SQL SERVER COMMUNICATION

2. OLE-DB (OBJECT LINKING AND EMBEDDING DB DRIVER): USED TO COMMUNICATE SQL SERVER WITH
OTHER DATA STORAGE PLATFORMS LIKE EXCEL, ORACLE, SAP, ETC..

3. ODBC (OPEN DATABASE CONNECTIVITY DRIVER) : USED TO COMMUNICATE SQL SERVER WITH ANY TYPE
OF DATA SOURCES INCLUDING PDF, WORD, HTML, APPLICATIONS, ETC..

THE TDS PACKETS ARE SENT TO SERVER. SERVER “COMPILES” THE CONTENT IN TDS PACKET. EXECUTES. THE RESULT IS
SENT TO THE CLIENT (SSMS) IN THE FORM OF TDS PACKETS. DEFAULT PACKET SIZE : 4096 BYTES.

NOTE: THE PROCESS OF EMBEDDING THE QUERIES INTO TDS PACKETS IS PERFORMED BY USING “PROTOCOLS”
NOTE: THE PROCESS OF ENCRYPTION [HIDING THE QUERIES IN TEH TDS PACKET] IS ALSO PERFORMED BY “PROTOCOLS”

DURING SQL SERVER INSTALLATION:

A SET OF FIVE SYSTEM DATABASES ARE AUTO CREATED.

MASTER – USED TO STORE SERVER PROPERTIES AND LOCATION OF OTHER DATABASES, CONNECTIONS.
MODEL – USED AS A TEMPLATE FOR NEW DATABASES WE CREATE IN FUTURE.
MSDB – USED BY SQL DBAs FOR JOBS, ALERTS, EMAILS, REPAIRS, TROUBLESHOOTING
TEMPDB – USED BY DEVELOPERS AND TESTERS FOR TEMPORARY CALCULATIONS, TEMP STORAGE
RESOURCE – HIDDEN, READ ONLY DATABASE. USED FOR CONTROLLING ABOVE DATABASES.

Tags:Architecture

Was this helpful?

1 Yes  No
Related Articles
  • MS SQL Server Notes
  • Important Counters (perfmon.exe)
  • Restoring Backup via Scripts
  • Restore Backup in SQL Server
  • SQL Server JOBS
  • Backup using T-SQL
Leave A Comment Cancel reply

MS SQL Server
  • Client – Server Architecture
  • MS SQL Server Notes
  • Important Counters (perfmon.exe)
  • Restoring Backup via Scripts
  • Restore Backup in SQL Server
  • SQL Server JOBS
View All 20  
Popular Articles
  • Upgrade Oracle Database from 11.2.0.3 to 12.1.0.2
  • Upgrading MariaDB on Windows
  • Oracle DBA Basic Interview Questions Part A
  • Purging Oracle Sysaux Tablespace
  • Client – Server Architecture
KB Categories
  • Oracle Database
    • Oracle RAC
    • Oracle ASM
    • Oracle GoldenGate
    • Oracle Tuning
    • Oracle 11g Database
    • Oracle Database Upgrade
    • Oracle 12c Database
    • ALL KB Oracle
    • Oracle 18c Database
    • Oracle Standby Database
  • MongoDB
  • MS SQL Server
  • MySQL
  • Interview Questions
    • AWS Interview Questions
    • Oracle DBA Interview Questions
    • SQL Server Interview Questions
  • MariaDB
Database Organization

Database Organization (DB ORG) is knowledge base for DBA to learn and execute the fundamental of different databases under one website. DB ORG is a non-profit initiative. ORACLE, MS SQL Server, MongoDB, MariaDB, Couchbase

Join Our Community
  • KnowledgeBase
  • Documentation
  • Troubleshoot
  • FAQ
Information Links
  • About DBOrg
  • Licenses
  • Terms
  • Privacy Policy
Contact Us
    DB ORG - Database Administration,
    Knowledge Base for DBA
    Mail: support@databaseorg.com
    WhatsApp: (+91) 9306440957
    Monday to Friday: EST - 11:30 AM to 06:30 PM (IST - 9:00 PM to 4:00 AM)
  • © 2023 Database Organization - DB ORG. All Rights Reserved.

Popular Search:Oracle, SQL Server, MongoDB

WhatsApp DB Org