Solved

MS SQL server Database on a single instance

Posted on 2014-09-25
5
111 Views
Last Modified: 2014-09-26
Hi ALL


I'm new on MS SQL SERVER, but i need to know How Many Database can live into a single Instance?

I'm trying to compare this with Oracle that Database name can be TESTDB_I1 but the DB name is TESTDB, so i want a second Database i will have new  instance label with new database name

Thanks in advance for ur help

Regards.
0
Comment
Question by:Pepe2323
[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 13

Accepted Solution

by:
Russell Fox earned 250 total points
ID: 40345063
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 40345099
In theory, yes.  For practical purposes, you'd probably want to limit it to ~1000 or so.
0
 
LVL 25

Expert Comment

by:Mohammed Khawaja
ID: 40345190
Maximum is 32,767, however, best way to do is to add few databases, monitor resources and performance and if all okay then add more.  More databases can be accommodated if you have large amount of memory and disk space which has lots of spindles (i.e. RAID arrays which lots of disks).
0
 
LVL 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 40345502
Be careful when comparing Oracle Databases and Instances with SQL Server. Their definition aren't the same for both RDBMS. Actually an Oracle database it's pretty much like a SQL Server instance and the Oracle instance it's like to be a SQL Server database.
0
 
LVL 8

Author Closing Comment

by:Pepe2323
ID: 40346154
Thanks all of u for the answers
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

617 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