Load Balancing

Hi,
In windows 2003 server you have NLB (Network Load Balancing).
Can i use this to load balance my traffic to our sql server?
I know you also have "Microsoft Cluster Service" but that's only available
with Windows Server 2003 Enterprise Edition.
So is it possible to load balance my traffic from our webservers to our sql
servers?
And i will create a replication on the background between the 2 sql servers
so they will both serve the same data.
I hope someone has an answer for me.
Thanks in advance.
Floris
SQL Server does not support load balancing of the databases with NLB.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.itsummitseries.com/experts/fournier.htm - Cluster Summit
"Floris" <meNOSPAM@.here_my_place.nl> wrote in message
news:OyIKCVSjFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Hi,
> In windows 2003 server you have NLB (Network Load Balancing).
> Can i use this to load balance my traffic to our sql server?
> I know you also have "Microsoft Cluster Service" but that's only available
> with Windows Server 2003 Enterprise Edition.
> So is it possible to load balance my traffic from our webservers to our
> sql servers?
> And i will create a replication on the background between the 2 sql
> servers so they will both serve the same data.
> I hope someone has an answer for me.
> Thanks in advance.
> Floris
>
sql

Load Balancing

Hi,
In windows 2003 server you have NLB (Network Load Balancing).
Can i use this to load balance my traffic to our sql server?
I know you also have "Microsoft Cluster Service" but that's only available
with Windows Server 2003 Enterprise Edition.
So is it possible to load balance my traffic from our webservers to our sql
servers?
And i will create a replication on the background between the 2 sql servers
so they will both serve the same data.
I hope someone has an answer for me.
Thanks in advance.
Floris
Load balancing when you own data (like a DBMS does) and you also want to modify that data is far
from trivial.
I don't think any system does that transparently (you either use shared disk, where you till only
have one copy of data or you do shared nothing where you only have a set of data on one location).
First determine what modifications are to be performed. Easiest is of you can separate read-only
applications (reports etc). If so, you can replicate (using built-in transactional replication) from
the server where you do modifications to the read-only server.
If you cannot separate read-only applications, you can look into merge replication. However, if you
modify the same data at the same time on two nodes, one will win and the other modification will be
lost. Unacceptable in many scenarios.
I suggest you read up in Books Online about Replication (there are different types of replications)
as well as "federated servers" (also known as distributed partitioned views).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris" <meNOSPAM@.here_my_place.nl> wrote in message news:eEpmKVSjFHA.2472@.TK2MSFTNGP15.phx.gbl...
> Hi,
> In windows 2003 server you have NLB (Network Load Balancing).
> Can i use this to load balance my traffic to our sql server?
> I know you also have "Microsoft Cluster Service" but that's only available with Windows Server
> 2003 Enterprise Edition.
> So is it possible to load balance my traffic from our webservers to our sql servers?
> And i will create a replication on the background between the 2 sql servers so they will both
> serve the same data.
> I hope someone has an answer for me.
> Thanks in advance.
> Floris
>
|||Thanks!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uMficaSjFHA.2180@.TK2MSFTNGP15.phx.gbl...
> Load balancing when you own data (like a DBMS does) and you also want to
> modify that data is far from trivial.
> I don't think any system does that transparently (you either use shared
> disk, where you till only have one copy of data or you do shared nothing
> where you only have a set of data on one location).
> First determine what modifications are to be performed. Easiest is of you
> can separate read-only applications (reports etc). If so, you can
> replicate (using built-in transactional replication) from the server where
> you do modifications to the read-only server.
> If you cannot separate read-only applications, you can look into merge
> replication. However, if you modify the same data at the same time on two
> nodes, one will win and the other modification will be lost. Unacceptable
> in many scenarios.
> I suggest you read up in Books Online about Replication (there are
> different types of replications) as well as "federated servers" (also
> known as distributed partitioned views).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris" <meNOSPAM@.here_my_place.nl> wrote in message
> news:eEpmKVSjFHA.2472@.TK2MSFTNGP15.phx.gbl...
>

Load Balancing

