I have to setup a SQL cluster using a direct attach SAN configuration in a different subnet to it's final "live" environment subnet. I have read documentation that warns against changing IP configuration once the cluster is setup. Can I go ahead and change the IP address after it has been co...more >>

hi everyone, Am presenlty Testing the I/o performance on the new CX-500 San From Emc And Hba From Emulex,The LUn Size is 1 TB and when doing the Testing with SQlIO Tool with a I/o block size-8 i get 39.3 MB/sec for Random write requestes but when doing the same with Random Read req...more >>

Hi, I am planning to move a SQL server to use another hard drive resource of the same cluster, Could we find some easy way without re-install? Thanks. Peter ...more >>

I am trying to setup a MSDTC on Windows 2003 Cluster. I have done the steps in Q301600 and KB 817064. However the MSDTC Resource will start on one of the cluster nodes but not on the other. (2 node cluster). I have checked that both nodes have access to the disk that is used for the MSDTC fi...more >>

I just want to make sure I understand this correctly... If you are running only one database (one instance?), and are clustered, then you must be running in an "active / passive" configuration. There is no way that both nodes can "share" the single database instance across both nodes for i...more >>

I have a sql 2000 cluster act/pas - i want to attach a dlt to backup the databases. Is there any docmentation for this? which server do i attach it to etc? Thanks Lap ...more >>

I have installed 16 gigs of ram in 2 servers that each house a virtual server\instance of SQL. I have the /3gb sw and the /pae switch in the boot.ini and before failing over the group i ran the following script: sp_configure ’show advanced options’, 1 RECONFIGURE GO sp_configure ’awe enab...more >>

We are looking at setting up the following cluster: 3 Active nodes: Each server needs to be completely distinct with its own unique database and its own virtual server and ip. These nodes do not share the same storage with the other active nodes. Active nodes must only process for their own ...more >>

Ever since installing W2K3 SP1 on our SQL 2000 cluster out performance has detiorated dramatically. We're seeing execution times 100 to 200% longer (slower) and huge increase in the amount of blocking and overall locks. We've tried updating statictics and are working with MS now but they d...more >>

Try to install Sql 2005 in 2 node cluster, however, it does not show up share drive, only comes up Q drive, anyone knows how to install it? or any ideas?...more >>

SQL 2000 Ent. on 2003 sp1 Cluster. -Installation & Service accounts are both domain admins -NetBIOS disabled on NICs -CLuster service & failover running properly -Cluster resource names contain no spaces -User PATH for TEMP and TMP set to c:\temp -AVScanner Services stopped -Licensing Mode ...more >>