SQL Server 2000 Standard Memory Flatline

Jun 26, 2007

Hi all,



We have an SQL 2000 Standard SP4 system with 3gb of RAM running on Windows 2003 Server R2 Standard.



The SQL memory usage of this server flatlines at around 1665mb and will not go any higher.



I understand SQL 2000 Standard on Windows 2003 Server Standard has a 2gb memory limit, however why wont the memory push up to this limit? The OS shows there is around 700mb of the 3076 unused (SQL uses 1660, windows uses around 700 making the maximum used around 2300 of the 3076)



I have set the /3gb switch on windows boot, I have changed the SQL memory configurations many different times. If I try and set 'min server memory' to anything over around 1500mb I get the error on SQL startup;



Warning: unable to allocate 'min server memory' of 1720mb



In the above example surely if the Server has a 2gb limit it should let me set say 1720/2048 ? or 1920/2048 or even 2048/2048, however anything over around 1500 generates the above error.



Our server continues to flatline at 1660mb, any help to squeeze out an extra 200-400mb of RAM would be appreciated or an explination as to why it can not be done.



Thanks for your help

Jim

View 1 Replies


ADVERTISEMENT

How Do SQL 2000 Service Packs Play A Role In Upgrading?i.e.Can SQL 2000 Standard With No SP Be Upgraded To SQL 2005 Standard

Aug 2, 2006

How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??

View 1 Replies View Related

Memory Settings In SQL Server 2005 Standard Edition

Nov 9, 2007

Hi,

I'm having trouble finding the optimum memory settings for SQL Server 2005. I have 4 instances running on a macine with 8 dual-core processors and 18GB of RAM. I have tried the following memory settings so far:

No maximum - one instance used about 12GB of RAM so then the others struggled
Maximum of 4GB each (2GB left for Windows) - meant that 3 instances could be using 1GB each and then another at 4GB and needing more whilst 9GB sat unused.
Minimum of 2GB each - one instance would use up 10GB and then never give any back to the other instances.

I also find that setting a maximum then just causes a high amount of paging. What I would like to do is have each instance use a minimum amount, say 1GB, and then have each instance use a maximum of 13GB (3GB for other 3 instances running at a minimum level and 2GB for Windows). This 13GB should then be released and allocated to another instance when necessary, assuming it is no longer all being used. I do not want paging to occur if an instance reaches 13GB.

How do I go about configuring SQL Server to behave like this? Is it possible?

Thanks.


View 1 Replies View Related

Setting Memory Values For SQL 2005 Standard (32 Bit) On Windows 2003 Server 64 Bit.

Aug 3, 2007

Hi,

I am testing SQL 2005 Standard (32 bit) on a Windows 2003 Server 64 bit with 8GB of RAM? Should I enable the AWP Setting or not and should I change the maximum server memory (currently saying 2GB)?

Thanks!
Tom

View 1 Replies View Related

Sql Server 2000 Using Less Memory After More Memory Added

Aug 22, 2007

sql server 2000 is running on windows server 2003 ... 4gb of memory on server .... 2003 was allocated 2.3gb nd sql server was allocated (and using all of it) 1.6gb for total of approx 4gb based on idera monitor software ... all memory allocated betweeen the OS and sql server .... then 4 more gb of memory added for total now of 8g ... now idera monitor shows 1.7gb for OS and 1.0 gb for sql server ..... 'system' info shows 8gb memory with PAE ... so I assume that the full 8gb can now be addressed .... why are less resources being used now with more total memory .... especially sql server ..... i thought about specifying a minimum memmry for sql server but i amnot convinced that would even work since it seems that this 1gb limit is artificial .... it it used 1.6 gb before why would it not use at least that much now ??

thank you

View 4 Replies View Related

Upgrading SQL Server 2000 Standard To SQL Server 2000 Enterprise

Sep 14, 2004

I am currently running SQL Server 2000 Standard on my production system, and I am looking to upgrade the system to Windows 2000 Adv. Server. I would also like to upgrade SQL Server 2000 Standard to SQL Server 2000 Enterprise to utilize more than 2GB of memory. Can anyone tell me what is the best way to upgrade the system, and please provide some feedback on your experiences with the upgrade. Thanks in advance.

View 2 Replies View Related

SQL Server 2000 Standard On Windows 2000 Advanced Server

Jul 20, 2005

What is the limitation of memory that SQL Server 2000 Standard can usewhen running on a Windows 2000 Advanced Server platform?

