Post reply

optimized for 8 concurrent queries

  • December 19, 2002 at 7:32 am

    #105561

    I've a database for 30 users. On this moment we work on a dual pentium 600 (IBM). Now I'm testing the database on a new machine (IBM P1300 dual) with almost the same SQL installation. The difference is that SP2 is only installed on the new machine and not on the old one. When I start testing with some users I get the next error in the log:

    This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.

    Can some help me to solve this problem?

  • December 19, 2002 at 7:38 am

    #444802

    Have you checked the "Maximum concurrent user connections" setting SQL Server Properties, Connections?

    It should normally be set to 0 (zero) - this gives you unlimited connections.

  • December 19, 2002 at 8:15 am

    #444811

    Yes I did, maximum concurrent user connections = 0

  • December 19, 2002 at 8:22 am

    #444812

    Are you sure you are not running something like the Personal Edition of SQL Server.

    For a production environment you should be running the Enterprise or Standard Edition.

  • December 19, 2002 at 9:37 am

    #444831

    I'm sure i've the enterprise edition. I've asked the system admin if we have a version for enough users. Tomorrow I get the answer

    thanks in advance

  • December 19, 2002 at 9:38 am

    #444832

    Execute the following and it will tell you which version you have installed.

    SELECT @@version

  • December 20, 2002 at 12:02 am

    #444903

    Hello Paul,

    Thank you for your advise. I ran that query and.......personal Edition!! If you ever be in Holland, I buy you a beer!

    Manig

Viewing 7 posts - 1 through 6 (of 6 total)

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