Here, the CUSTOMER and MS SQL SERVER are connected via the local network.Īnalogy: Lets map entities in the above two scenarios. Similarly, MS SQL SERVER provides the ability to communicate via the Named Pipe protocol. They communicate through the Intra network. Here Tom and his neighbor Sierra are in the same physical place, being each other’s neighbor. Now, finally, at night, Tom wanted to drink a light green tea, which was very well prepared by her neighbor Sierra.
In SQL Management Studio – to connect via TCP \ IP the “Server name” parameter must be “Computer \ Server instance”. Notes from the Configuration / Installation panel: We can easily match Tom with the client, Starbuck with the SQL Server, Home / Market place with a remote location, and finally with the cellular network over TCP / IP. Similarly, MS SQL SERVER provides the ability to communicate over the TCP / IP protocol, where CLIENT and MS SQL Server are remote from each other and installed on a separate machine.Īnalogy: allows comparing the entities in the above two scenarios. They communicate through a cellular network. Tom is at home and Starbucks is on a busy trading floor. Here Tom and Starbuck are in different physical places. The coffee shop is 10 km away from his house. He wants a coffee, ordered at a famous coffee shop. To connect to a local database – in SQL Management Studio, the “Server name” parameter can beĪnd now let’s see in the evening, Tom is in a festive mood. We can easily match Tom with the client, Mom with the SQL server, Home to Machine, and verbal communication with the shared memory protocol.įrom the configuration and installation desk: Both can communicate via the shared memory protocol.Īnalogy: allows comparing the entities in the two above scenarios. Here CLIENT and MS SQL server work on the same machine. MS SQL Server – Here the MS SQL server provides a common memory protocol. 
Tom could ask for coffee, and his mother could serve it hot. Mom and Tom – Here Tom and his mother were in the same logical place, that is in their house.
Let’s review the conversation scenario in the early morning. We will start with “Three types in client-server architecture”. MS SQL SERVER PROTOCOL LAYER supports 3 types of client-server architecture. Syntactic data analysis: buffer cache and data storage.Step 2: parallel processing and optimization.Stage 1: search for transaction processing plans.
0 kommentar(er)
