You are here: Re: SQL Server does not exist or access denied « MsSQL Server « IT news, forums, messages
Re: SQL Server does not exist or access denied

Posted by Erland Sommarskog on 01/31/06 00:58

kwdavids (kevin@davnet.org) writes:
> For what it's worth...
>
> It turns out that I had set up two "firehose" DataSets on the same
> connection. This resulted in the 2nd connection being opened and closed
> thousands of times by ADO. In my situation, SQL Server is going out to
> lunch after about 6,000 connections.

Or rather shared memory. TCP/IP connections would probably still work
if TCP/IP is enabled, as will existing connection. This was one of the
scenarios I suggested, and I been able to produce this situation myself
when running a tight loop with connection/disconnection without pooling.
(To check for memory leaks.)



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация