Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS SQL server Database on a single instance

Posted on 2014-09-25
5
Medium Priority
?
116 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 1000 total points
ID: 40345063
0
 
LVL 70

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 52

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

963 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