Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS SQL server Database on a single instance

Posted on 2014-09-25
5
Medium Priority
?
114 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 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

719 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