Load balancing SQL Server

I have 3 SQL Servers that are all subscribers and the only apps that need to
connect to it do read only queries . Id like the apps to load balance across
these 3 servers. Is there any article on how to set this up using Windows
Load balancing ?
Are there any other tools out there ?
ThanksLoad balancing is typically done on the application level, i.e. load balance
your web servers. Have a SQL Server hanging off each web server.
--
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
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ONjJGSKnFHA.320@.TK2MSFTNGP09.phx.gbl...
> I have 3 SQL Servers that are all subscribers and the only apps that need
to
> connect to it do read only queries . Id like the apps to load balance
across
> these 3 servers. Is there any article on how to set this up using Windows
> Load balancing ?
> Are there any other tools out there ?
> Thanks
>|||You can use Windows Network Load balancing or any external load balancer.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ONjJGSKnFHA.320@.TK2MSFTNGP09.phx.gbl...
>I have 3 SQL Servers that are all subscribers and the only apps that need
>to
> connect to it do read only queries . Id like the apps to load balance
> across
> these 3 servers. Is there any article on how to set this up using Windows
> Load balancing ?
> Are there any other tools out there ?
> Thanks
>|||Do you know where I can find documentation on WLB with SQL Server ?
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:eYvuUkOnFHA.1204@.TK2MSFTNGP12.phx.gbl...
> You can use Windows Network Load balancing or any external load balancer.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:ONjJGSKnFHA.320@.TK2MSFTNGP09.phx.gbl...
> >I have 3 SQL Servers that are all subscribers and the only apps that need
> >to
> > connect to it do read only queries . Id like the apps to load balance
> > across
> > these 3 servers. Is there any article on how to set this up using
Windows
> > Load balancing ?
> >
> > Are there any other tools out there ?
> >
> > Thanks
> >
> >
>|||Windows Help. Index search "Network Load Balancing". External vendors
include Cisco, F5, and probably others.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e7RCjkPnFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Do you know where I can find documentation on WLB with SQL Server ?
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:eYvuUkOnFHA.1204@.TK2MSFTNGP12.phx.gbl...
>> You can use Windows Network Load balancing or any external load balancer.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "Hassan" <fatima_ja@.hotmail.com> wrote in message
>> news:ONjJGSKnFHA.320@.TK2MSFTNGP09.phx.gbl...
>> >I have 3 SQL Servers that are all subscribers and the only apps that
>> >need
>> >to
>> > connect to it do read only queries . Id like the apps to load balance
>> > across
>> > these 3 servers. Is there any article on how to set this up using
> Windows
>> > Load balancing ?
>> >
>> > Are there any other tools out there ?
>> >
>> > Thanks
>> >
>> >
>>
>

load balancing question

I need to load balance / mirror 3 things.
1. sql server. Can i do this using sql technology ?
i.e i get my app to connect to 99.99.99.99:1344 and the server connect me
to one but then mirrors data on next sql server too ?
2. IIS6. I can use windows load balancing for this but one IIS6 machine need
to be the front end i believe. Better to use hardware infront of server i
guess ?
3. specific traffic on single IP ... i guess i need hardware to do this.
Any help much appreicated.
ScottAnswers inline.
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
"Scott" <s@.yahoo.co.uk> wrote in message
news:eLJdGQytHHA.3400@.TK2MSFTNGP03.phx.gbl...
>I need to load balance / mirror 3 things.
> 1. sql server. Can i do this using sql technology ?
> i.e i get my app to connect to 99.99.99.99:1344 and the server connect me
> to one but then mirrors data on next sql server too ?
>
Yes, with peer to peer replication or database mirroring DML occuring on one
node could be replicated/mirrored to all nodes in the replication/mirroring
topology. However with mirroring all nodes except the principal will be in a
state of recovering (in other words inaccessible), and with both replication
or mirroring, there is no client redirect. So if the app is connecting to
the SQL Server on 99.99.99.99:1344, you will have to do something
programmatically to have it connect to the other servers, and bring them
online (if you are using mirroring). So mirroring is not the best way to do
this and not the appropritate technology. Peer to peer replication can work,
but the latencies and the possibility or conflicts also do not make it an
appropriate technology.

>
> 2. IIS6. I can use windows load balancing for this but one IIS6 machine
> need to be the front end i believe. Better to use hardware infront of
> server i guess ?
With NLB one IIS server will redirect requests to other IIS servers which
form your NLB topology. Each of these IIS servers could be directed to a
different SQL Server, however this moves the problem back to how you are
going to consolidate DML to be consistent across all SQL Servers. If a
client connetct to IIS Server1, and does some work on SQL Server 1, what
happens when it reconnects to IIS 2? Is it ok that its data is not on SQL
Server 2 which hangs off IIS2? You need to work these issues out before
deploying such a topology. Of course all IIS Servers in your NLB topology
could connect to a single SQL Server which might lead to concurrency issues.
>
> 3. specific traffic on single IP ... i guess i need hardware to do this.
You need to look at hardware like Cisco's Local Director for things like
this.
>
> Any help much appreicated.
> Scott
>|||great help, thank you very much.
scott

load balancing question

I need to load balance / mirror 3 things.
1. sql server. Can i do this using sql technology ?
i.e i get my app to connect to 99.99.99.99:1344 and the server connect me
to one but then mirrors data on next sql server too ?
2. IIS6. I can use windows load balancing for this but one IIS6 machine need
to be the front end i believe. Better to use hardware infront of server i
guess ?
3. specific traffic on single IP ... i guess i need hardware to do this.
Any help much appreicated.
ScottAnswers inline.
--
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
"Scott" <s@.yahoo.co.uk> wrote in message
news:eLJdGQytHHA.3400@.TK2MSFTNGP03.phx.gbl...
>I need to load balance / mirror 3 things.
> 1. sql server. Can i do this using sql technology ?
> i.e i get my app to connect to 99.99.99.99:1344 and the server connect me
> to one but then mirrors data on next sql server too ?
>
Yes, with peer to peer replication or database mirroring DML occuring on one
node could be replicated/mirrored to all nodes in the replication/mirroring
topology. However with mirroring all nodes except the principal will be in a
state of recovering (in other words inaccessible), and with both replication
or mirroring, there is no client redirect. So if the app is connecting to
the SQL Server on 99.99.99.99:1344, you will have to do something
programmatically to have it connect to the other servers, and bring them
online (if you are using mirroring). So mirroring is not the best way to do
this and not the appropritate technology. Peer to peer replication can work,
but the latencies and the possibility or conflicts also do not make it an
appropriate technology.
>
> 2. IIS6. I can use windows load balancing for this but one IIS6 machine
> need to be the front end i believe. Better to use hardware infront of
> server i guess ?
With NLB one IIS server will redirect requests to other IIS servers which
form your NLB topology. Each of these IIS servers could be directed to a
different SQL Server, however this moves the problem back to how you are
going to consolidate DML to be consistent across all SQL Servers. If a
client connetct to IIS Server1, and does some work on SQL Server 1, what
happens when it reconnects to IIS 2? Is it ok that its data is not on SQL
Server 2 which hangs off IIS2? You need to work these issues out before
deploying such a topology. Of course all IIS Servers in your NLB topology
could connect to a single SQL Server which might lead to concurrency issues.
>
> 3. specific traffic on single IP ... i guess i need hardware to do this.
You need to look at hardware like Cisco's Local Director for things like
this.
>
> Any help much appreicated.
> Scott
>|||great help, thank you very much.
scottsql

ListBox and Table Values

Hi

got small problems with the table values. I got three rows in a table

Index (int)
Product (varchar)
Price (float)

I could successfully connect to the database. I also get the values but somehow the ListBox don't show them...

Anyone can help me please ?

CODE

{
CDBVariant value;
char sql_statement [2048] = "";

//CDatabase object "db" created to connect database
CDatabase db;
db.OpenEx(_T("DSN=Beauty"),CDatabase::noOdbcDialog);

//CRecordset object "rs" created to access and manipulate database records.
CRecordset rs(&db);
strcpy(sql_statement,_T("SELECT * FROM TestTabelle"));
rs.Open(CRecordset::forwardOnly,sql_statement);

//Get quantity from Database
int n = rs.GetODBCFieldCount( );

while(!rs.IsEOF())
{
for( int i = 0; i < n; i++ )

{
rs.GetFieldValue("index",value);
m_Buy_List.InsertItem(i,LPCTSTR(value.m_lVal));

rs.GetFieldValue("product",value.m_pstring);
m_Buy_List.SetItemText(i,2,LPCTSTR(value));

rs.GetFieldValue("price",value);
m_Buy_List.SetItemText(i,3,LPCTSTR(value.m_fltVal) );

rs.MoveNext( );
}
}This is a VC++ code problem, I presume. Probably you should try some VC++ forums, for ex: www.codeguru.com

Best regards!sql

List of server connections

Hello,

I use SQL Server Management Studio Express. When I want to connect to some server the application form offers me several servers that I used to connect to in past. Where can I manage this offer (delete some obsolete servers).

Thanks

hi,

I do think you find it in

C:\Documents and Settings\YourName\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

.. but, if it is, my advice is not to hack it..

regards

List of available servers

Hello there
When i press browse button on the connect option of the query anlyser, I get
list of all available servers on my network.
Is there a way to export this list to source like excel?Try this one here:
master..xp_cmdshell 'OSQL.exe -L'
HTH, Jens Suessmeyer.|||Roy
Dim i As Integer
'Use the SQL DMO Application Object to find the
available SQL Servers
Set oSQLServerDMOApp = New SQLDMO.Application
'Don't show events
gShowServerEvents = False
Dim namX As NameList
Set namX = oSQLServerDMOApp.ListAvailableSQLServers
For i = 1 To namX.Count
txtServer.AddItem namX.Item(i)
Next
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:uIYW03SPGHA.2668@.tk2msftngp13.phx.gbl...
> Hello there
> When i press browse button on the connect option of the query anlyser, I
> get list of all available servers on my network.
> Is there a way to export this list to source like excel?
>

List available SQL instances in a Server

Hi, iam using this script to connect to the default instance of a SQL Server
(7 or 2000)
strcomputer = wscript.arguments(0)
Set oServer=CreateObject("SQLDMO.Sqlserver")
oserver.loginsecure = true
oServer.Connect strComputer
The problem is:
When i try to connect to a server that has many instances
(MSSQLSERVER$XXXXXX) i cant connect. This scripts only works with the defaul
t
mssqlserver. The question is how can connect to a server and list the
available instances instead of hardcoding in code (Like strcomputer &
"\Instance") using vbscript or other shell tool. (The discover tool like osq
l
-L doesn't work, because it cant detect server over lot of networks)
Thanks all.Use the ListAvailableServers Method of the application object.
INF: How to Enumerate Available SQL Servers Using SQLDMO
http://support.microsoft.com/defaul...b;en-us;Q287737
AMB
"Tinchos" wrote:

> Hi, iam using this script to connect to the default instance of a SQL Serv
er
> (7 or 2000)
> strcomputer = wscript.arguments(0)
> Set oServer=CreateObject("SQLDMO.Sqlserver")
> oserver.loginsecure = true
> oServer.Connect strComputer
> The problem is:
> When i try to connect to a server that has many instances
> (MSSQLSERVER$XXXXXX) i cant connect. This scripts only works with the defa
ult
> mssqlserver. The question is how can connect to a server and list the
> available instances instead of hardcoding in code (Like strcomputer &
> "\Instance") using vbscript or other shell tool. (The discover tool like o
sql
> -L doesn't work, because it cant detect server over lot of networks)
> Thanks all.|||Thanks Alejandro. But it doesn't work neither. It's the same that use the
osql -L (only works on local network)
I need to find a method to connect to a server and list the available
instances with dmo.
Thanks !!
"Alejandro Mesa" wrote:
> Use the ListAvailableServers Method of the application object.
> INF: How to Enumerate Available SQL Servers Using SQLDMO
> http://support.microsoft.com/defaul...b;en-us;Q287737
>
> AMB
> "Tinchos" wrote:
>|||See if querying master.dbo.sysservers or executing sp_helpserver helps.
AMB
"Tinchos" wrote:
> Thanks Alejandro. But it doesn't work neither. It's the same that use the
> osql -L (only works on local network)
> I need to find a method to connect to a server and list the available
> instances with dmo.
> Thanks !!
> "Alejandro Mesa" wrote:
>|||Nop, i have a about 50 sql server over the network.
New sql servers are installed with instances, like this:
SERVER\UNLAMXEX
SERVER\UNLAMXFO
SERVER\UNLAMXPR
I need to specify the instance to connect with isql o other. I need some
scripting tool to detects automatically the instances.
Thanks.
Martin
"Alejandro Mesa" wrote:
> See if querying master.dbo.sysservers or executing sp_helpserver helps.
>
> AMB
> "Tinchos" wrote:
>