We have an Active/Passive SQL 2005 Cluster running on Windows 2003 Server We have a website using a SQL database backend and have just started to receive the following error All schedulers on Node 0 appear deadlocked due to a large number of worker threads waiting on LCK_M_IS. Process Util...more >>

OK hopefully an easy question for the experts. We are currently trying to design/test implement an SQL Solution to use DB Mirroring with SQL 2005 Ent. We have successfully built an SQL Cluster with 05' Ent SP1 x 64 on with Windows 2k3 Ent 64bit MSCS. We also have an additional Server with...more >>

Hello to all. We have a cluster server in active-pasive configuration, that is running sql server 2000. We are planning replace both nodes of the cluster (one at each step) without taking the entire cluster offline, and it´s critical that the sql service don´t stop when the replacement is...more >>

Hello, I would appreciate if someone can give some advice on hardware for building up SQL 2005 cluster. We will have 4 database of 50 GB each. How many processors, memory,... do I need? My preference is to go for HP servers Thanks in advance ...more >>

Hi there, got a serious problem with my 2 node cluster running sql server 2005: After node 2 crashed, I had to reinstall it. Configuration same as before, then I used the Change option in "Add or Remove Software" to reinstall sql server 2005 on it. But now, the SQL Server Service doesn...more >>

I have heard that SQL servers could benefit if they are virtualized say using VMWare or Virtual Server in production when setting up clusters on 4 way nodes such that in the event that 3 nodes fail, then the 4th node could run those 3 virtual instances on the 4th node. Is that worth thinkin...more >>

Hello, Say if I have 4 host names, HostA,HostB,HostC and HostD and if I want HostA,HostB and HostC to be the active nodes, how do I go about setting up the virtual name ? Will HostA and HostD have a name say HostApp1, HostB and HostD have a name say HostApp2 and HostC and HostD have a na...more >>

Under what conditions will the active node fail to the passive node when automated ? Does it failover if the CPU on active node is pegged at 100% ? Will it failover if the active node runs out of worker threads ? Do let me know. Thanks ...more >>

Say If I build a 4 node cluster where 3 nodes are active and 1 is passive , is it possible theoretically for the 1 node to take over the 3 active nodes onto itself should all 3 nodes fail ? Or is clustering setup only enabled for just one node to failover at a time ? Where can I read mor...more >>

Hi, I'm trying to setup a SQL cluster server on a Active/Passive Server. I get to the prompt where I select the Instance Name. I want to use the default installation however the the Default checkbox is disabled (greyed out). I am forced to select a new instance name which I dont want. How c...more >>

Scenario: 2 x Windows 2003 Servers Clustered, Running SQL 2005 Clustered (Active/Passive) All Service Packs and Patched are up to date, Problem: When you try to log in to an SQL Database remotely it does not allow you and informs you that the SQL Server ...more >>

I have a three node cluster (Windows 2003 ENT with SQL 2000 SP4). We are going to be applying Cumulative Hotfix for SQL Server Service Pack 4 Build 2187 (KB916287). I'm having a disagreement with our DBA. He says that the entire cluster and all named instances need to come down on all three...more >>

Hi, Does anyone know of any training centres/courses that focus on SQL Server Clustering in Ireland/UK? Thanks, Kevin. ...more >>

I don't want to beat a dead horse, but I'm caught in the middle of a situation,and I need some expert advice. We are running multiple SQL2K instances on W2K3 clustered servers in an Active-Active configuration. We would like our service provider to create a clustered SQL2K5 instance on this s...more >>

Hi, Our current production databases use the SQL Server 2000 EE, two named instances with active/passive clustering. I remembered when I install the named instances, I run cliconfg.exe first, create server alias in SQL Server client Network Utility dialog box, then run SQL Server 2000 setup. ...more >>

Hello. We are currently using Windows 2003 and SQL Server 2000 to set up a 2-node cluster with named instances. The problem that we are having is that, if a server is rebooted, the groups that are supposed to fail over, do not. They just go offline. We are in the process of upgrading to ...more >>

Hi, I have configured a win2k3 4 node active/active sql 2005 cluster. I am a bit confused on the ative active part. Presently I have 1 virtual server, which runs fine on one of the nodes. How do I take advantage of the other nodes ? I want to utilize all the nodes, keeping in mind that if 1 fa...more >>

We need to upgrade SQL Server 2K SP3a on our Windows Server 2003 SP1 two nodes Cluster and I have a doubt regarding how to install the latest hotfix. My intention is this: For Service Pack: Backup all database. Stop all monitoring software services like MOM. Restart the servers before insta...more >>

Currently we have 4-NODE SQL Cluster as follows: H/W = 32-Bit processors Windows 2003 EE (32-Bit) SQL 2000 EE (32-Bit) We plan to setup a new 4-NODE SQL Server Cluster with the intention to upgrade to SQL 2005 64-Bit later. Phase I Set up 4-NODE SQL Cluster with following h/w & s/w c...more >>

Hi I'm trying to put a case together to encourage my employer to upgrade from its SQL 2000 Enterprise farm to SQL Server 2005. We're interested in Enterprise functionality, such as: - Improvement in backups - Monitoring improvements - Resilience improvements (mirroring, replication, failove...more >>

Hi, I try to figure out whether - and if yes, how - it works to to set up an active/active cluster with several SQL Server 2005 instances that are using partitioned tables. For example, a big table with orders: Orders A-K <- instance 1 Orders L-Z <- instance 2 Users should be able t...more >>

I have a SQL server cluster running on Server 2003. I am in the process of buying the SQL licenses. The difference in price between SQL Enterprise and SQL Standard are a couple thousand dollars. Does the cluster HAVE to be SQL Enterprise?...more >>

Hi All, we are using: Windows server 2003 R2 Enterprise edition SP1 SQL server 2005 Standard edition installed on shared cluster disk 2 Nodes server connecting and working with in the cluster 4 GB physical memory installed on each server Allow the sqluser permission to Lock pages in memory...more >>

I've set up a win2003 enterprise 2 node cluster with an instance of sql server on each node. It' s running SVC Pack1 and the SQL versions are 2000 with SP4 and SQL 2005 with SP1,both enterprise editions. The above operating systems are guests on a win2003 enterpise server running Virtual Se...more >>

I need a good online reference for setting up a SQL 2005 Windows 2003 multi-node cluster. An explanation of the configuration and behavior of an A-A-P cluster would be greatly appreciated. Thanks!...more >>

Bascially, our applications seems freezing periodically when we perform the loading test. During the test, the CPU usage is only 40% (4 processors), Page/Sec < 0.5, Network Usage is avg 10%. Our SQL Cluster has 8GB memory, and the new application database size is only 12MB in total. I cannot ...more >>

Building a windows 2k3 Enterprise ITANIUM EDITION x64 cluster with SQL 2005. First, is there any step by step guides I can follow for both the version of windows I use as well as sql 2005 in regards to clustering? Second, I know that SQL 2005 works off instances (assigned to resource groups)...more >>

We have 2 clusters, both 2 node active/passive, both have SQL Server running on the Active node. I am using Idera's SQL Diagnostic Manager to monitor and gather statistics on the SQL instances. However, on one cluster, not all of the performance counters have been installed. I asked the net...more >>

Does SQL Server 2005 Standard edition support Active/Active(both servers online) Cluster environment. When i check at features it mentioned fail over (only two nodes), but it didnt mention about active/active. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Than ks,...more >>

I have a sql server 2005 cluster which I have to move from one subnet to an other. Concerning node ip, cluster, sql ressource and msdtc ip's: In which order and how should this be done? How about the msdtc service - could there be any problems here? I have read kb230356 and kb244980 - bu...more >>

A strange problem, SQL Enterp. 64bit cluster on a Win2k3 16GB RAM, a query (Select * from) takes 45 minutes to complete whereas it takes only 11 minutes on a SQL 2000 on a win2k cluster with 8GB RAM :) meanwhile it takes only 6 minutes to export the entire exact table to another table in ano...more >>

Hi, I have a failover cluster with SQL Server 2000 SP4 installed on it. The SQL Server is on the current active node which is SQLUU. last night, I took the SQL Server offline from cluster administrator, and then immediatelt bring online again. However, I see the SQL is trying to be online w...more >>

Hi How many nodes can you have in a cluster? We currently have 2 nodes one active one passive, running windows 2000 SP4 with SQL 2000 ENTERPRISE EDITION. I ask because I want to make our setup more tolerant, so any advice is great. Thank you...more >>

Hi Is it possible to set timeout for method Open of MSCluster.Cluster class? Thanks in advance GrzesB ...more >>

Hi all, is there any way to add a new node to the cluster without getting downtime when applying service pack 1? Let me elaborate. Let's suppose we have a n-node-cluster and want to add node n+1. No problem so far, we add the node, SQL Server 2005 RTM gets remote installed. We can even d...more >>

I have a 2 node cluster running Windows 2003 R2 with SQL 2000 sp4 on it that is placed in our DMZ. There are two virtual servers websqlcl (x.x.x.191) and websqlcl2 (x.x.x.192) This would represent my two instances websqlcl (first) and websqlcl2\db2 (second) ...more >>

We have a 2 node active/passive cluster running SQL2K SP4. I want to add another node and make it Active/Active/Passive with the one active node running the default SQL instance and the other Active running a named instance with the passive node taking over for both instances in a failover ...more >>

I am currently running a 2-node (Active/Passive) SQL 2000 cluster on 2 Windows 2003 machines. Both machines are Dell PE4400 with a PERC3/DC card in each one that attaches to a Dell PowerVault 221 (this is where all databases/logs are kept). Since both machines are getting old I am planning...more >>

Question - do I have a successful SQL 2005 cluster install? I installed SQL 2005 Standard Edition on a two node cluster. However, I had to hit ignore 4 times when the following error message appeared: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ The setup has encou...more >>

Normally when I install SQL in a stand alone situation, the TCP/IP Socket defaults to 1433. However when I'm installing (this is just testing for now) the default port gets set to "0". Do I need to manually change it back to 1433? ...more >>

Well, we have a SQL cluster setup as active/passive, W2K + SQL2K (sp3). We need to do some loading test on this box to evaluate its capacity. We already have AWE enabled with 8GB. Our disk is SAN. My question is:- 1. Which address Performance Monitor should use to monitor the box, the virtu...more >>

Hello Everyone, Could someone tell me how to install Reporting Services 2005 as a clustered service? I'm running SQL 2005 STD on Windows 2003 R2. Any help would be greatly appreciated. Thank you Alex Anderson ...more >>

Hi, We are running portal server front end (3 servers) and sql2k clustered (active/passive) as the back end. We would like to upgrade to sql2005. Any suggestions on the best method? thanks, Gregg...more >>