November 30, 2004 at 4:22 pm
Hi - I am running MSDE on our server for the moment. I do see the "This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected." many times in my logs.
Is there anywhere that documents the delays introduced by MSDE if the 5 query limited is exceeded? Is it an exponential scale - or how else is it calculated? I'm trying to find out if users (who may be causal browsers, that I may never have contact with), are experiencing a short delay (10ths of seconds), or if the delays are long enough for them to think the site is broken.
Thanks for any help, Mark
December 3, 2004 at 12:50 am
Hi,
If you look in BOL under:
SQL Server Architecture
Relational Database Engine Architecture
Server Scalability
The SQL Server 2000 Workload Governor
You will find a fairly good explanation of when the governor kicks in and how it slows things down. I did try to respond to another question of yours but this darn site 'nuked' my reply when I went to post it.
Does your web app hit the db straight from asp of do you use com/com+?
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
December 3, 2004 at 1:12 am
Hi Ian - thank you I'll search in there.
The site is .Net - so all of the hits are directly from the compiled dll.
Kind regards, Mark
December 3, 2004 at 1:23 am
Well, if you are already using a DLL, you can change the architecture slightly to use a COM+ component to access the db. If you set the initial number of pooled objects high enough you could pretty much eliminate all the login and logout operations that the MSDE would see, assuming of course the objects are coded to keep the db connections open. If most of your accesses are of a login/do a single query/logout nature, you may see a two-thirds reduction and may not run into the governor issues.
Well, it might buy you a little more time before having to upgrade to Standard edition anyways.
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply