dbTalk Databases Forums  

SQL 2005 active/passive - multiple instances

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering SQL 2005 active/passive - multiple instances

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL 2005 active/passive - multiple instances in the microsoft.public.sqlserver.clustering forum.



Reply
Page 4 of 4 < 1 2 3 4
 
Thread Tools Display Modes
  #31  
Old   
Tom_Slycke
 
Posts: n/a

Default Re: SQL 2005 active/passive - multiple instances - 02-27-2008 , 02:10 PM





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" <SQLCraftsman (AT) gmail (DOT) com> wrote

Quote:
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" <tom_slycke (AT) cox (DOT) net> wrote in message
news:uFjcXYVeIHA.4464 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
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!!!



Reply With Quote
Reply
Page 4 of 4 < 1 2 3 4

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top