Help

Could my prblem be related to this?
http://support.microsoft.com/default.aspx?scid=kb;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...
>> Hello!
>>
>> alias?
>>
>> Everything has worked fine before we added this quite huge new web page
>> thing... Now pages applications that have worked before are reporting
>> theese error. not all the time only about ten error / day (and we do have
>> now quite a bit of transactions).
>>
>>
>> T
>>
>>
>> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
>> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> DSN, Did you configure an alias in Client Network Utility?
>>
>>
>> "TLehtinen" <timo@.raa.to> wrote in message
>> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> Our sql server started to this...
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access denied.
>>
>> We added new, quite huge sql-based site to our iis farm and after that
>> we get some times these error messages. Pages wich report these erros
>> are fully working. Why do get these errors? In last day we have
>> recieved about ten of these erors. Eroros are coming from all kins of
>> asp. and .net pages at the same time. After error occusr everything
>> works fine again.
>>
>> Wha can we do to prevent this happening? What causes these type of
>> error messages?
>>
>>
>> Server and connection strings are configured well, this is not error of
>> miss spelled program or connectionstrings. Theese erros are caused
>> somewhere else.
>>
>>
>> t
>>
>>
>>
>>
>>
>
>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.aspx?scid=kb;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...
> >> Hello!
> >>
> >> alias?
> >>
> >> Everything has worked fine before we added this quite huge new web page
> >> thing... Now pages applications that have worked before are reporting
> >> theese error. not all the time only about ten error / day (and we do have
> >> now quite a bit of transactions).
> >>
> >>
> >> T
> >>
> >>
> >> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
> >> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
> >> Hi
> >> DSN, Did you configure an alias in Client Network Utility?
> >>
> >>
> >> "TLehtinen" <timo@.raa.to> wrote in message
> >> news:44155ecc$0$7489$39db0f71@.news.song.fi...
> >> Our sql server started to this...
> >> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> >> access denied.
> >>
> >> We added new, quite huge sql-based site to our iis farm and after that
> >> we get some times these error messages. Pages wich report these erros
> >> are fully working. Why do get these errors? In last day we have
> >> recieved about ten of these erors. Eroros are coming from all kins of
> >> asp. and .net pages at the same time. After error occusr everything
> >> works fine again.
> >>
> >> Wha can we do to prevent this happening? What causes these type of
> >> error messages?
> >>
> >>
> >> Server and connection strings are configured well, this is not error of
> >> miss spelled program or connectionstrings. Theese erros are caused
> >> somewhere else.
> >>
> >>
> >> t
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>
>|||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...
> 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.aspx?scid=kb;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...
>> >> Hello!
>> >>
>> >> alias?
>> >>
>> >> Everything has worked fine before we added this quite huge new web
>> >> page
>> >> thing... Now pages applications that have worked before are reporting
>> >> theese error. not all the time only about ten error / day (and we do
>> >> have
>> >> now quite a bit of transactions).
>> >>
>> >>
>> >> T
>> >>
>> >>
>> >> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
>> >> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>> >> Hi
>> >> DSN, Did you configure an alias in Client Network Utility?
>> >>
>> >>
>> >> "TLehtinen" <timo@.raa.to> wrote in message
>> >> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> >> Our sql server started to this...
>> >> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> >> access denied.
>> >>
>> >> We added new, quite huge sql-based site to our iis farm and after
>> >> that
>> >> we get some times these error messages. Pages wich report these
>> >> erros
>> >> are fully working. Why do get these errors? In last day we have
>> >> recieved about ten of these erors. Eroros are coming from all kins
>> >> of
>> >> asp. and .net pages at the same time. After error occusr everything
>> >> works fine again.
>> >>
>> >> Wha can we do to prevent this happening? What causes these type of
>> >> error messages?
>> >>
>> >>
>> >> Server and connection strings are configured well, this is not error
>> >> of
>> >> miss spelled program or connectionstrings. Theese erros are caused
>> >> somewhere else.
>> >>
>> >>
>> >> t
>> >>
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>>
>>|||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...
> > 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.aspx?scid=kb;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...
> >> >> Hello!
> >> >>
> >> >> alias?
> >> >>
> >> >> Everything has worked fine before we added this quite huge new web
> >> >> page
> >> >> thing... Now pages applications that have worked before are reporting
> >> >> theese error. not all the time only about ten error / day (and we do
> >> >> have
> >> >> now quite a bit of transactions).
> >> >>
> >> >>
> >> >> T
> >> >>
> >> >>
> >> >> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
> >> >> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
> >> >> Hi
> >> >> DSN, Did you configure an alias in Client Network Utility?
> >> >>
> >> >>
> >> >> "TLehtinen" <timo@.raa.to> wrote in message
> >> >> news:44155ecc$0$7489$39db0f71@.news.song.fi...
> >> >> Our sql server started to this...
> >> >> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> >> >> access denied.
> >> >>
> >> >> We added new, quite huge sql-based site to our iis farm and after
> >> >> that
> >> >> we get some times these error messages. Pages wich report these
> >> >> erros
> >> >> are fully working. Why do get these errors? In last day we have
> >> >> recieved about ten of these erors. Eroros are coming from all kins
> >> >> of
> >> >> asp. and .net pages at the same time. After error occusr everything
> >> >> works fine again.
> >> >>
> >> >> Wha can we do to prevent this happening? What causes these type of
> >> >> error messages?
> >> >>
> >> >>
> >> >> Server and connection strings are configured well, this is not error
> >> >> of
> >> >> miss spelled program or connectionstrings. Theese erros are caused
> >> >> somewhere else.
> >> >>
> >> >>
> >> >> t
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >>
> >>
> >>
>
>