I have a SQL server that has started to get fairly busy, to the point where
our web application customers are saying their app is running too slow to be
usable.
I was wondering if I could have some tips as to wether it would be better

Dear gurus,
i need help!!
i want to setup a clustering environment using two nodes and connected
to a storage.

OK, so we have had our SQL 2K5 Active/Passive cluster in place for a while
now and things are gradually slowing down.  I need to start thinking about
what to do next to maintain a satisfactory level of performance.  (In terms
of upsizing versus archiving, further optimisation, ...

I need to create an environment for failover clustering
and I have an existing hardware
Does microsoft offers some special hardware for failover clustering?

One node of a two node cluster failed yesterday. The second node came active
but when it tried to create the shares it failed with event ID 1068 "failed
to start with error 2116" and "failed to start with error 87" I cannot find
these error codes. Any help will be appreciated

For testing purposes is it possible to mirror databases on different OS? The
version of SQL is the same.  I thought I remembered reading something about
the differences in encrption technology???

Simple sql cluster - 2 machines active\passive
I see that any sql activity is written to both logs (logins, backups,
etc) to both servers.  They have the same time stamps.  I would of
thought that it only writes to only the event logs for the active

 I have a Physical/Virtual node MSCS failover cluster.  I am running 64bit
SQL 2005 and Windows 2003.  I have read enough posts that indicate you in 64
bit SQL Server you should set the max memory.  Unfortunately my physical box
has 32 GB of memory (I could utilize all of it!) ...

Both 2 nodes run on Win2003 Enterprise. What IIS version ought to be
installed? 6.0 or 7.0 beta?

We have a W2K3 EE cluster with 1 SQL Server 2005 instance on each.  Currently
we have 4GB of memory each with the default settings.
We are getting new memory to take each server up to 16GB.  I want to set my
min/max server memory to 7.5GB so we can failover successfully and not ...

We have sql server 2000 and 2005 on one server (windows 2003 server). Is it
possible to cluster both instances with another server? Are there any
special considerations for this situation?
Thanks in advance,

I am trying to enable AWE memory utilization on my two node cluster. I
have made the policy changes to the LOCK PAGES IN MEMORY option. I know
this change is going to require a reboot. Can i just run a normal reboot
failure to the backup node. Wait for the Main node to comeback ...

As the subject indicates, I am very new to Failover Clustering.
Nevertheless, I need to get this up and running for the organization.
I suppose it's a 2-node cluster that I will be configuring. The first
being the principal server and the second being the failover cluster.

I'm setting it up using the directions provided by Microsoft @
http://msdn2.microsoft.com/en-us/library/ms189047.aspx
The problem I originally ran into was exactly like the one mentioned in the
following posting:

I have a cluster with one right working Node, and I want to add second
Node to existing structure. Every stores (disks, cluster name and IP,
SQL IP, SQL network name) except SQL moves between nodes succesfully.
Installation of SQL 2K SP2 at Virtual Server proceed correctly, but I