View 1 Replies View Related

Upgrate Sql Server 2000 Standard To Sql Server 2000 Enterprise

Sep 15, 2006

Hi, I need to know if somebody knows like making the update of Standard SQL 2000 to Enterprise. Greetings.

View 3 Replies View Related

Is It Possible Run C# .net Standard Against SQL Server 2000?

Jan 13, 2005

Hi all!

I keep getting an error when I try and create a new data connection. This is the error I'm getting:

Unable to connect to database.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access with this version of Visual Studio.


I can connect to Access without any problems. Is there anyway around this?
I'm using C# .net Standard with SQL Server 2000.

Thanks for any help.

View 5 Replies View Related

AWE Memory On SQL 2005 Standard

Jun 8, 2007

Is AWE enabled on SQL 2005 Standard? We currently have it setup using "locked pages in memory" for a domain account and haven't noticed any performance problems.



This article however states that only the SQL2005 Enterprise Edn supports "locked pages in memory". Can anyone confirm this?

http://support.microsoft.com/kb/918483



If I'm mistaken, how should the memory options be set for a server with 8gb ram running on SQL 2005 Standard which runs on Win2003 Enterprise? Should the min and max memory be set or left alone as default?

View 5 Replies View Related

SQL Server 2000 Standard Edition

Dec 9, 2004

Can we install SQL Server 2000 Standard Edition on Win XP professional?
Thanks

View 11 Replies View Related

Help With Installation Of Standard SQL Server 2000

Dec 12, 2004

I have installed IIS, VS.NET 2003, .NET 2.0 Framework, and now I have tried to install the standard version of SQL Server 2000 and it is telling me that I can only install the client components. The O/S is Windows XP Pro on a laptop.

Thanks for any ideas,

View 1 Replies View Related

SQL Server 2000 Standard Edition

Mar 5, 2002

I am running Win2k Professional version SP2. I tried to install the SQL Server 2000 Standard Edition, I got error message said " MS Sql Server 2000 Standard Edition server component is not supported on this operating system. Only client components will be available for installation."

View 1 Replies View Related

Installation Of SQL Server 2000 Standard On XP Pro

Jan 25, 2004

Im attempting to install SQL Server 2000 Standard on Windows XP Pro and it keeps returning to me an error:

"Microsoft SQL Server 2000 Standard Edition server component is not supported on this operating system. Only client components will be available for installation."

Anybody have any idea what this means according to the documentation and previous posts on installation problems my operating system should support this edition of SQL server.

View 2 Replies View Related

SQL Server 2000 Standard Edition

Jan 16, 2008



I am currently trying to migrate to a new computer. My old computer (Box 1) has Windows 2000 Ver 5.0 SP4 as an operating system. My new computer (Box 2) has Windows XP Professional Ver 5.1 SP2 as an operating system.

Currently, I have Microsoft SQL Server 2000 running on Box 1. When I used the CD to install the software on Box 2, it will not allow a full install. Just the Client portion. The exact message I get is "Microsoft SQL Server 2000 Standard Edition is not supported on this operating system. Only client components will be available for installation.

How in the world do I get this software to install on Box 2? I've seen and downloaded, the service packs but I don't know where to go from there.

Thanks in advance for any help that you can provide.

View 5 Replies View Related

Max. Memory Supported By Standard Edition

Aug 1, 2001

I learned that SQL2000 Standard Edition can only support up to 2GB RAM, we have a WIN2K system on a server with 4CPU, 4GB RAM,
if we run SQL2000 Stanard Edition on it, will the 2 extra 2GB of RAM be wasted ?
Since there is a big diff. between licensing cost of SQL Standard and Enterprise, that's why the user choose Std. edition.

Any opinion or comment...

View 1 Replies View Related

Lock Pages In Memory On X64 Standard

May 18, 2007

All,

I have a new database server running W2K3/MSSQL2K5 x64. I read in BOL that you can use the Lock Pages in Memory option to improve performance on your database server. I did some research on the internet and some sources are stating that you can only use that option with MSSQL2K5 Enterprise but in BOL they state that you can use this option in Standard/Enterprise.

Can anyone confirm that "Lock Pages in Memory on x64 Standard" works in MSSQL2K5 Standard?

Thanks in advance for the help.

View 1 Replies View Related

Memory Limitations, 2005 Standard

Mar 9, 2006

