Dear All,
I am little bit confused regarding switching my testing DB from Dedicated Server to Shared Server. I hope with the help of you i am able to understand practically the concept.
I want to switch my DB currently running in its default option that is Dedicated to Shared Server. My DB is basically meant for OLTP. Few Restrictions of MTS (Multi thread Server) make me think to understand betterly before doing anythin:
MTS is not for everyone! Before implementing MTS in your environment, keep the following in mind:
Batch Jobs vs. Quick transactions: The use of MTS is predicated on the assumption that each client will use only a small fraction of its connect time to perform any work against the database. The more active your clients are, the greater the number of shared server processes you will need to respond to their requests in a timely manner. You may get to a point to where MTS ceases to make sense at all. Batch jobs or clients that extract large amounts of data should not connect to the database through MTS.
- Latency with MTS: When clients submit SQL statements to be executed, it now has to wait until a shared server process is freed up and can take on the task of executing the statement. The amount of time depends on the number of shared server processes currently running and how busy they are.
- Client's Perspective: Even though the DBA may be reducing the demand for memory and/or CPU on the server, MTS will not result in better performance from the client's perspective.
But there are few advantages of MTS as well:-
Advantages of using MTS:
Reduced Demand for Memory: Since one server process can now handle many clients, you need fewer server processes, resulting in a reduced demand for overall memory.
- More Efficiency: Since there is less idle time with each shared server process, you gain more efficiency within each server process.
- Fewer CPU Resources: Server processes are no longer being built and destroyed for each client connection and disconnect. Fewer resources will now be required in the building and destroying of server processes.
- Communicating Through a Firewall: TCP/IP port numbers can be explicitly specified for MTS dispatchers. Knowing in advance the port numbers that will be used, can sometimes help when dealing with communicating through a firewall.
So kindly anyone help me out with any practical scenario to understand betterly the concept of Shared vs Dedicated effect on OLTP.
Thanks in Advance