SQL 2005 - Shared Load Cluster

Hot Topic

KB913580 related problem
Security Requirements for running SSIS
Package runs fine from BIDS, but same box running from dtexec gives "insufficient product level" error
Unexpected Exceptions in SQL/COM+ Since Converting to VS 2005
Need "commercial grade" FileWatcher task
Dynamic Members Security
New features/bug fixes in Sept CTP?
Transactions mode
Solution: NullProcessing on Dimension keys
Help : Dynamic table generation

SQL Server

Export To PDF
2 Data Sources for 1 Dimension
Getting Started
Do I want the Developer version?
Service Broker Activation
Cannot create a connection to data source !!!! SSRS 2005
Share calculated members between cubes
Change Column Order
Default Mobile Database Application
how to copy a table from one database to another

SQL 2005 - Shared Load Cluster

Hi

This is more a product featuer question which I cant seem to find the answer to

If we wanted to share the loads of SQL Server requests over say 2 or 4 servers, is this possible

What I mean is basically Active/Active load balancing / clustering So we have one Virtual IP and all requests are forwarded to the least busy server.....

J

Answer this question

SQL 2005 - Shared Load Cluster

Mars.Wind
Yes this is possible in SQL Server 2005, you need to install Std Edition to get 2 node clustering, Enterprise Edition will allow you to run up to 8 nodes.
SQL 2005 - Shared Load Cluster

Answer this question