Post reply

sqlserver has been optimized for 8 concurrent queries

  • July 18, 2006 at 1:03 am

    #61673

    i found that my sqlserver has creating the evevts , event is sqlserver has been optimized for 8 concurrent queries the limit has been exceeded be 1 queries and perfomance ma y adveresely effected. any body is there who know the answer.

  • July 18, 2006 at 8:04 am

    #649793

    SQL Server Express/MSDE has a limit to the number of concurrent queries,

    it's designed so a developer can test with the same codebase, but not with the same workload as a full verison.

    in a way, it is so that you cannot use the dev edition to run a real business.; the warning is normal, and no big deal for development; but if you tried to run your application with lots of real users, but never bothered upgrading to Standard or Enterprise editions, you'd see the problem with only 8 queries at any one time.

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply