Solved

Differece between SQL Server and the Instances

Posted on 2014-03-06
5
200 Views
Last Modified: 2014-03-28
Hello Experts

I am a beginner of SQL server,

I just want to know the difference between a SQL Server and the instances?
In which case, number of instances could be more than the number of SQL server ?
In what cases there is a need of more than one instances in a single SQL Server?
0
Comment
Question by:Pankaj_401
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 12

Expert Comment

by:ibrahim52
ID: 39911814
Interesting question and visit the link below for the answer.

Referred link :
http://serverfault.com/questions/404904/is-there-a-difference-between-sql-server-and-sql-server-instances
0
 
LVL 15

Accepted Solution

by:
Anuj earned 500 total points
ID: 39911815
SQL Server is a relational database engine where you can host your database. In simple words Instance is the name a name you give for the SQL Server installed on your server, this is to identify the SQL Server when you are doing multiple installation on a server.
You can do up to 50 installation of sql server on a server (50 for standalone and 25 for cluster) meaning you can have up to 50 Instance of sql server on a server, each will be identified by its own instance name. when you install the SQL Server for the first time by default "Default instance name" is selected that could be your MYSERVERNAME\MSSQLSERVER you can change this if you wish at the time of installation. So when you do your next installation of SQL Server on the same server that should be a named instance and you must provide a name for the Instance like MyServername\Instance2  etc.

The need of multi-instance of sql server is when you are short of hardware, if you have budget constraints for a new physical server you can install your SQL Server on the same server where your other instance resides. Another scenario for multi-instance is manageability, security etc

check here about instance

There are many considerations when you have multi instance of sql server like memory settings for sql server, affinity mask, disk considerations etc.
0
 
LVL 5

Author Comment

by:Pankaj_401
ID: 39911851
So can we install lets say SQL 2008 r2 twice on the same server/system. If yes, why it would be needed?
0
 
LVL 15

Expert Comment

by:Anuj
ID: 39911864
Yes you can install up to 50 Instance on a server (Considering you are good with Licencing part).  

Here explains the scenarios for running multiple instance of SQL Server
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 39912636
A SQL "instance" is a single installation of SQL Server with its own "instance name".  The instance name must be unique.

Some people treat the terms "SQL Server" and "instance" to be the same.  But most typical is probably to say that a "SQL Server" is the box(es) on which SQL is running, and therefore that a "SQL Server" can support one or more "SQL instances".
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question