 | |
Active/Active 2005 Slowness
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#61
 
| |||
| |||
|
Re: Active/Active 2005 Slowness -
06-17-2008
, 12:57 PM
|
Yes. Thank you Edwin --GNH "Edwin vMierlo [MVP]" <EdwinvMierlo (AT) discussions (DOT) microsoft.com> wrote in message news:utLstUH0IHA.5928 (AT) TK2MSFTNGP06 (DOT) phx.gbl... I agree with Geoff, very carefully go over your implementation/configuration and ensure you have all best practices implemented. And I am sure that Geoff means Windows 2003...... in stead of 2004. ;-) "Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote in message news:OOS4LL%23zIHA.4476 (AT) TK2MSFTNGP06 (DOT) phx.gbl... No, that is enough. The CX3 series is one of the better choices for a database back end. There is defintely something not right sbout your configuration. Memory on one or the other server is a prime candidate. In WIndows 2004/SQL2005 clustering, all nodes should perform equally well if they have a single instance. Stacking instances on a single node will require ACTIVE memory management on your part or second and later instances will perform extremely poorly. -- Geoff N. Hiten Principal SQL Infrastructure Consultant Microsoft SQL Server MVP "Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote in message news:31A60C36-1C91-43A5-A4DB-FE118FADABA1 (AT) microsoft (DOT) com... EMC CX3-20c Do you need more specifics? Or should I just be perfmonning something? "Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote in message news:%23Rhqn6WzIHA.4848 (AT) TK2MSFTNGP05 (DOT) phx.gbl... What is your storage system? -- Geoff N. Hiten Principal SQL Infrastructure Consultant Microsoft SQL Server MVP "Kevin A" <kevina (AT) cqlcorp (DOT) com> wrote in message news:35396D16-0759-4048-9012-0C7C28F8E273 (AT) microsoft (DOT) com... Anyone have any ideas why a SQL 2005 active/active configuration, would be noticibly slower than if I move one of the active nodes to the other and run on the same node? It doesn't matter which node I put them on, when I run them on 2 different nodes, SLOW, when I move them both to the same node, faster. Each node has the same config, and it doesn't matter which instance is on which node. They are both slow by themselves. Anything from a SQL or configuration standpoint? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.