Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 118
  • Last Modified:

MS SQL server Database on a single instance

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
Pepe2323
Asked:
Pepe2323
2 Solutions
 
Russell FoxDatabase DeveloperCommented:
0
 
Scott PletcherSenior DBACommented:
In theory, yes.  For practical purposes, you'd probably want to limit it to ~1000 or so.
0
 
Mohammed KhawajaManager - Infrastructure: Information TechnologyCommented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Pepe2323Author Commented:
Thanks all of u for the answers
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now