We are doing a feasilibility study of using SQL Server cluster for load balancing.
Our clients will be running on Linux/Apache, connecting to SQL Server using JDBC.
Some c++ client tools will connect using ODBC.
Based on my limited knowledge of SQLServer clustering technology, it seems that
it does not have load balancing cluster with more than one node. In other
words, it will not allow connections to the same database from more than one
node. Only one node can own up the database, which to means that it will do
all the work pertaining to that database.
I also understand that if our goal is to balance the load amongst various nodes,
then Federated server is a better option. Can anyone explain this. Did I understand
it correctly.
I tried to find information about this in books online, but couldn't find it.
Were else can I get the information.
TIA.
SQL Server clustering is not for load balancing. It's for high
availability. Using federated servers is for load balancing. Check out
distributed partitioned views in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"rkusenet" <rkusenet@.sympatico.ca> wrote in message
news:c49pju$2g12jc$1@.ID-75254.news.uni-berlin.de...
We are doing a feasilibility study of using SQL Server cluster for load
balancing.
Our clients will be running on Linux/Apache, connecting to SQL Server using
JDBC.
Some c++ client tools will connect using ODBC.
Based on my limited knowledge of SQLServer clustering technology, it seems
that
it does not have load balancing cluster with more than one node. In other
words, it will not allow connections to the same database from more than one
node. Only one node can own up the database, which to means that it will do
all the work pertaining to that database.
I also understand that if our goal is to balance the load amongst various
nodes,
then Federated server is a better option. Can anyone explain this. Did I
understand
it correctly.
I tried to find information about this in books online, but couldn't find
it.
Were else can I get the information.
TIA.
Showing posts with label clients. Show all posts
Showing posts with label clients. Show all posts
Wednesday, March 28, 2012
Load Balancer and Connection Pooling
Guys,
We have 2 main database servers, with our clients accessing either one DB or another via a website click. Our application, in the background, chooses randomly, which server to connect to. This approach achieves simulated load balancing.
For efficiency purposes, we also have the application manage connection pooling.
Recently, we realized that our current "simulated load balancing" is not good enough, as it blindly chooses which server to connect to, without considering the current workload of that server. We are now considering to acquire a load balancer [i.e. hardware piece] so that the load is balanced more wisely, by it. Our only concern is connection pooling. Will connection pooling still work with the new, proposed topology [i.e. applications sit to the left of the load balancer and the db servers to the right of it, with the load balancer in the middle].
If anyone has had any experience with this and could share or give advice, it would be appreciated.
Thanks a lot!Each connection will be bound to one specific server. What you can do however is having a timeout value associated with each connection, letting it live for some 30 seconds or so. In this way you can ensure that the load is balanced, while still limiting the number of connections made to the SQL Server. Please remember to include logic to reconect if you don't get an answer on an active connection :)|||Thanks for the suggestion roac!
We have 2 main database servers, with our clients accessing either one DB or another via a website click. Our application, in the background, chooses randomly, which server to connect to. This approach achieves simulated load balancing.
For efficiency purposes, we also have the application manage connection pooling.
Recently, we realized that our current "simulated load balancing" is not good enough, as it blindly chooses which server to connect to, without considering the current workload of that server. We are now considering to acquire a load balancer [i.e. hardware piece] so that the load is balanced more wisely, by it. Our only concern is connection pooling. Will connection pooling still work with the new, proposed topology [i.e. applications sit to the left of the load balancer and the db servers to the right of it, with the load balancer in the middle].
If anyone has had any experience with this and could share or give advice, it would be appreciated.
Thanks a lot!Each connection will be bound to one specific server. What you can do however is having a timeout value associated with each connection, letting it live for some 30 seconds or so. In this way you can ensure that the load is balanced, while still limiting the number of connections made to the SQL Server. Please remember to include logic to reconect if you don't get an answer on an active connection :)|||Thanks for the suggestion roac!
Wednesday, March 7, 2012
list of clients connected to a database
I remember some time ago, coincidenteally, by browsing around in system
tables, I saw a place where I could see which clients were connected to
which database, allowing me to select all client names connected to a
particular database.
But I forgot where I found this (in SQL7).
Can someone tell me?
Lisasysprocesses table in master database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
I remember some time ago, coincidenteally, by browsing around in system
tables, I saw a place where I could see which clients were connected to
which database, allowing me to select all client names connected to a
particular database.
But I forgot where I found this (in SQL7).
Can someone tell me?
Lisa|||Try EXEC sp_who or EXEC sp_who2
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
the sql server rather than the name of the client connecting to it.. this is
weird.
Lisa
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:utalOC43DHA.1428@.TK2MSFTNGP12.phx.gbl...
string, and is therefore not totally reliable. The client
program can specify whatever name it fancies.
Linchi
server name running
connecting to it.. this is
in message
How? Is it the WSID parameter?
See, I always wondered what the difference was between WSID and SERVER as
they seemed to be the same, but obviously that was because I was working on
the same machine running the server locally.
Where can I find a list of ODBC connection string parameters and their
meaning?
I just kind of figured these things out by GetConnect() from within C++.
Lisa
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:168a01c3df99$df95c270$a601280a@.phx.gbl...[QUOTE]
> Note that this can be controlled with the connection
> string, and is therefore not totally reliable. The client
> program can specify whatever name it fancies.
> Linchi
>
> server name running
> connecting to it.. this is
> in message
> around in system
> were connected to
> connected to a
tables, I saw a place where I could see which clients were connected to
which database, allowing me to select all client names connected to a
particular database.
But I forgot where I found this (in SQL7).
Can someone tell me?
Lisasysprocesses table in master database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
I remember some time ago, coincidenteally, by browsing around in system
tables, I saw a place where I could see which clients were connected to
which database, allowing me to select all client names connected to a
particular database.
But I forgot where I found this (in SQL7).
Can someone tell me?
Lisa|||Try EXEC sp_who or EXEC sp_who2
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
quote:|||Thanks, strange enough, under client name, it lists the server name running
> I remember some time ago, coincidenteally, by browsing around in system
> tables, I saw a place where I could see which clients were connected to
> which database, allowing me to select all client names connected to a
> particular database.
> But I forgot where I found this (in SQL7).
> Can someone tell me?
> Lisa
>
the sql server rather than the name of the client connecting to it.. this is
weird.
Lisa
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:utalOC43DHA.1428@.TK2MSFTNGP12.phx.gbl...
quote:|||Note that this can be controlled with the connection
> sysprocesses table in master database.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Lisa Pearlson" <no@.spam.plz> wrote in message
> news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
> I remember some time ago, coincidenteally, by browsing around in system
> tables, I saw a place where I could see which clients were connected to
> which database, allowing me to select all client names connected to a
> particular database.
> But I forgot where I found this (in SQL7).
> Can someone tell me?
> Lisa
>
>
string, and is therefore not totally reliable. The client
program can specify whatever name it fancies.
Linchi
quote:
>--Original Message--
>Thanks, strange enough, under client name, it lists the
server name running
quote:
>the sql server rather than the name of the client
connecting to it.. this is
quote:
>weird.
>Lisa
>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote
in message
quote:|||HOST_NAME() depens on the ODBC connection string?
>news:utalOC43DHA.1428@.TK2MSFTNGP12.phx.gbl...
around in system[QUOTE]
were connected to[QUOTE]
connected to a[QUOTE]
>
>.
>
How? Is it the WSID parameter?
See, I always wondered what the difference was between WSID and SERVER as
they seemed to be the same, but obviously that was because I was working on
the same machine running the server locally.
Where can I find a list of ODBC connection string parameters and their
meaning?
I just kind of figured these things out by GetConnect() from within C++.
Lisa
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:168a01c3df99$df95c270$a601280a@.phx.gbl...[QUOTE]
> Note that this can be controlled with the connection
> string, and is therefore not totally reliable. The client
> program can specify whatever name it fancies.
> Linchi
>
> server name running
> connecting to it.. this is
> in message
> around in system
> were connected to
> connected to a
list of clients connected to a database
I remember some time ago, coincidenteally, by browsing around in system
tables, I saw a place where I could see which clients were connected to
which database, allowing me to select all client names connected to a
particular database.
But I forgot where I found this (in SQL7).
Can someone tell me?
Lisasysprocesses table in master database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
I remember some time ago, coincidenteally, by browsing around in system
tables, I saw a place where I could see which clients were connected to
which database, allowing me to select all client names connected to a
particular database.
But I forgot where I found this (in SQL7).
Can someone tell me?
Lisa|||Try EXEC sp_who or EXEC sp_who2
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
> I remember some time ago, coincidenteally, by browsing around in system
> tables, I saw a place where I could see which clients were connected to
> which database, allowing me to select all client names connected to a
> particular database.
> But I forgot where I found this (in SQL7).
> Can someone tell me?
> Lisa
>|||Thanks, strange enough, under client name, it lists the server name running
the sql server rather than the name of the client connecting to it.. this is
weird.
Lisa
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:utalOC43DHA.1428@.TK2MSFTNGP12.phx.gbl...
> sysprocesses table in master database.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Lisa Pearlson" <no@.spam.plz> wrote in message
> news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
> I remember some time ago, coincidenteally, by browsing around in system
> tables, I saw a place where I could see which clients were connected to
> which database, allowing me to select all client names connected to a
> particular database.
> But I forgot where I found this (in SQL7).
> Can someone tell me?
> Lisa
>
>|||Note that this can be controlled with the connection
string, and is therefore not totally reliable. The client
program can specify whatever name it fancies.
Linchi
>--Original Message--
>Thanks, strange enough, under client name, it lists the
server name running
>the sql server rather than the name of the client
connecting to it.. this is
>weird.
>Lisa
>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote
in message
>news:utalOC43DHA.1428@.TK2MSFTNGP12.phx.gbl...
>> sysprocesses table in master database.
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> http://vyaskn.tripod.com/
>> Is .NET important for a database professional?
>> http://vyaskn.tripod.com/poll.htm
>>
>>
>> "Lisa Pearlson" <no@.spam.plz> wrote in message
>> news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
>> I remember some time ago, coincidenteally, by browsing
around in system
>> tables, I saw a place where I could see which clients
were connected to
>> which database, allowing me to select all client names
connected to a
>> particular database.
>> But I forgot where I found this (in SQL7).
>> Can someone tell me?
>> Lisa
>>
>>
>
>.
>|||HOST_NAME() depens on the ODBC connection string?
How? Is it the WSID parameter?
See, I always wondered what the difference was between WSID and SERVER as
they seemed to be the same, but obviously that was because I was working on
the same machine running the server locally.
Where can I find a list of ODBC connection string parameters and their
meaning?
I just kind of figured these things out by GetConnect() from within C++.
Lisa
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:168a01c3df99$df95c270$a601280a@.phx.gbl...
> Note that this can be controlled with the connection
> string, and is therefore not totally reliable. The client
> program can specify whatever name it fancies.
> Linchi
> >--Original Message--
> >Thanks, strange enough, under client name, it lists the
> server name running
> >the sql server rather than the name of the client
> connecting to it.. this is
> >weird.
> >
> >Lisa
> >
> >"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote
> in message
> >news:utalOC43DHA.1428@.TK2MSFTNGP12.phx.gbl...
> >> sysprocesses table in master database.
> >> --
> >> HTH,
> >> Vyas, MVP (SQL Server)
> >> http://vyaskn.tripod.com/
> >> Is .NET important for a database professional?
> >> http://vyaskn.tripod.com/poll.htm
> >>
> >>
> >>
> >>
> >> "Lisa Pearlson" <no@.spam.plz> wrote in message
> >> news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
> >> I remember some time ago, coincidenteally, by browsing
> around in system
> >> tables, I saw a place where I could see which clients
> were connected to
> >> which database, allowing me to select all client names
> connected to a
> >> particular database.
> >>
> >> But I forgot where I found this (in SQL7).
> >> Can someone tell me?
> >>
> >> Lisa
> >>
> >>
> >>
> >>
> >
> >
> >.
> >
tables, I saw a place where I could see which clients were connected to
which database, allowing me to select all client names connected to a
particular database.
But I forgot where I found this (in SQL7).
Can someone tell me?
Lisasysprocesses table in master database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
I remember some time ago, coincidenteally, by browsing around in system
tables, I saw a place where I could see which clients were connected to
which database, allowing me to select all client names connected to a
particular database.
But I forgot where I found this (in SQL7).
Can someone tell me?
Lisa|||Try EXEC sp_who or EXEC sp_who2
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
> I remember some time ago, coincidenteally, by browsing around in system
> tables, I saw a place where I could see which clients were connected to
> which database, allowing me to select all client names connected to a
> particular database.
> But I forgot where I found this (in SQL7).
> Can someone tell me?
> Lisa
>|||Thanks, strange enough, under client name, it lists the server name running
the sql server rather than the name of the client connecting to it.. this is
weird.
Lisa
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:utalOC43DHA.1428@.TK2MSFTNGP12.phx.gbl...
> sysprocesses table in master database.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Lisa Pearlson" <no@.spam.plz> wrote in message
> news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
> I remember some time ago, coincidenteally, by browsing around in system
> tables, I saw a place where I could see which clients were connected to
> which database, allowing me to select all client names connected to a
> particular database.
> But I forgot where I found this (in SQL7).
> Can someone tell me?
> Lisa
>
>|||Note that this can be controlled with the connection
string, and is therefore not totally reliable. The client
program can specify whatever name it fancies.
Linchi
>--Original Message--
>Thanks, strange enough, under client name, it lists the
server name running
>the sql server rather than the name of the client
connecting to it.. this is
>weird.
>Lisa
>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote
in message
>news:utalOC43DHA.1428@.TK2MSFTNGP12.phx.gbl...
>> sysprocesses table in master database.
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> http://vyaskn.tripod.com/
>> Is .NET important for a database professional?
>> http://vyaskn.tripod.com/poll.htm
>>
>>
>> "Lisa Pearlson" <no@.spam.plz> wrote in message
>> news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
>> I remember some time ago, coincidenteally, by browsing
around in system
>> tables, I saw a place where I could see which clients
were connected to
>> which database, allowing me to select all client names
connected to a
>> particular database.
>> But I forgot where I found this (in SQL7).
>> Can someone tell me?
>> Lisa
>>
>>
>
>.
>|||HOST_NAME() depens on the ODBC connection string?
How? Is it the WSID parameter?
See, I always wondered what the difference was between WSID and SERVER as
they seemed to be the same, but obviously that was because I was working on
the same machine running the server locally.
Where can I find a list of ODBC connection string parameters and their
meaning?
I just kind of figured these things out by GetConnect() from within C++.
Lisa
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:168a01c3df99$df95c270$a601280a@.phx.gbl...
> Note that this can be controlled with the connection
> string, and is therefore not totally reliable. The client
> program can specify whatever name it fancies.
> Linchi
> >--Original Message--
> >Thanks, strange enough, under client name, it lists the
> server name running
> >the sql server rather than the name of the client
> connecting to it.. this is
> >weird.
> >
> >Lisa
> >
> >"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote
> in message
> >news:utalOC43DHA.1428@.TK2MSFTNGP12.phx.gbl...
> >> sysprocesses table in master database.
> >> --
> >> HTH,
> >> Vyas, MVP (SQL Server)
> >> http://vyaskn.tripod.com/
> >> Is .NET important for a database professional?
> >> http://vyaskn.tripod.com/poll.htm
> >>
> >>
> >>
> >>
> >> "Lisa Pearlson" <no@.spam.plz> wrote in message
> >> news:O9fZxt33DHA.2000@.TK2MSFTNGP11.phx.gbl...
> >> I remember some time ago, coincidenteally, by browsing
> around in system
> >> tables, I saw a place where I could see which clients
> were connected to
> >> which database, allowing me to select all client names
> connected to a
> >> particular database.
> >>
> >> But I forgot where I found this (in SQL7).
> >> Can someone tell me?
> >>
> >> Lisa
> >>
> >>
> >>
> >>
> >
> >
> >.
> >
Subscribe to:
Posts (Atom)