Hi all,I have recently implemented a SQL 2005 cluster using SQL 2005 Standardon Windows 2003 Enterprise edition.Both nodes have 4GB of RAM and according to the datasheet, SQL 2005Standard can support the OS maximum memory amount and Win2K3 EntEdition can support 64GB!However, in Enterprise Manager, if I go to the "Memory" tab of theinstance properties I can't increase the memory beyond 2147483647(which I assume is around 2GB).I don't have AWE enabled but am unsure as to the ramifications of this.Any advice anyone could provide would be greatly appreciated.Many thanks,Ian

View 2 Replies View Related

SQL Server 2000 Developer Vs SQL Server 2000 Standard

Nov 22, 2004

I have installed the SQL Server 2000 developer that came with Office XP Developer. I now have a copy of SQL Server 2000 Standard. What will happen if I try to install the standard version? Will I loss any of my current database logins or settings, etc...?

Thank you for any help,

View 1 Replies View Related

How Many Concurrent Users With SQL Server 2000 Standard && 2GB ??

Dec 16, 2004

Standard costs 2000 euros approx (5CALs)
Enterprise costs 40000 euros apprx

Standard only supports 2GB or RAM
How many concurrent users do you think standard edtion can handle in a Dual Xeon 2.8 with 2GB ram ?

Enterprise is very expensive. sucks that standard can't handle more than 2GB Ram

View 1 Replies View Related

SQL Server 2000 Standard .. DB Size Limit

Dec 29, 2003

Hi all.

On the MS website (at this URL: http://www.microsoft.com/sql/evaluation/overview/default.asp) it says that the Standard edition of SQL Server 2000 has a database size limit of 1,048,516 terabytes.

Talking to a friend, he tells me this is not true, and that it has a database size limit of 12gb.

Is Microsofts site incorrect, or is my friend lost?

Cheers! :-)

View 2 Replies View Related

Maximum Memory On Sql7 Standard Edition

Feb 20, 2002

Hello,
I have been trying to find out what the maximum memory we can have on SQL7 standard edition server. Have not been able to find it anywhere...
Anuy ideas would be greately appreciated.
TIA
B.

View 1 Replies View Related

Standard Of Capturing Memory Utalization Per Database

Mar 30, 2007

Hi all ,



Is there any way to get memory utilization for a Database.



Regards

Sufian

View 3 Replies View Related

SQL Server 2000 Database To SQL Server 2005 Standard Security Issue

Jan 12, 2006

We have experienced an issue with back backup / restore of a database originating from SQL Server 2000 to SQL Server 2003.

We have the following setup:

SQL Server 2000

  - DatabaseA

     - asdfUser (SQL User)

               - asdfUser is (dbowner) of DatabaseA

  - DatabaseB

     - asdfUser (SQL User)

               - asdfUser is (dbowner) of DatabaseB

SQL Server 2005 Standard

  -asdfUser is NOT Setup as a user yet.

 

-We restore DatabaseA and DatabaseB to the SQL Server 2005 Standard. The databases are restored with the security permissions of asdfUser being the DB Owner of DatabaseA and DatabaseB.

-We create a new SQL user named asdfUser on the SQL Server 2005 box. We then try to add the UserMapping of DBOWNER for the DatabaseA and DatabaseB. We receive an error message stating that the asdfUser already have permissions to the databases. We proceed with the user creation without those permissions.

-We proceed to the login properties of the asdfuser and view their UserMappings. The asdfUser does not have access to DatabaseA or DatabaseB. We then add the UserMapping of DBOWNER to both DatabaseA and DatabaseB. We Try to select OK and we receive an error message that states that the user already has those permissions.

-When we query the UserID's of the asdfUser that is in the database and the UserID of the asdfUser that is created, they are two different values.

I assume this is a bug... any word on a fix?

 

 

View 1 Replies View Related

Windows 2003 Server SP2 To Be Applied On SQL Server 2000 Standard Edition SP3

Mar 17, 2008

We got SQL Server 2000 Standard Edition SP3 running on Windows 2003 Standard Edition server.

Now, we would like to apply windows 2003 SP2 to the Operating System.

We are concerned that whether windows 2003 SP2 is compatible with SQL server 2000 (SP3)?




I was looking at the application compatibility chart for Windows 2003 SP2.Among them Microsoft SQL Server Standard (2000) was listed but with no Service pack details. And also does Standard means standard edition there?




