Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    27

    Unanswered: SQL Server Error

    Hi
    "This SQL Server has been optimized for 8 concurrent queries."
    Does anyone know encounter this error before in SQL Server?
    May I know what are the impact of this error and counter measures can be done to prevent this??
    Thanks
    Regards,
    deb

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Which version is it?
    Personal edition and msde are governed to slow down with 4 batches.

    Try DBCC CONCURRENCYVIOLATION

  3. #3
    Join Date
    Aug 2003
    Posts
    27
    It is MS SQL Server 2000 standard edition and is installed in Win2k server.
    Does the server version has a limit also??

  4. #4
    Join Date
    Aug 2003
    Posts
    27
    Resutls are as follows
    Concurrency Violations since 2003-10-08 09:19:10.467
    1 2 3 4 5 6 7 8 9 10-100 >100
    99999 99999 99999 15214 906 228 642 49 283 2353 2353

  5. #5
    Join Date
    Aug 2003
    Posts
    27
    I think i've found the problem
    MSDE is installed.
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •