This is a discussion on ODBC Error 1222 within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hello everybody! System description: OS: Windows Server 2003 Enterprise Edition SP1 RAM: 16 Gb SQL: SQL Server 2000 Enterprise ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello everybody! System description: OS: Windows Server 2003 Enterprise Edition SP1 RAM: 16 Gb SQL: SQL Server 2000 Enterprise Edition SP3 SQL Server has "awe enabled"=1 and "set working set size"=1 at the same time. "Max server memory" is limited by 12 Gb. SQLServer:MemoryManager:Total Server Memory counter shows that SQL Server consumes all of the 12 Gb memory. Allmost every day the client receives ODBC error 1222 (lock timeout) even if onle one user is connected to the database. BOL says that if "awe enabled"=1 memory is not swapped out by default. www.microsoft.com says that if you change "set working set size" from its default value it may involve 844 and 845 errors (page latch timeout). So the questions are: 1. Can two simulaneously enabled options ("awe enabled" and "set working set size") result in such conflict? 2. Can enabling set working set size result in ODBC error 1222? Thank you |
| Thread Tools | |
| Display Modes | |
|
|