Load balancing

IS any way i can unable load balancing, Like i have two server poining to on
e
database on SAN and share the CPU and memory .
Is active /Active clustering give these feature
How can be active/active clustering differnet from active/passive cluseringThere's no transparent load balancing for SQL Server. for more manual approa
ches, look into things
like "distributed partitioned view", replication, and of course manually spl
itting the data into two
databases one on each server. Clustering is for fail over, not load balancin
g.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sunil" <sunil@.discussions.microsoft.com> wrote in message
news:223B5636-6457-4A31-988E-7A1D32870624@.microsoft.com...
> IS any way i can unable load balancing, Like i have two server poining to
one
> database on SAN and share the CPU and memory .
> Is active /Active clustering give these feature
> How can be active/active clustering differnet from active/passive cluserin
g
>|||> Is active /Active clustering give these feature
SQL Server clustering is built on the shared-nothing model, meaning that no
resource is shared between the nodes of the cluster at the same time. You
may hear peopel talking about a shared disk in a cluster. The term 'shared'
in that context just means that the cluster nodes can take turn
accessing/using the disk.

> How can be active/active clustering differnet from active/passive
> clusering
Fundamentally, there is no difference between active/active and
active/passive. Loosely, people use ther term 'active/active' to mean that
both nodes (assuming a two-node cluster) are running SQL Server instances.
But these are different instances, thus managing different databases. And
the term 'active/passive' generally means that one node is not being used at
any given time, and is kept as a standby. In case the SQL instance(s)
running on the other node (i.e. the active node) runs into any problem, the
cluster service will start the SQL instance on this node, taking over the
rsources and making it active and the other passive (if it's available at
all). But there is absolutely no difference in terms of how the clutser
service decides to fail over a resource--including the SQL resoruces.
Some people prefer to use terms like single instance and multiple instances
instead of active/passive and active/active. But the latter seem to be more
intuitive to a lot of people.
Linchi
"sunil" <sunil@.discussions.microsoft.com> wrote in message
news:223B5636-6457-4A31-988E-7A1D32870624@.microsoft.com...
> IS any way i can unable load balancing, Like i have two server poining to
> one
> database on SAN and share the CPU and memory .
> Is active /Active clustering give these feature
> How can be active/active clustering differnet from active/passive
> clusering
>