Minimize failover time
Mon, 1 Sep 2008 07:23:00 -0700
I have a two node cluster (active/active).
When I try the failover with the cluster administrator tool I have seen that
it occurs 15-20 seconds to recover the SQL Server resource.
Is it possible to decrement the failover time for the SQL Server resource?
How?
Thanks ...
|
Which tcp port to assign to optimize failover cluster performance
Sat, 30 Aug 2008 22:50:00 -0700
In order to optimize failover cluster performance, I have read it is useful
to use a static port and not the dynamic port (e.g. 1433). To use a static
port, how I can determine which port number to fix?
Thanks ...
|
Installing SSIS 2005 in a clustered environment
Fri, 29 Aug 2008 07:20:00 -0700
I have a two node cluster (a/a) with two SQL Server instances.
Now, I have to plan to install SSIS, but not as cluster resource.
Each node have a local disk. Each SQL Server resource group have two
disk (one for the data and the other one for the transaction log) on a SAN.
I think to install SSIS on each node. D ...
|
SQL server Full text catalog problem
Fri, 29 Aug 2008 10:15:52 +0300
hello to everyone ,
We have in our company a two nodes active-passive cluster with SQL Server
2000 SP4.
Recently one of our customer required from us to create a full text
catalog for some tables & columns
for his database.
So we made it ,but we realise that Microsoft Search didn't work when ...
|
Looking for high performance cluster storage
Thu, 28 Aug 2008 13:00:22 -0700 (PDT)
I have a 2 node SQL 2005 cluster (active-passive) that currently has a
single direct attached SCSI array for it's shared storage. Because
we've reached the performance limit of the SCSI array, I want to
replace it with multiple SAS arrays connected to multiple controllers
to reduce contention. I like the Dell ...
|
Uncluster SQL 2005
Thu, 28 Aug 2008 12:29:12 -0700
We currently have a 2-node SQL 2005 cluster. We need to break the cluster
and turn it into a standalone server without losing the existing instances
or databases
We want to completely get rid of the clustering, not just run a single-node
sql cluster.
Is this possible?
Thanks.
...
|
Can not Switch to 3rd node: error ID 5042: cluster node was not fo
Thu, 28 Aug 2008 11:10:01 -0700
I have a active-active node running well, and need to add 3rd node. following
bol I was able to install 2 instances on 3rd node, however, I only can swtich
2# instance to 3rd node, but 1# instance gives me the error: An error
occurred attempting to move the 'SQLAPP' group. The cluster node was not
found. Err ...
|
|
|
Accounts Server$
Wed, 27 Aug 2008 16:32:01 -0700
Hi,
One my cluster environment I have Server02p$ account name for the 2nd
partner, Server02p in an active-passive configuration. But I don't have one
for 1st partner; so when SQL cluster fails over to 1st partner Server01p;
because Server01p$ doesn't exist it fails to create the account.
I have r ...
|
Re: Cluster licensing
Wed, 27 Aug 2008 09:16:00 +0100
> Oh, my understanding was that with active/active that it is load balancing
> the same database on shared storage and if one fails the other just keeps
on
> trucking. That can't be done?
common misunderstanding, Microsoft Failover clustering is a "shared nothnig"
cluster model, and therefore the SQL inst ...
|
Getting SQL 2005 to see all shared drive on an MSCS Cluster
Mon, 25 Aug 2008 08:40:59 -0700 (PDT)
I have a MSCS Cluster residing within two esx hosts, there are three
shared disks and a quorum drive, each is currently available to the
server and cluster. The problem is during the installation I was only
able to select one of the shared drives.
How do I get SQL to see the other drives? I would like to pla ...
|
