![html optimizer same select html optimizer same select](https://www.prestashopmanager.com/i/2021/01/PrestaShopPerformanceCCC.jpg)
Now that we know that there are three types of Client-Server Architecture, lets us have a glance at TDS: This option is disabled by default and needs to be enabled by the SQL Configuration Manager. We can easily map Tom to Client, Sierra to SQL server, Neighbor to LAN and finally Intra network to Named Pipe Protocol. Here the CLIENT and MS SQL SERVER are in connection via LAN.Īnalogy: Lets map entities in the above two scenarios. Similarly, MS SQL SERVER provides the capability to interact via the Named Pipe protocol. Here Tom and his Neighbor, Sierra, are in same physical location, being each other’s neighbor. Now finally at night, Tom wanted to have a light green tea which her neighbor, Sierra prepare very well. In SQL Management Studio – For Connection via TCP\IP, “Server Name” Option has to be “Machine\Instance of the server.”.Notes from the desk of Configuration/installation: We can easily map Tom to Client, Starbuck to SQL server, the Home/Market place to Remote location and finally Cellular network to TCP/IP protocol. Similarly, MS SQL SERVER provides the capability to interact via TCP/IP protocol, where CLIENT and MS SQL Server are remote to each other and installed on a separate machine.Īnalogy: Lets map entities in the above two scenarios. They’re communicating via Cellular network. Tom at home and Starbucks at the busy marketplace. Here Tom and Starbuck are in different physical location. The Coffee shop is located 10 km away from his home. He wants a Coffee ordered from a well-known Coffee Shop. Now consider in the evening, Tom is in the party mood. We can easily map Tom to Client, Mom to SQL server, Home to Machine, and Verbal Communication to Shared Memory Protocol.įrom the desk of configuration and installation:įor Connection to Local DB – In SQL Management Studio, “Server Name” Option could be Both can communicate via Shared Memory protocol.Īnalogy: Lets map entities in the above two scenarios. Here CLIENT and MS SQL server run on the same machine. MS SQL SERVER – Here MS SQL server provides SHARED MEMORY PROTOCOL. Tom was able to ask for Coffee and Mom was able it serve it hot. MOM and TOM – Here Tom and his Mom, were at the same logical place, i.e. Let’s reconsider an early morning Conversation scenario. We will start with “ Three Type of Client Server Architecture” which MS SQL Server supports. MS SQL SERVER PROTOCOL LAYER supports 3 Type of Client Server Architecture. Data Parsing: Buffer cache & Data Storage.Let’s discuss in detail about all the three above major modules. Let’s discuss in detail the entire architecture shown below:Īs the below Diagram depicts there are three major components in SQL Server Architecture:
![html optimizer same select html optimizer same select](https://www.websiterealizer.com/help/drex_how-to-do-web-performance-optimization-get-higher-marks-on-google-pagespeed-insight_custom_2.png)
The SQL Server accepts, processes and replies to the request with processed data. MS SQL Server process starts with the client application sending a request. MS SQL Server is a client-server architecture.