Solved

MS SQL server Database on a single instance

Posted on 2014-09-25
5
101 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
5 Comments
 
LVL 13

Accepted Solution

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

Expert Comment

by:ScottPletcher
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 46

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

910 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now