SQL 2K Standard Edition

Question

SQL 2K Standard Edition

sqldba_cdn

SSC Enthusiast

Points: 103
More actions
November 15, 2005 at 3:15 pm

#166054

Hi,
SQL 2K Standard edition has a max memory of 2GB. Is this per server or per instance?
If it was per instance then it would depend on what the OS supports i.e Win2000 server (4GBRAM)or Win2000 advanced (8gbRAM)server.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Vik Nat Hall of Fame Points: 3930 More actions · Answer 1

Does not matter whether Windows Adv server or windows server. Max memory for SQL 2000 Standard edition is 2GB per server.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 2

I do not know for sure but logic is telling me that the limit is 2 Gb per instance on a server. My reasoning is as follows:

if you have one instance you can look at sqlservr.exe in the task manager and see it's memory usage.

if you add another instance to the same server you can see another instance of sqlservr.exe executing as well.

since there are 2 distinct instances and they are not bound to one another in any way they both can utilize the 2 Gb max memory each.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

dharper3 SSCrazy Points: 2391 More actions · Answer 3

I tend to agree with Rudy, not tested but I also would think that as each instance has its own process and memory footprint. Each would I think be limited to 2gb (std ed)