Hi,
In windows 2003 server you have NLB (Network Load Balancing).
Can i use this to load balance my traffic to our sql server?
I know you also have "Microsoft Cluster Service" but that's only available
with Windows Server 2003 Enterprise Edition.
So is it possible to load balance my traffic from our webservers to our sql
servers?
And i will create a replication on the background between the 2 sql servers
so they will both serve the same data.
I hope someone has an answer for me.
Thanks in advance.
FlorisLoad balancing when you own data (like a DBMS does) and you also want to mod
ify that data is far
from trivial.
I don't think any system does that transparently (you either use shared disk
, where you till only
have one copy of data or you do shared nothing where you only have a set of
data on one location).
First determine what modifications are to be performed. Easiest is of you ca
n separate read-only
applications (reports etc). If so, you can replicate (using built-in transac
tional replication) from
the server where you do modifications to the read-only server.
If you cannot separate read-only applications, you can look into merge repli
cation. However, if you
modify the same data at the same time on two nodes, one will win and the oth
er modification will be
lost. Unacceptable in many scenarios.
I suggest you read up in Books Online about Replication (there are different
types of replications)
as well as "federated servers" (also known as distributed partitioned views)
.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris" <meNOSPAM@.here_my_place.nl> wrote in message news:eEpmKVSjFHA.2472@.TK2MSFTNGP15.phx
.gbl...
> Hi,
> In windows 2003 server you have NLB (Network Load Balancing).
> Can i use this to load balance my traffic to our sql server?
> I know you also have "Microsoft Cluster Service" but that's only available
with Windows Server
> 2003 Enterprise Edition.
> So is it possible to load balance my traffic from our webservers to our sq
l servers?
> And i will create a replication on the background between the 2 sql server
s so they will both
> serve the same data.
> I hope someone has an answer for me.
> Thanks in advance.
> Floris
>|||Thanks!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uMficaSjFHA.2180@.TK2MSFTNGP15.phx.gbl...
> Load balancing when you own data (like a DBMS does) and you also want to
> modify that data is far from trivial.
> I don't think any system does that transparently (you either use shared
> disk, where you till only have one copy of data or you do shared nothing
> where you only have a set of data on one location).
> First determine what modifications are to be performed. Easiest is of you
> can separate read-only applications (reports etc). If so, you can
> replicate (using built-in transactional replication) from the server where
> you do modifications to the read-only server.
> If you cannot separate read-only applications, you can look into merge
> replication. However, if you modify the same data at the same time on two
> nodes, one will win and the other modification will be lost. Unacceptable
> in many scenarios.
> I suggest you read up in Books Online about Replication (there are
> different types of replications) as well as "federated servers" (also
> known as distributed partitioned views).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris" <meNOSPAM@.here_my_place.nl> wrote in message
> news:eEpmKVSjFHA.2472@.TK2MSFTNGP15.phx.gbl...
>

Load Balancing

Hi,
In windows 2003 server you have NLB (Network Load Balancing).
Can i use this to load balance my traffic to our sql server?
I know you also have "Microsoft Cluster Service" but that's only available
with Windows Server 2003 Enterprise Edition.
So is it possible to load balance my traffic from our webservers to our sql
servers?
And i will create a replication on the background between the 2 sql servers
so they will both serve the same data.
I hope someone has an answer for me.
Thanks in advance.
Floris
No, SQL Server is not Load Balance aware. Even with clustering does not
provide Load Balancing.
You could have load balance your web servers, and have individual web
servers accessing different dedicated SQL Servers.
SQL Server 2005 does provide Peer to Peer replication which will keep a
group of SQL Servers aggregated for scale out read and write performance in
sync. But it does not provide load balancing, but a piece of the
functionality required by it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Floris" <meNOSPAM@.here_my_place.nl> wrote in message
news:OG3UGVSjFHA.2904@.tk2msftngp13.phx.gbl...
> Hi,
> In windows 2003 server you have NLB (Network Load Balancing).
> Can i use this to load balance my traffic to our sql server?
> I know you also have "Microsoft Cluster Service" but that's only available
> with Windows Server 2003 Enterprise Edition.
> So is it possible to load balance my traffic from our webservers to our
sql
> servers?
> And i will create a replication on the background between the 2 sql
servers
> so they will both serve the same data.
> I hope someone has an answer for me.
> Thanks in advance.
> Floris
>

list sql server data types

hello,

im trying to make an we application, that from it i can create a database and table to the server

i created the database.

but i want to create the tables too, but the problem is how can i list the data types of the sql server in the aspx page so i can create the tables with columns of requuired types.

Kind Regards

Mahmoud ManasrahI believe you could use the collection System.Data.SQLTypes. I don't know that you could bind directly to the collection, but you could iterate through it adding it to a bindable object (like a dataset for instance). HTH|||thank you

its a cool idea, this is what i was looking for

but im trying to do the code to iterate through this collection, but still didnt reach it

can u tell me how can i write the code

Kind Regards|||How about
foreach(Object myType in System.Data.SqlTypes)
if (myType.GetType().Name.Substring(0,3) == "Sql")

I haven't tested this, just maybe a starting point.