Could my prblem be related to this?
http://support.microsoft.com/default...b;en-us;328476
We have one SQL-server and 2 separate iis server as cluster. I run netstat
and found out that both IIS machines have nearly 2000 TIME-WAIT tcp session
open to our SQLserver. What shoud I do to prevent these erros happening?
T
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestiss:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl. ..
> The error is pretty clear. It could not find the server. Did you connect
> to SQL Server on this (new one) web page?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:441564a0$0$7479$39db0f71@.news.song.fi...
>
Hi
The article says that you are not using pooling, the solution may be to turn
it on!
You may want to check MDAC and SQL Server versions to see if there are any
upgrades/patches that may help.
You should also check to see if you have any network issues such as a faulty
card/router or switch.
John
"TLehtinen" wrote:
> Could my prblem be related to this?
> http://support.microsoft.com/default...b;en-us;328476
> We have one SQL-server and 2 separate iis server as cluster. I run netstat
> and found out that both IIS machines have nearly 2000 TIME-WAIT tcp session
> open to our SQLserver. What shoud I do to prevent these erros happening?
>
> T
> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
> viestiss?:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl ...
>
>
>
|||Hello!
I just recieved erros and noticed that at the same time netstat reported
4000 connections to our sql-server. So it had it's limit. Now everyting
seems to go ok, becouse we raised upper limit to 20 000 connections. We all
so chekced our application to close connections more rapidly.
All tought, at the same time our other cluster server reported only 2000
connections and cluster has equal load balancing... How many connections
you have on on your client computers(IIS)? 4000 seems not to be so much...
We do have web hits somewhere in 3 000 000 per day and many of our sites are
dymamic ones... but, should there be so much open connctions?
t
"John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
viestiss:23572079-E9D7-4E22-A61C-ED6434F2E5B2@.microsoft.com...[vbcol=seagreen]
> Hi
> The article says that you are not using pooling, the solution may be to
> turn
> it on!
> You may want to check MDAC and SQL Server versions to see if there are any
> upgrades/patches that may help.
> You should also check to see if you have any network issues such as a
> faulty
> card/router or switch.
> John
> "TLehtinen" wrote:
|||Hi
You can use perfmon to monitor connections on your database, if you track
the counter you may see some trend. If you are using connection pooling then
you would need fewer connections and the time taken to connect would not
usually be an issue therefore 4000 connections could service a significantly
larger number of users. Each connection will use a small amount of memory on
the server so reducing the number of connections by using pooling is
benificial in many ways.
If connections are being left open then you would need to check your
application and IIS settings, matching up the connections from perfmon to you
web logs may help to identify what is happening.
John
"TLehtinen" wrote:
> Hello!
> I just recieved erros and noticed that at the same time netstat reported
> 4000 connections to our sql-server. So it had it's limit. Now everyting
> seems to go ok, becouse we raised upper limit to 20 000 connections. We all
> so chekced our application to close connections more rapidly.
> All tought, at the same time our other cluster server reported only 2000
> connections and cluster has equal load balancing... How many connections
> you have on on your client computers(IIS)? 4000 seems not to be so much...
> We do have web hits somewhere in 3 000 000 per day and many of our sites are
> dymamic ones... but, should there be so much open connctions?
>
> t
> "John Bell" <jbellnewsposts@.hotmail.com> kirjoitti
> viestiss?:23572079-E9D7-4E22-A61C-ED6434F2E5B2@.microsoft.com...
>
>
