August 12, 2010 at 3:13 pm
Hi,
Please could someone provide a simple explanation of exactly what an 'Instance' of SQL Server is?
For example if I install a defualt version of SQL Server.
I then install a second version on the same machine; but choose 'Named Instance'.
Does this mean I have two instances?
If, so, then what resources do they share and what resources are independant? e.g. Query Engine/Storage Engine/ Memory/ Cache's etc
Thank you for any info. Really appreciated.
August 13, 2010 at 5:33 am
Read this Multiple Instances of SQL Server
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 13, 2010 at 6:25 am
- Yes you have two instances if you install default and later install named instance.
- Resources shared are RAM and DISK IO, some these setting's are configured in SQL server by tweaking MAX MEMORY SETTING so each can share say RAM.
- If you have cost constraint and planning to take this path be prepared to handle complexity of managing multiple instances.
If you have no option but to take this burden, make sure you benchmark the application with database instances on test set-ups , before you go ahead deploy for production.
Cheers
Cheer Satish 🙂
August 13, 2010 at 12:30 pm
Thank you both for your help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply