let me try this and get back to you.thanksJai Jaikanth_n Starting Member 4 Posts Posted-06/04/2006: 21:44:32 I installed the latest hot fix (8.00.2187) on sp4.Still the problem persists.Either I Post #359676 Thilina-424914Thilina-424914 Posted Thursday, April 19, 2007 9:47 PM Forum Newbie Group: General Forum Members Last Login: Thursday, May 12, 2016 1:28 AM Points: 9, Visits: 100 But AWE is Correct if I'm wrong.what else would be the solution?the worst part is sql server halts execution after this error, while some operations are still pending.2.I have another box which has the Is the server really 8 CPU's or is it 4 with Hyper Threading Enabled?

You cannot edit your own topics. Rarely both succeed.Any help is appreciated.ThanksJai Jaikanth_n Starting Member 4 Posts Posted-06/06/2006: 00:38:15 Both my boxes are dedicated for running sql servers, have 2 cpus, parallel processing enabled on We've restricted the ability to create new threads on these forums. So it probably needs 2040 or later.

I think, SQL server is trying to use 6 GB ram but the bug is block memory. Join Now For immediate help use Live now! Featured Post Top 6 Sources for Identifying Threat Actor TTPs Promoted by Recorded Future Understanding your enemy is essential. sramesh New Member Hi , I have received below erro and one of the application has been terminated same time.SQL Version : 2000 Enterprise EditionService Pack: SP4Windows: Windows 2003 enterprise editionAWE

You cannot delete your own events. weblink Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We All product names are trademarks of their respective companies. Enter the product name, event source, and event ID.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? IIRC that build (Base SP4) has the AWE bug. http://ratemycode.net/ms-sql/ms-sql-server-error-927.html Who is using data, who is updating it etc.

After adding the sufficient memory, use the /3GB switch to request 3 GB of memory for SQL Server. So you have to work with /3gb to get more memory because with 32 bits sql can reach up to 4GB. Posts: 31 Thanks: 0 Thanked 0 Times in 0 Posts Hi Jaikanth!

You can set the initial size to less than the minimum recommended size .

sramesh, Sep 29, 2009 #2 Luis Martin Moderator How is memory setting in SQL?. I hope you should check it out, how much Virtual memory has been declared. You cannot delete your own posts. To monitor the memory condition, check the following object counters in the System Monitor.•Memory: Available Bytes •SQL Server: Memory Manager: Total Server Memory (KB) The Available Bytes counter indicates how many

You cannot edit your own events. PCMag Digital Group AdChoices unused Need to download code? 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 You cannot send private messages.