473,323 Members | 1,550 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

SQL Memory Issues - Need Advice

We are currently using SQL 2000 Standard with W2K Standard and the
server has 3Gb of RAM. SQL is currently occupying 1.85Gb of memory
which I believe is the maximum for this version of the OS. I believe I
am at my limitations with my current versions of software. My
questions are:
1) Is the version of SQL Standard actually different than the
Enterprise edition. Will my database run on Enterprise if it runs on
Standard?
2) The same questions goes for the operating system? If my code runs
on W2k Standard will it run on Advanced Server?

Thanks a lot...

Jul 23 '05 #1
4 1346
Standard and Enterprise run exactly the same. The only difference is
when you upgrade to Enterprise you unlock the other features (memory
size, log shipping, etc.). Your code will also run exactly the same if
you upgrade to W2K Advanced Server from W2K Server.

Jul 23 '05 #2
Do you know if you can do a upgrade or a complete reinstall of both the
OS and the version of SQL?

Jul 23 '05 #3
You can do an upgrade of SQL Server with no problem. When you put in
the SQL EE disk and run the setup it will ask if you if you want to
upgrade. It will take about 2 minutes and then viola.

I recommend performing a complete reinstall of the OS if you upgrade.
This will mean you need to completely reinstall SQL Server though. If
you need to upgrade in place, do the OS first, reboot and then do the
SQL upgrade.

Jul 23 '05 #4

<in*******@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Do you know if you can do a upgrade or a complete reinstall of both the
OS and the version of SQL?


As far as I know, you can run the Enterprise setup program, and there's an
option to Upgrade. Although of course if you want or need to reinstall the
OS then you'll have to reinstall MSSQL anyway - you can use just backup your
databases and then restore them on the new installation.

If you do upgrade your MSSQL installation, and you're planning on using log
shipping, then see this KB article:

http://support.microsoft.com/default...b;en-us;295306

Simon
Jul 23 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: john.livermore | last post by:
We seem to have developed a memory leak in our sql server application and are getting the above error on occasion. Also, over several hours of hard usage the memory consumed by the sql server...
1
by: russ | last post by:
Hi I need some advice about ms-access limitations. i have some databases written by others i have been working with that keeps crashing. different on different computers, so it sounds like a...
9
by: Rafael Charnovscki | last post by:
I can comprehend the basics of that subject (pointers, memory allocation, heap, stack etc), but I am interested to have references with more details. I have some C/C++ books and lots of URLs...
7
by: David Jacques | last post by:
I have to reformat a string from the form "SRID=4269;POINT(-90.673 69.4310000006199)" to GeometryFromText('POINT (-141.095 68.5430000006417)',4269) ); I have a function to do this by...
25
by: Zeng | last post by:
I finally narrowed down my code to this situation, quite a few (not all) of my CMyClass objects got hold up after each run of this function via the simple webpage that shows NumberEd editbox. My...
0
by: John Linn | last post by:
We are adventuring into the land of Web Services. Here is a simple breakdown of the architecture: 1) Accept XML data 2) For each node, perform the related data operation in our backend. 3)...
81
by: Peter Olcott | last post by:
It looks like System::Collections::Generic.List throws and OUT_OF_MEMORY exception whenever memory allocated exceeds 256 MB. I have 1024 MB on my system so I am not even out of physical RAM, much...
27
by: George2 | last post by:
Hello everyone, Should I delete memory pointed by pointer a if there is bad_alloc when allocating memory in memory pointed by pointer b? I am not sure whether there will be memory leak if I do...
22
by: Peter | last post by:
I am using VS2008. I have a Windows Service application which creates Crystal Reports. This is a multi theaded application which can run several reports at one time. My problem - there is a...
4
by: aj | last post by:
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) (Build 3790: Service Pack 2) Last Friday we had a situation where the DNS system inside our Active Directory server went weird. I know this isn't...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.