<div>
In theory, yes. &nbsp;For practical purposes, you'd probably want to limit it to ~1000 or so.
</div>


In theory, yes.  For practical purposes, you'd probably want to limit it to ~1000 or so.

<div>
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. &nbsp;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).
</div>


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).

<div>
Thanks all of u for the answers
</div>


<div>
<div class="content wysiwyg-content">
Hi ALL<br />
<br />
<br />
I'm new on MS SQL SERVER, but i need to know How Many Database can live into a single Instance?<br />
<br />
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 &nbsp;instance label with new database name <br />
<br />
Thanks in advance for ur help<br />
<br />
Regards.
</div>
</div>


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.

MS SQL server Database on a single instance

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.