SQL load balance

SQL load balance

Post by Basse » Sun, 13 Jul 2003 03:28:19


is there are a way to load balance SQL server using
windows 2000 server cluster?
i mean active/active cluster for sql 2000 over the same
instant of sql not 2 instant.

Regards,
 
 
 

SQL load balance

Post by Basse » Sun, 13 Jul 2003 03:28:21

is there are a way to load balance SQL server using
windows 2000 server cluster?
i mean active/active cluster for sql 2000 over the same
instant of sql not 2 instant.

Regards,

 
 
 

SQL load balance

Post by Ray Higdo » Sun, 13 Jul 2003 11:58:29

You can not have more than one database/instance/anything pointed at the
same MDF/LDF. Hopefully this will be addressed in the future. Any type
of load balancing would be splitting databases not a single database.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.yqcomputer.com/ ***
Don't just participate in USENET...get rewarded for it!
 
 
 

SQL load balance

Post by Hina » Tue, 15 Jul 2003 16:36:08

for more information follow White paper on SQL 2000 clustering:
http://www.yqcomputer.com/


Thank you
Hina Masud
Microsoft

Disclaimer:
This posting is provided AS IS with no warranties, and confers no rights.
Get Secure! -> http://www.yqcomputer.com/


--------------------
-Content-Class: urn:content-classes:message
-From: "Bassem" < XXXX@XXXXX.COM >
-Sender: "Bassem" < XXXX@XXXXX.COM >
-Subject: SQL load balance
-Date: Fri, 11 Jul 2003 11:28:21 -0700
-Lines: 6
-Message-ID: <008f01c347da$34f83430$ XXXX@XXXXX.COM >
-MIME-Version: 1.0
-Content-Type: text/plain;
- charset="iso-8859-1"
-Content-Transfer-Encoding: 7bit
-X-Newsreader: Microsoft CDO for Windows 2000
-X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
-Thread-Index: AcNH2jT4AmZx7da/TWi1CNTIWow04A==
-Newsgroups: microsoft.public.sqlserver.clustering
-Path: cpmsftngxa06.phx.gbl
-Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.clustering:10494
-NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
-X-Tomcat-NG: microsoft.public.sqlserver.clustering
-
-is there are a way to load balance SQL server using
-windows 2000 server cluster?
-i mean active/active cluster for sql 2000 over the same
-instant of sql not 2 instant.
-
-Regards,
-
 
 
 

SQL load balance

Post by Michael Ho » Thu, 24 Jul 2003 11:47:32

Additionally, clustering is an availability feature. It is NOT a
scalability feature. It is NOT a performance feature. It is NOT a load
balancing feature.

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.yqcomputer.com/
http://www.yqcomputer.com/