Windows Server 2003
1836647 Members
1788 Online
110102 Solutions
New Discussion

W2k3 and SQL 2K problems in clustered environment

 
DragomirAtea
Trusted Contributor

W2k3 and SQL 2K problems in clustered environment

Hi folks!

I've run into a veird problem at a customersite...

Here comes the HW setup.

Servers
2 DL740 G2 each server configured as follows.
8 * 2,7GHz 2MB Cache CPU
32 GB RAM (Usable)
2 * 72 GB (internal RAID1) for OS
2 * FCA 2408
Windows 2003 Enterprise
Microsoft SQL 2000 Enterprise
Configured in a Active/Passive MS Cluster

Storage
HP EVA 3000 2C4D (VCS 3.020)
ZDBDiskgroup (16 * 146GB)
DataDiskgroup (24 * 300GB)
2 * HP StorageWorks 2/16 EL switches
SecurePath 4.0C SP1
BusinessCopy 2.3

All vdisks presented i s VRAID 1

Now to my problem...

Lets say that nod1 is active, it holds all cluster resources. everything works just fine, no performance troubles what so ever...

But!!!

If I power down the passive node (node2) the performance on the active node drops lika a rock. I can barely log on to it and the users complains about responstimes.

How can a powerdown of the passive node effect the active node like that???

Any ideas, because I'm lost...

Regards
Dragomir Zekic