Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL 2005 active/passive - multiple instances

  
   Database Forums (Home) -> Clustering RSS
Next:  Conditional Text Formatting  
Author Message
Tom_Slycke

External


Since: Feb 27, 2008
Posts: 2



(Msg. 1) Posted: Wed Feb 27, 2008 9:33 am
Post subject: SQL 2005 active/passive - multiple instances
Archived from groups: microsoft>public>sqlserver>clustering (more info?)
I have a SQL 2005 cluster as the backend of my OCS 2007 environment. It is a
shared server. I recently found information that the OCS DB should be on its
own SQL server, or at least its own instance with dedicated spindles for the
data and log files.

The cluster its on now is shared so I guess I'll need to create a new
instance.
Not having a huge SQL clustering background I did a little googl'ing and i
found some messages saying that instances are not support in an
active/passive cluster.
Is this true?

Thanks in advance!!!

 >> Stay informed about: SQL 2005 active/passive - multiple instances 
Back to top
Login to vote
Andrew J. Kelly

External


Since: Sep 01, 2003
Posts: 975



(Msg. 2) Posted: Wed Feb 27, 2008 11:06 am
Post subject: Re: SQL 2005 active/passive - multiple instances [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Active - Active is the old terminology and now adays it is Single Instance
or Multi Instance clusters. And yes what used to be Active - Active can
support multiple Instances. As a matter of fact you have 2 instances by
definition if it was Active - Active. They just weren't both running on the
same node unless you had a failover.

But I question the logic of creating a new instance just for this one app.
While it is true that you should separate high volume db files onto separate
spindles you should look at the metrics to determine if this is necessary or
not. Putting it into its own instance will usually decrease performance not
increase it since each instance has to have a certain amount of resources,
mainly memory. You would be best to determine why and if you need to do
anything before going to the extreme of adding another instance to your
cluster.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Tom_Slycke" wrote in message

>I have a SQL 2005 cluster as the backend of my OCS 2007 environment. It is
>a shared server. I recently found information that the OCS DB should be on
>its own SQL server, or at least its own instance with dedicated spindles
>for the data and log files.
>
> The cluster its on now is shared so I guess I'll need to create a new
> instance.
> Not having a huge SQL clustering background I did a little googl'ing and i
> found some messages saying that instances are not support in an
> active/passive cluster.
> Is this true?
>
> Thanks in advance!!!
>

 >> Stay informed about: SQL 2005 active/passive - multiple instances 
Back to top
Login to vote
Geoff N. Hiten

External


Since: Feb 23, 2005
Posts: 443



(Msg. 3) Posted: Wed Feb 27, 2008 12:59 pm
Post subject: Re: SQL 2005 active/passive - multiple instances [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I have been working with OCS deployments and SQL infrastructure. The
"dedicated" requirement is typical developer misunderstanding of SQL. Most
of these guys developed against SQLExpress on their own machines and seemed
surprised at its performance limitations and projected those limitations
onto full-blown SQL. A properly designed and tuned SQL server (clustered or
not) can handle all the back-end database functions of OCS without having to
build umpteen-jillion dedicated instances/servers.

Our shop is really pushing the envelope on OCS and has not really had any
SQL issues. Then again, I get to design and set up the servers so I know
they will perform adequately.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP





"Tom_Slycke" wrote in message

>I have a SQL 2005 cluster as the backend of my OCS 2007 environment. It is
>a shared server. I recently found information that the OCS DB should be on
>its own SQL server, or at least its own instance with dedicated spindles
>for the data and log files.
>
> The cluster its on now is shared so I guess I'll need to create a new
> instance.
> Not having a huge SQL clustering background I did a little googl'ing and i
> found some messages saying that instances are not support in an
> active/passive cluster.
> Is this true?
>
> Thanks in advance!!!
>
 >> Stay informed about: SQL 2005 active/passive - multiple instances 
Back to top
Login to vote
Tom_Slycke

External


Since: Feb 27, 2008
Posts: 2



(Msg. 4) Posted: Wed Feb 27, 2008 2:10 pm
Post subject: Re: SQL 2005 active/passive - multiple instances [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
This is good feedbace that pretty much supports my thoughts.
The servers in our cluster have dual 3GHz cpus and 4 GB memory. They never
show any CPU stress at all. The only thing I ever questioned was the Disk
Queue Length, but with the drives configured on a SAN, those nubers aren't
quite the flag they used to be on local drives.

Thanks much


"Geoff N. Hiten" wrote in message

>I have been working with OCS deployments and SQL infrastructure. The
>"dedicated" requirement is typical developer misunderstanding of SQL. Most
>of these guys developed against SQLExpress on their own machines and seemed
>surprised at its performance limitations and projected those limitations
>onto full-blown SQL. A properly designed and tuned SQL server (clustered
>or not) can handle all the back-end database functions of OCS without
>having to build umpteen-jillion dedicated instances/servers.
>
> Our shop is really pushing the envelope on OCS and has not really had any
> SQL issues. Then again, I get to design and set up the servers so I know
> they will perform adequately.
>
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
>
>
>
> "Tom_Slycke" wrote in message
>
>>I have a SQL 2005 cluster as the backend of my OCS 2007 environment. It is
>>a shared server. I recently found information that the OCS DB should be on
>>its own SQL server, or at least its own instance with dedicated spindles
>>for the data and log files.
>>
>> The cluster its on now is shared so I guess I'll need to create a new
>> instance.
>> Not having a huge SQL clustering background I did a little googl'ing and
>> i found some messages saying that instances are not support in an
>> active/passive cluster.
>> Is this true?
>>
>> Thanks in advance!!!
>>
>
 >> Stay informed about: SQL 2005 active/passive - multiple instances 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]