loosing connections - closed by server

Hello,
We experience problem with SP2. We have large application based on .NET
combining several MS products and technologies where SQL Server 2005 is used
as a database. We use BizTalk 2006 servers, IIS6 for web applications and
others. All operate on the same SQL Server running in clustered environment.
SQL Server machines run Windows Server 2003 R2 Enterprise x64 Edition SP1,
SQL Server 2005 x64 Standard Edition SP1. Application server machines run
Windows Server 2003 Enterprise (32bit) SP2.
We have installed SP2 for Windows and SP2 for SQL together on staging
cluster and after some time of successful run we have installed it into
production environment too. However in production we unpredictably received
error below raising out of requests from BizTalk components, web applications
and also clients accessing database directly.
A transport-level error has occurred when sending the request to the server.
(provider: TCP Provider, error: 0 - An existing connection was forcibly
closed by the remote host.)
The error was raised in different times from different applications.
Production environment is used by more clients but all together there just
tens of clients. The most critical errors were from BizTalk as it failed to
connect to both BizTalk and applications databases. As the behavior was
business critical we decided to uninstall both SP2 (SQL and Windows) from
production machines. Then the error disappeared but this solution is rather
temporary fix. We havenâ't found much of relevant information and are not able
to even say if the problem is caused by SP2 for system, SP2 for SQL or
combination of both. Anyway we would need SP2 to solve at least another
performance issues with WMI.
Did anyone face the same issue? Any idea for solution?
Thanks
eXavierIt happens to me when I close the connection (via programmatically or from
SSMS' s Query Editor)
--
Ekrem Ã?nsoy
"eXavier" <eXavier@.nospam.nospam> wrote in message
news:91FB542D-9E3E-4D8A-93A2-B756656C9E99@.microsoft.com...
> Hello,
> We experience problem with SP2. We have large application based on .NET
> combining several MS products and technologies where SQL Server 2005 is
> used
> as a database. We use BizTalk 2006 servers, IIS6 for web applications and
> others. All operate on the same SQL Server running in clustered
> environment.
> SQL Server machines run Windows Server 2003 R2 Enterprise x64 Edition SP1,
> SQL Server 2005 x64 Standard Edition SP1. Application server machines run
> Windows Server 2003 Enterprise (32bit) SP2.
> We have installed SP2 for Windows and SP2 for SQL together on staging
> cluster and after some time of successful run we have installed it into
> production environment too. However in production we unpredictably
> received
> error below raising out of requests from BizTalk components, web
> applications
> and also clients accessing database directly.
> A transport-level error has occurred when sending the request to the
> server.
> (provider: TCP Provider, error: 0 - An existing connection was forcibly
> closed by the remote host.)
> The error was raised in different times from different applications.
> Production environment is used by more clients but all together there just
> tens of clients. The most critical errors were from BizTalk as it failed
> to
> connect to both BizTalk and applications databases. As the behavior was
> business critical we decided to uninstall both SP2 (SQL and Windows) from
> production machines. Then the error disappeared but this solution is
> rather
> temporary fix. We havenâ't found much of relevant information and are not
> able
> to even say if the problem is caused by SP2 for system, SP2 for SQL or
> combination of both. Anyway we would need SP2 to solve at least another
> performance issues with WMI.
> Did anyone face the same issue? Any idea for solution?
> Thanks
> eXavier|||Hello,
Based on the symptom, it seems to be related to a known issue if you have
network adapter uses the Broadcom 5708 chipset. This problem occurs because
the TCP/IP offload functionality is enabled on the server. The TCP/IP
offload functionality is enabled by the Windows Server 2003 Scalable
Networking Pack.
To resolve this problem, ask the hardware vendor to determine whether they
have the hardware vendor has the following updates to resolve this problem.
- The latest BIOS update for the server.
- The latest firmware update for the network adapter.
- The latest driver update for the network adapter.
To work around this problem, you may try to disable the TCP Chimney Offload
feature.
To disable the TCP Chimney Offload feature, please follow these steps:
1. Click Start, click Run, type cmd , and then press ENTER .
2. At the command prompt, type the following command, and then press ENTER
Netsh int ip set chimney DISABLED
Note You do not have to restart the server after you run this command.
If the performance of Windows Server 2003 decreases after you disable the
TCP Chimney Offload feature, follow these additional steps:
1. Click Start, click Run, type Regedit , and then click OK.
2. Locate the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
3. Double-click the EnableTCPChimney registry entry.
4. In the Edit DWORD Value dialog box, type 0 in the Value data box, and
then click OK.
5. Double-click the ParametersEnableRSS registry entry.
6. In the Edit DWORD Value dialog box, type 0 in the Value data box, and
then click OK.
7. Double-click the EnableTCPA registry entry.
8. In the Edit DWORD Value dialog box, type 0 in the Value data box, and
then click OK.
9. Restart the server.
If you have any updates or comments, please feel free to let's know. Thank
you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Peter,
Thanks a lot for your support. Turning off the TCP Chiemney really helped to
solve the problem. Now we have Windows SP2 installed and application runs
well. Thanks!
We also tried to apply the latest bios, firmware and drivers for Broadcom
5708S NICs that are integrated into our blade servers but the offloading bug
is not yet fixed so the only solution at a time is to disable this feature.
Best regards
eXavier
""Peter YangMSFT]"" wrote:
> Hello,
> Based on the symptom, it seems to be related to a known issue if you have
> network adapter uses the Broadcom 5708 chipset. This problem occurs because
> the TCP/IP offload functionality is enabled on the server. The TCP/IP
> offload functionality is enabled by the Windows Server 2003 Scalable
> Networking Pack.
> To resolve this problem, ask the hardware vendor to determine whether they
> have the hardware vendor has the following updates to resolve this problem.
> - The latest BIOS update for the server.
> - The latest firmware update for the network adapter.
> - The latest driver update for the network adapter.
> To work around this problem, you may try to disable the TCP Chimney Offload
> feature.
> To disable the TCP Chimney Offload feature, please follow these steps:
> 1. Click Start, click Run, type cmd , and then press ENTER .
> 2. At the command prompt, type the following command, and then press ENTER
> .
> Netsh int ip set chimney DISABLED
> Note You do not have to restart the server after you run this command.
> If the performance of Windows Server 2003 decreases after you disable the
> TCP Chimney Offload feature, follow these additional steps:
> 1. Click Start, click Run, type Regedit , and then click OK.
> 2. Locate the following registry subkey:
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
> 3. Double-click the EnableTCPChimney registry entry.
> 4. In the Edit DWORD Value dialog box, type 0 in the Value data box, and
> then click OK.
> 5. Double-click the ParametersEnableRSS registry entry.
> 6. In the Edit DWORD Value dialog box, type 0 in the Value data box, and
> then click OK.
> 7. Double-click the EnableTCPA registry entry.
> 8. In the Edit DWORD Value dialog box, type 0 in the Value data box, and
> then click OK.
> 9. Restart the server.
> If you have any updates or comments, please feel free to let's know. Thank
> you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

Looking for RDBM reviews and ratings

I am looking for reviews and rating of the top RDBM products. I would like
to know how SQL compares to other products.
Rich
Rich,
in terms of performance and cost, the Transaction Processing Performance
Council maintain a set of independant comparisons you may find useful:
http://www.tpc.org/.
Regards,
Paul Ibison
|||This is always a tough question... I would google it... and I would also
check the web sites of each of the vendors, each vendors site will usually
have a comparison and show the weak points of the competitor..
The TPC web site will show some comparative performance information, but
don't choose based on a single test... Each vendor ups the other, and the
top spots change from one vendor to the next, like a ping pong game... Look
for trends - ie for small data warehouses does one vendor seem to lead
everywhere... What about for extremely large warehouses, etc... you can
also sometimes get a feel for what hardware works well for a particular DBMS
from the TPC numbers as well..
Then do your own testing... compare the prices, support policies, ease of
use and maintenance, availability of skilled people to program using the db,
etc and pick what you feel is best...
Now days, almost all of the products are so good you can be successfull with
any of them, so just pick the best fit..
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Richard Lawson" <nospam@.nospam.com> wrote in message
news:ejvkYpMJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> I am looking for reviews and rating of the top RDBM products. I would like
> to know how SQL compares to other products.
> Rich
>
|||Hi Richard.
I like going to the various vendors sites for comparisons as they all love
to tell you what their product does that the others don't (:
Other than TPC, you might also consider visiting a few ERP vendors such as
sap, peoplesoft, jde etc as they sometimes have comparative benchmarks. ERPs
owned by software vendors such as Oracle 11i, Greatplains etc are obvious
exceptions..
Regards,
Greg Linwood
SQL Server MVP
"Richard Lawson" <nospam@.nospam.com> wrote in message
news:ejvkYpMJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> I am looking for reviews and rating of the top RDBM products. I would like
> to know how SQL compares to other products.
> Rich
>
|||The problem that I have is dealing with properity vendors for the front end
bussiness software which have their own database solutions like 'Progress'
and others but I can find very little DB information for their products.
Corporate management is going to make product decision but my concern is for
some open architecture in the DB services.
Rich
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:%23ZcjZjaJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> Hi Richard.
> I like going to the various vendors sites for comparisons as they all love
> to tell you what their product does that the others don't (:
> Other than TPC, you might also consider visiting a few ERP vendors such as
> sap, peoplesoft, jde etc as they sometimes have comparative benchmarks.
ERPs[vbcol=seagreen]
> owned by software vendors such as Oracle 11i, Greatplains etc are obvious
> exceptions..
> Regards,
> Greg Linwood
> SQL Server MVP
> "Richard Lawson" <nospam@.nospam.com> wrote in message
> news:ejvkYpMJEHA.2456@.TK2MSFTNGP12.phx.gbl...
like
>
|||Hi Richard,
I am including the following articles for your reference.
SQL Server 2000 for Oracle Database Professionals
http://www.microsoft.com/sql/evaluat...are/oracle.asp
SQL Server 2000 provides organizations with a scalable, reliable, and
affordable relational database and analysis solution. Oracle developers and
IT professionals can learn more about the benefits of using SQL Server by
reviewing these resources.
SQL Server 2000 for IBM Database Professionals
http://www.microsoft.com/sql/evaluat...bm/default.asp
SQL Server 2000 provides organizations with a scalable, reliable, and
affordable relational database and analysis solution. IBM developers and IT
professionals can learn more about the benefits of using SQL Server by
reviewing these resources.
SQL Server 2000 for Sybase Database Professionals
http://www.microsoft.com/sql/evaluat...are/sybase.asp
Discover how to reduce costs, improve performance, and improve business
agility by migrating from Sybase to SQL Server.
Companies Switching to SQL Server
http://www.microsoft.com/sql/evaluat.../switchers.asp
Companies are recognizing the rich capabilities of SQL Server, including
its ability to get them to market faster at significantly reduced
operational costs. Find out why these customers made the switch to SQL
Server.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Looking for RDBM reviews and ratings

I am looking for reviews and rating of the top RDBM products. I would like
to know how SQL compares to other products.
RichRich,
in terms of performance and cost, the Transaction Processing Performance
Council maintain a set of independant comparisons you may find useful:
http://www.tpc.org/.
Regards,
Paul Ibison|||This is always a tough question... I would google it... and I would also
check the web sites of each of the vendors, each vendors site will usually
have a comparison and show the weak points of the competitor..
The TPC web site will show some comparative performance information, but
don't choose based on a single test... Each vendor ups the other, and the
top spots change from one vendor to the next, like a ping pong game... Look
for trends - ie for small data warehouses does one vendor seem to lead
everywhere... What about for extremely large warehouses, etc... you can
also sometimes get a feel for what hardware works well for a particular DBMS
from the TPC numbers as well..
Then do your own testing... compare the prices, support policies, ease of
use and maintenance, availability of skilled people to program using the db,
etc and pick what you feel is best...
Now days, almost all of the products are so good you can be successfull with
any of them, so just pick the best fit..
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Richard Lawson" <nospam@.nospam.com> wrote in message
news:ejvkYpMJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> I am looking for reviews and rating of the top RDBM products. I would like
> to know how SQL compares to other products.
> Rich
>|||Hi Richard.
I like going to the various vendors sites for comparisons as they all love
to tell you what their product does that the others don't (:
Other than TPC, you might also consider visiting a few ERP vendors such as
sap, peoplesoft, jde etc as they sometimes have comparative benchmarks. ERPs
owned by software vendors such as Oracle 11i, Greatplains etc are obvious
exceptions..
Regards,
Greg Linwood
SQL Server MVP
"Richard Lawson" <nospam@.nospam.com> wrote in message
news:ejvkYpMJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> I am looking for reviews and rating of the top RDBM products. I would like
> to know how SQL compares to other products.
> Rich
>|||The problem that I have is dealing with properity vendors for the front end
bussiness software which have their own database solutions like 'Progress'
and others but I can find very little DB information for their products.
Corporate management is going to make product decision but my concern is for
some open architecture in the DB services.
Rich
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:%23ZcjZjaJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> Hi Richard.
> I like going to the various vendors sites for comparisons as they all love
> to tell you what their product does that the others don't (:
> Other than TPC, you might also consider visiting a few ERP vendors such as
> sap, peoplesoft, jde etc as they sometimes have comparative benchmarks.
ERPs
> owned by software vendors such as Oracle 11i, Greatplains etc are obvious
> exceptions..
> Regards,
> Greg Linwood
> SQL Server MVP
> "Richard Lawson" <nospam@.nospam.com> wrote in message
> news:ejvkYpMJEHA.2456@.TK2MSFTNGP12.phx.gbl...
like[vbcol=seagreen]
>|||Hi Richard,
I am including the following articles for your reference.
SQL Server 2000 for Oracle Database Professionals
http://www.microsoft.com/sql/evalua...pare/oracle.asp
SQL Server 2000 provides organizations with a scalable, reliable, and
affordable relational database and analysis solution. Oracle developers and
IT professionals can learn more about the benefits of using SQL Server by
reviewing these resources.
SQL Server 2000 for IBM Database Professionals
http://www.microsoft.com/sql/evalua...ibm/default.asp
SQL Server 2000 provides organizations with a scalable, reliable, and
affordable relational database and analysis solution. IBM developers and IT
professionals can learn more about the benefits of using SQL Server by
reviewing these resources.
SQL Server 2000 for Sybase Database Professionals
http://www.microsoft.com/sql/evalua...pare/sybase.asp
Discover how to reduce costs, improve performance, and improve business
agility by migrating from Sybase to SQL Server.
Companies Switching to SQL Server
http://www.microsoft.com/sql/evalua...e/switchers.asp
Companies are recognizing the rich capabilities of SQL Server, including
its ability to get them to market faster at significantly reduced
operational costs. Find out why these customers made the switch to SQL
Server.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Looking for RDBM reviews and ratings

I am looking for reviews and rating of the top RDBM products. I would like
to know how SQL compares to other products.
RichRich,
in terms of performance and cost, the Transaction Processing Performance
Council maintain a set of independant comparisons you may find useful:
http://www.tpc.org/.
Regards,
Paul Ibison|||This is always a tough question... I would google it... and I would also
check the web sites of each of the vendors, each vendors site will usually
have a comparison and show the weak points of the competitor..
The TPC web site will show some comparative performance information, but
don't choose based on a single test... Each vendor ups the other, and the
top spots change from one vendor to the next, like a ping pong game... Look
for trends - ie for small data warehouses does one vendor seem to lead
everywhere... What about for extremely large warehouses, etc... you can
also sometimes get a feel for what hardware works well for a particular DBMS
from the TPC numbers as well..
Then do your own testing... compare the prices, support policies, ease of
use and maintenance, availability of skilled people to program using the db,
etc and pick what you feel is best...
Now days, almost all of the products are so good you can be successfull with
any of them, so just pick the best fit..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Richard Lawson" <nospam@.nospam.com> wrote in message
news:ejvkYpMJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> I am looking for reviews and rating of the top RDBM products. I would like
> to know how SQL compares to other products.
> Rich
>|||Hi Richard.
I like going to the various vendors sites for comparisons as they all love
to tell you what their product does that the others don't (:
Other than TPC, you might also consider visiting a few ERP vendors such as
sap, peoplesoft, jde etc as they sometimes have comparative benchmarks. ERPs
owned by software vendors such as Oracle 11i, Greatplains etc are obvious
exceptions..
Regards,
Greg Linwood
SQL Server MVP
"Richard Lawson" <nospam@.nospam.com> wrote in message
news:ejvkYpMJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> I am looking for reviews and rating of the top RDBM products. I would like
> to know how SQL compares to other products.
> Rich
>|||The problem that I have is dealing with properity vendors for the front end
bussiness software which have their own database solutions like 'Progress'
and others but I can find very little DB information for their products.
Corporate management is going to make product decision but my concern is for
some open architecture in the DB services.
Rich
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:%23ZcjZjaJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> Hi Richard.
> I like going to the various vendors sites for comparisons as they all love
> to tell you what their product does that the others don't (:
> Other than TPC, you might also consider visiting a few ERP vendors such as
> sap, peoplesoft, jde etc as they sometimes have comparative benchmarks.
ERPs
> owned by software vendors such as Oracle 11i, Greatplains etc are obvious
> exceptions..
> Regards,
> Greg Linwood
> SQL Server MVP
> "Richard Lawson" <nospam@.nospam.com> wrote in message
> news:ejvkYpMJEHA.2456@.TK2MSFTNGP12.phx.gbl...
> > I am looking for reviews and rating of the top RDBM products. I would
like
> > to know how SQL compares to other products.
> >
> > Rich
> >
> >
>|||Hi Richard,
I am including the following articles for your reference.
SQL Server 2000 for Oracle Database Professionals
http://www.microsoft.com/sql/evaluation/compare/oracle.asp
SQL Server 2000 provides organizations with a scalable, reliable, and
affordable relational database and analysis solution. Oracle developers and
IT professionals can learn more about the benefits of using SQL Server by
reviewing these resources.
SQL Server 2000 for IBM Database Professionals
http://www.microsoft.com/sql/evaluation/compare/ibm/default.asp
SQL Server 2000 provides organizations with a scalable, reliable, and
affordable relational database and analysis solution. IBM developers and IT
professionals can learn more about the benefits of using SQL Server by
reviewing these resources.
SQL Server 2000 for Sybase Database Professionals
http://www.microsoft.com/sql/evaluation/compare/sybase.asp
Discover how to reduce costs, improve performance, and improve business
agility by migrating from Sybase to SQL Server.
Companies Switching to SQL Server
http://www.microsoft.com/sql/evaluation/compare/switchers.asp
Companies are recognizing the rich capabilities of SQL Server, including
its ability to get them to market faster at significantly reduced
operational costs. Find out why these customers made the switch to SQL
Server.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.