Memory sql 2000 win 2003 problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Memory sql 2000 win 2003 problem

Memory sql 2000 win 2003 problem

Rate Topic

Display Mode

Topic Options

Author

Message

timscronin

Posted Monday, January 28, 2008 2:10 PM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, May 10, 2013 7:54 AM
Points: 472, Visits: 686

I have a new windows 2003 R2 box with 48 gig of memory. I am running the 32 bit version of sql 2000(I need the dts for now) and Windows 2003. I have my boot.ini set to below

[boot loader]
timeout=0
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /pae /NoExecute=OptOut

I have AWE enabled. However when I goto EM and try to change memory it won't let me move the bar. Went to QA and it won't open I get message below

Server: Msg 8651, Level 17, State 1, Procedure sp_configure, Line 42
Could not perform the requested operation because the minimum query memory is not available. Decrease the configured value for the 'min memory per query' server configuration option.
Anyone seen this before?

Post #448584

SQL ORACLE

Posted Monday, January 28, 2008 3:02 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314

What is your SQL Server service pack version?

Post #448605

timscronin

Posted Tuesday, January 29, 2008 6:44 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, May 10, 2013 7:54 AM
Points: 472, Visits: 686

Post #448817

SQL ORACLE

Posted Tuesday, January 29, 2008 12:47 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314

SQL 2000 SP4 has a bug resticting memory to be used with 4 GB. Did you apply hot fix? You may also need to enable AWE.

Post #449056

timscronin

Posted Tuesday, January 29, 2008 12:53 PM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, May 10, 2013 7:54 AM
Points: 472, Visits: 686

The issue was too much memory, I removed the memory back to 32 gig and it worked. MS was suprised when this did work after 2 hours on the phone with them

Post #449060

James Horsley

Posted Wednesday, January 30, 2008 4:30 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 7:51 AM
Points: 142, Visits: 394

So who said you can never have too much memory!

James Horsley
Workflow Consulting Limited

Post #449745

EdVassie

Posted Thursday, January 31, 2008 3:50 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 2,621, Visits: 2,759

You do not have to stay on SQL 2000 just because you need DTS.

If you install SQL 2005 and download and install the DTS Designer component you have a fully functioning DTS environment in SQL 2005. DTS Designer is also supported in SQL 2008, so you can upgrade and keep your DTS.

If you install 64-bit SQL 2005, your DTS runs in WoW mode so it could be a bit slower than running natively on a 32-bit OS. On the other hand, 64-bit SQL 2005 on a box your size should significantly out-perform a 32-bit version, more than making up for any performance lag in DTS.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #449853

timscronin

Posted Thursday, January 31, 2008 8:14 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, May 10, 2013 7:54 AM
Points: 472, Visits: 686

Can't upgrade yet, it is a 3rd party app

Post #449969

« Prev Topic | Next Topic »

Permissions