Friday, February 24, 2012

Clustering Virtual vs Instance

I successfully installed a SQL Virtual Server and a SQL Instance on a
Clustered Environment. Is there a limitation as to the number of additional
Vitual or Instances I can add. Also, what would be considering best
practice? Virtual or Instance?
Thank You in Advance!
Drake Teran
In a cluster, Virtual Server = Instance. YOu create a enw instance, you
create the Virtual Server to install it into. They are one and the same in
a cluster. You get up to 16 instances in a cluster.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Admiral" <admiral@.blackopsplatoon.com> wrote in message
news:u62RalJ5FHA.3388@.TK2MSFTNGP11.phx.gbl...
>I successfully installed a SQL Virtual Server and a SQL Instance on a
>Clustered Environment. Is there a limitation as to the number of
>additional Vitual or Instances I can add. Also, what would be considering
>best practice? Virtual or Instance?
> Thank You in Advance!
> Drake Teran
>
|||When creating the Virtual Server/ Instance. I was able to call it a single
name "ExampleSQL", but the next instance created I had to name it
"ExampleSQL2/SQL". For all SQL vitual servers/instances creating from this
point forward require the "ExampleSQL2/SQL" convention?
Thanks in Advance
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:e2qJJAK5FHA.1464@.tk2msftngp13.phx.gbl...
> In a cluster, Virtual Server = Instance. YOu create a enw instance, you
> create the Virtual Server to install it into. They are one and the same
> in a cluster. You get up to 16 instances in a cluster.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Admiral" <admiral@.blackopsplatoon.com> wrote in message
> news:u62RalJ5FHA.3388@.TK2MSFTNGP11.phx.gbl...
>
|||Correct. Each cluster can handle up to 16 instances - 1 default plus 15
named or 16 named (no default).
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Admiral" <admiral@.blackopsplatoon.com> wrote in message
news:uYW4WbK5FHA.1420@.TK2MSFTNGP09.phx.gbl...
> When creating the Virtual Server/ Instance. I was able to call it a
> single name "ExampleSQL", but the next instance created I had to name it
> "ExampleSQL2/SQL". For all SQL vitual servers/instances creating from
> this point forward require the "ExampleSQL2/SQL" convention?
> Thanks in Advance
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:e2qJJAK5FHA.1464@.tk2msftngp13.phx.gbl...
>
|||Thank You!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uYZ5FlK5FHA.3544@.TK2MSFTNGP09.phx.gbl...
> Correct. Each cluster can handle up to 16 instances - 1 default plus 15
> named or 16 named (no default).
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Admiral" <admiral@.blackopsplatoon.com> wrote in message
> news:uYW4WbK5FHA.1420@.TK2MSFTNGP09.phx.gbl...
>

No comments:

Post a Comment