This SQL Server has been optimized for 8 concurrent queries. this.limit has been exceeded by 1 queries and performance may be adversely affected.
이건 무슨 오류인가요?
어떻게 처리를 해야 되나요.
어플리케이션 쪽에 time out 오류가 있는것도 연관이 있는것 같아요.
Comment 6
-
catchv
2013.07.11 19:13
-
하람v
2013.07.11 19:54
personal Edition 은 아닌거 같은데요.. 혹시 이거 관련된 자료가 있나요?
-
김동우(탱소연)
2013.07.12 09:05
버젼 멀 쓰고 계시는 지 알려주셔야 하지않을까요.....;;;
SELECT @@version
잠깐 찾아본거에는 MSDE 버젼 써서 그런다고 나오기만 하네요
-
하람v
2013.07.12 09:17
죄송합니다. ㅜㅜ;; 급한나머지..
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 2)
desktop Engine네요 ㅜㅜ;;
동시 8 접속(?) 밖에 안되는것인가요? 아니면 동시 8 쿼리 밖에 안되는것인가요?
-
김동우(탱소연)
2013.07.12 10:12
동시 접속보다는 동시 작업제한인거같습니다
-
블랙조
2013.07.12 10:39
찾아보니 위분들 말씀처럼 제품을 standard or workgroup or enterprise edition 으로 업그레이드를 하셔야 할것 같습니다.
Desktop and MSDE 제품군의 경우 8 concurrently executing queryies 부터 심각한 성능 하락이 나타날 수 있다고 되어 있는듯 하네요.
동시 접속 8개 커넥션이면 동시적(concurrently)으로 수행할 수 있는 쿼리수가 8개일듯 한데요...
정확한것 그 제품에서 테스트를 해봐야 할듯 합니다.
특정 웹사이트에서 발췌한 내용입니다.
- MSDE has a series of disadvantages compared to SQL, which are particularly significant in corporate environments.
It supports multiple connections, but from 5 connections onwards, the computer´s performance may degrade or slow down, due to the monitoring process performed on the system by the workload governor.
- Maximum size of the database: 2 GB
- Maximum RAM supported: 2 GB RAM
- Does not support machines with more than two processors.
If the database in MSDE has more than 5 concurrent batches of queries, an log file is generated in the database log. This log is located in:
C:\Program files\Microsoft SQL Server\MSSQL$PADMINISTRATOR\LOG
And will contain lines like the following:
2004-01-23 09:45:23.96 spid11 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 2 queries and performance may be adversely affected.
2004-01-23 10:09:16.11 spid10 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
2004-01-23 10:10:16.27 spid5 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
When this happens, the query is not lost, but it is queued, and therefore, the functionality of the application is not reduced. However, bear in mind that this will greatly reduce the performance of the computer on which the database is installed.Companies that do not have an SQL Server need to decide whether to perform an installation based on MSDE or to install an SQL server to house the database. The following factors must be considered when taking this decision:
참고로 밑에 파란글씨보면
이러한 경우가 발생시, 쿼리는 손실??(lost)되지 않고, 큐잉이 된다고 하네요. 머 결국 성능 하락으로 이어지는듯 하네요
Personal Edition 제한이라고 하네요.
해결 방법은 업그레이드 하셔야 합니다.