Error 17803 Severity 20 State 17
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » Insufficient memory available error 17803 severity 20 state 12 and Error:... Insufficient memory available and Error: 17803, Severity: 20, State: 12 Rate Topic sql error 17803 insufficient memory available Display Mode Topic Options Author Message Doug Walden-380201Doug Walden-380201 Posted Monday, November 20, 2006 12:11 PM Forum Newbie Group: General Forum
Error 17836 Severity 20 State 17
Members Last Login: Tuesday, October 6, 2015 8:20 AM Points: 8, Visits: 19 We have been getting these errors in our SQL Server Logs:Insufficient memory available and Error: 17803, Severity: 20, State: 12.We are Running
Error 17836 Severity 20 State 17 In Sql Server 2008
a Win 2003 box with 6gig physical memory.We have the boot.ini file set with both the /3GB and the /PAE settings.We are running SQL 2000 Ent. SP4(SQL Server 8.00.2039 - SP4 (Enterprise Edition)) with fixed memory set at 3138 and 3 of the 4 processors are set for SQL. AWE is set to ON.SQL 2000 is the only thing running on the box. There are two main databases: one is 10 gig and the other is just over 1 gig. The 10 gig database has a 30,000,000 row table in it that can not get reindexed. When the database reindex maintenance plan runs every week it fails on this table and indicates the above errors. Not sure if this is a symptom or not, but when I restart the server one of the entries that happens everytime is "Warning: unable to allocate 'min server memory' of 3138MB".I have defragged the disks (file fragmentation was 85% now 50%). All articles I ahve read indicate that SQL SP4 fixes this issue. Any help would be very much appreciated.Thanks, Doug Post #324381 John RowanJohn Rowan Posted Monday, November 20, 2006 12:19 PM SSCarpal Tunnel Group: General Forum Members Last Login: Friday, October 7, 2016 9:20 AM Points: 4,008, Visits: 4,410 I see a couple of things here. First, did you apply the AWE hot fix for SP4? If not, there is a bug with AWE in SP4 that Microsoft has created a hot fix for. Get it and apply it. Second, if you have 6GB of memory in the server, why are you limiting it to 3GB? You should up the Max Server Memory (MB) setting to 5GB. If you a
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM maxwellarnold I_am_the_dragon PCMag Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Craig Borysowich Dennis Stevenson DukeGanote Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES RSA Conference UC4 http://www.sqlservercentral.com/Forums/Topic324381-5-1.aspx Apperian Sophos View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question SQL Server The SQL Server group is a forum where peers share technical expertise, solve problems, and discuss issues related to Microsoft SQL Server. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - http://database.ittoolbox.com/groups/technical-functional/sql-server-l/error-17803-severity-20-state-12-insufficient-memory-available-what-does-it-mean-1617985 It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Error: 17803, Severity: 20, State: 12 Insufficient memory available what does it mean Unknown User asked Sep 18, 2007 | Replies (1) Hi, We are getting the message below and i am not sure what could cause it...i have been told that the sev 20 message means it is a big error but as the wh build has worked i am not sure....I think possibly that the service has not fully shut down when rebooting and so it is putting it into error state hense the roll back..thoughts? Extract from log file 2007-09-17 10:21:20.39 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation
20, State: 17 Discussion in http://www.sql-server-performance.com/forum/threads/error-17803-severity-20-state-17.8522/ 'General DBA Questions' started by contactjimmys, Oct 17, 2006. contactjimmys New Member In my sql server the below error was logged Error: 17803, Severity: 20, State: 17 Next error messgae is Insuffient memory available Pls suggest .Is is due to Ram Thanks DBA SHAMS contactjimmys, Oct severity 20 17, 2006 #2 Chappy New Member Do you know what query causes this? Run a profile trace to find out, if you dont Check service packs, it could it be related to .. http://support.microsoft.com/kb/891719 ? Also check your windows swap file, make sure the drive its on severity 20 state has plenty of space to grow if necessary Chappy, Oct 17, 2006 #2 (You must log in or sign up to reply here.) Share This Page Tweet Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums. Your name or email address: Do you already have an account? Forgot your password? No, create an account now. Yes, my password is: Stay logged in SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Posts > SQL Server 7.0 and 2000 Forum Topics > General DBA Questions > Forums Forums Quick Links Search Forums What's New? Members Members Quick Links Registered Members Current Visitors Recent Activity Help Help Quick Links Smilies BB Codes Trophies Search titles only Posted by Member: Separate names with a comma. Newer Than: Advanced search...