SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error: 17803, Severity: 20, State: 12 Insufficient memory available.


Error: 17803, Severity: 20, State: 12 Insufficient memory available.

Author
Message
Thilina-424914
Thilina-424914
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 100
Hi All,

We have a Production Server running with following configuration.

OS : Windows Server 2003 Enterprise Edition SP1 (Version 5.2.3790 Service Pack 1 Build 3790)

SQL Server : Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) SP4

CPU : 4 x Intel Pentium 4 Xeon Processors with HT

RAM : 8GB

** /PAE switch not on boot.ini file but PAE Enabled and machine/OS detect 8GB RAM
** AWE is not switched ON at the moment

On the SQL Server Error Log and Windows Event Log following two errors appear very frequently


Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Error: 17803, Severity: 20, State: 12
Insufficient memory available.

Very recently we're getting at least 40-50 such errors per day. Could anyone can shed light on this matter,
any help is greatly appreciate.

Thilina
san43
san43
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2828 Visits: 479

Check the available memory for SQL Server.

For SQL server to take more than 4GB of RAM AWE should be enabled using'

sp_configure 'show advanced options', 1RECONFIGUREGOsp_configure 'awe enabled', 1RECONFIGUREGO
For AWE to take effect you should restart the SQL Server.
Next configure the memory.
sp_configure 'min server memory', <New Value>
RECONFIGUREGOsp_configure 'max server memory', <New Value>RECONFIGUREGO
 

EdVassie
EdVassie
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52877 Visits: 3977

Your problem appears to be lack of memory for client connections. How many concurrent connections do you need to support? You may be able to fix this by changing some of your memory parameters, or you may need specialist help from MS. If MS get your system stable, it will be worth the small amount they charge for opening a problem.

For an 8 GB box you should normally have /3GB and /PAE in boot.ini. Some hardware provides built-in PAE support, but it may be best to specify the flag in boot.ini. You should also turn on AWE in SQL, and configure max memory to use about 70% to 80% of your 8 GB. You should also look at the parameters governing connection memory, and adjust these as required.

If you are getting a very high (000s) of connections, it simply may not be able to fit in a 32-bit box, as all connection memory has to live below the 4 GB line. As your hardware seems to be recent, it should support 64-bit - you may need to go to W2003 64-bit and SQL 2005 64-bit to get your system stable.



Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
Jeff Gray
Jeff Gray
SSCrazy Eights
SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)

Group: General Forum Members
Points: 9561 Visits: 389

Hello,

It looks like you are running build 2039. IIRC that build (Base SP4) has the AWE bug. So it probably needs 2040 or later.


Thilina-424914
Thilina-424914
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 100
But AWE is not enabled in my machine. Anyway I'm planning to enable it as suggested and see the way server is behaving. Is 2040 hotfix?
EdVassie
EdVassie
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52877 Visits: 3977
You can get an update to SP4 that just includes the 2040 hotfix. However you should also consider moving to the latest post SP4 hotfix rollup (build 2187). Google will find you articles describing the contents of 2040 and 2187, and you can decide what option is best for your installation. (We run 2187 and have had no issues.)

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search