RE: SQL Connection Problems
From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 08/05/04
- Next message: Lance: "Return records through a linked server that uses ODBC data source"
- Previous message: Steven Cheng[MSFT]: "RE: SQL Connection Problems"
- In reply to: Warren Patterson: "SQL Connection Problems"
- Next in thread: Warren Patterson: "Re: SQL Connection Problems"
- Reply: Warren Patterson: "Re: SQL Connection Problems"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 05 Aug 2004 03:20:42 GMT
Hi Warren,
Based on your descriptions, I understood that you encounter that error
randomly when there are 10-15 users that the same time. Have I understood
you? If there is anything I misunderstood, please feel free to let me know:)
This issue may be ASP.NET relatively so that I will co-working with some
specialists in ASP.NET. The following is my views on MSSQL side.
I am not sure whether those 10-15 users will interact with MSDE instance at
the same time. Performance throttling will occur when there are more than
five concurrent workload batches in progress. (MSDE 2000a allow 32,767
connections to an instance of the database engine, but only 5 concurrent
ones.)
The SQL Server 2000 Workload Governor
http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq
asp
What are the limitations of MSDE?
http://www.aspfaq.com/show.asp?id=2343
(Thanks MVP Aaron for his great site :-)
In all, I am worried about too many concurrents may lead into this randomly
error.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
- Next message: Lance: "Return records through a linked server that uses ODBC data source"
- Previous message: Steven Cheng[MSFT]: "RE: SQL Connection Problems"
- In reply to: Warren Patterson: "SQL Connection Problems"
- Next in thread: Warren Patterson: "Re: SQL Connection Problems"
- Reply: Warren Patterson: "Re: SQL Connection Problems"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
