What is the Maximum Number of Instances Can We Install on Windows?

Shervan360 1,661 Reputation points
2021-10-30T22:12:03.873+00:00

Hello,

What is the Maximum Number of Instances Can We Install on Windows?

145188-screenshot-2021-10-30-181106.jpg

SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
    2021-10-31T09:53:13.193+00:00

    According to: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15:

    50 instances on a stand-alone server.

    25 failover cluster instances when using a shared cluster disks as storage.

    50 failover cluster instances with SMB file shares as the storage option.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2021-10-31T01:27:34.23+00:00

    Shouldn't be a problem. As far as max number? At some point you may run out of server resources.
    https://learn.microsoft.com/en-us/sql/sql-server/install/work-with-multiple-versions-and-instances-of-sql-server?view=sql-server-ver15

    .--please don't forget to upvote and Accept as answer if the reply is helpful--

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.