My Question - Is windows 2003 server SP2 compatible with SQL Server 2000 (SP3) Standard Edition? And what if I plan to apply SP4 to Sql Server ?



Please help. Thanks

View 7 Replies View Related

MSDE Upgrade To SQL Server 2000 Standard Edition

Aug 9, 2004

Hello,

I recently upgraded my MSDE server to SQL Server 2000 database. After the upgrade, I see, every minute,in the logfile that the database is starting whilst in Enterprise manager the database is up and running. I would be grateful if you could bail me out of this anomaly.

Hope to hear from you soon.

Regards,
Albert.

View 2 Replies View Related

Problems In Installing Sql Server 2000 Standard Edition

May 23, 2007

When i install sql server 2000 i have a message
" Microsoft SQL Server 2000 Standard Edition Server Component is not supported on this operating system only client components will be available for installation"

Hence I cannot install properly. I installed only the client componets. Thereafter when I went through Enterprise Manager and tried to establish a connection, I failed. It said server does not exist.

What to do now?

I found out that if one has sql server 2000 standard editon the prerequisties are
Microsoft Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Server 4.0 Enterprise Edition with Service Pack 5 or later, Windows 2000 Server, Windows 2000 Advanced Server, or Windows 2000 Datacenter Server.


I have windows xp professional version on which i am installing sql server standard edition.
Which of the above exists in my OS. Or which should I download.

Thanks

View 1 Replies View Related

Change Sql Server 2000 Enterprise To Standard Edition

Sep 6, 2007

Hi,
One of our main servers running on SQL Server 2000 Enterprise edition which has transactional replications on it which replicates to other servers running on the SQL Server 2000 Enterprise edition as well.

Due to Hardware problems the server is being migrated to a new machine but the client has installed SQL Server 2000 standard edition on the new machine.


We will be using a two processor cpu with 4GB RAM and we are also not planning about clustering. Is there any problem if i migrate the server in Standard Edition will the replications work properly between Standard and Enterprise editions.

What other complications can be there if i switch over to standard edition from enterprise edition

Thanks in ADVANCE

Jacx

View 1 Replies View Related

SQL Server 2000 Std Memory

Feb 12, 2007

I have SQL Server 2000 STD installed on a Windows Server 2003 STD machine. It's essentially the only app on this box. I have 4GB of RAM installed. SQL is configured to dynamically allocate memory. I run a batch file daily to restart the SQL services as SQL does not seem to release memory once it's got it. I don't think this is a problem because, like I said, it's basically the only app. But I want to make sure my OS memory settings and SQL's memory settings are optimized. Will adding the /3gb switch to the boot.ini file make a difference? Also, can someone educate me a little on PAE and AWE?
Thanks

View 1 Replies View Related

SQL Server Enterprise 2000 Edition Verse Standard Edition 2000

Jan 15, 2007

Hi there
Our ISP hosts our data on SQL Server Enterprise, but I also going to host the databases on my local machine. 
As it's just local would Standard edition do?  If I migrate the databases over, will it work?
Thanks in advance.

View 2 Replies View Related

Degrade From SQL Server 2000 Enterprise Edition To SQL Server 2000 Standard Edition

Jul 24, 2007

Hi,



Can we degrade from SQL Server 2000 Enterprise Edition to SQL Server 2000 Standand Edition without doing Uninstall and reinstall?



Thanks in advance,

View 1 Replies View Related

SQL Server 2000 Memory Issues

Aug 23, 2007

Every day or two I have to restart my SQL Server because users are receiving timeouts and very slow page loads.  My mem usage in Task Manager show that SQL Server is at 1,200,000k compared to 400,000k when I restart it.  Performance Monitor also shows that Buffer Manager/Target Pages and Total pages are maxed out.  Any advice?  Thanks!
 
 

View 1 Replies View Related

SQL Server 2000 And Memory Consumption

Sep 14, 2005

Hello!


We have a SQL Server 2000 that has been working nice
without any issues. Lately we noticed the fact that the amount of memory that
it is using has increased and once it took down the web server as the total
amount of memory used was 2G. Due to this fact I have set Memory Max to 500MB.
Now as I look in Task Manager the Memory usage is at 530396k which is 518MB.
Any reason why would it exceed the 500MB?

What we did before was to stop the SQL Server and restart it, and it takes about
2 days until it gets back to +500MB.

What can I do to stop this behavior?

Thanks.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved