SQL Memory ! What is the best setting ?

Question

SQL Memory ! What is the best setting ?

Viewing 4 posts - 16 through 18 (of 18 total)

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

SeeCoolGuy SSCrazy Points: 2902 More actions · Answer 1

I kinda jumped the gun while reading this thread, I have a dev server (sql developer actually) and what I did was right click in EM and in startup parameters I added the /3GB switch, now I can't restart the box, I know I *could* just re-install developer but was wondering if there was a workaround .

Thanks,

-- Francisco

Jeff Gray SSChampion Points: 10667 More actions · Answer 2

The /3GB switch is not intended as a SQL server startup parameter.

You say that the box won't start, but how would you re-insall SQL server on a box that won't start? That shouldn't happen as a result of adding /3GB in the SQL parameters, which live in the registry, so I'm guessing that by "box" you meant "SQL instance".

Look in:

HKLM\Software\Microsoft\Microsoft SQL Server\%InstanceName%\MSSQLServer\Parameters

Where %InstanceName% is the name of the SQL server instance that you want to modify. I'm not sure where the key is if your installation is not a named instance, but it should be right around there somewhere.

Apologies in advance if I've completely misunderstood you...

jg

John Rowan SSC Guru Points: 56440 More actions · Answer 3

What exactly do you mean by 'can't restart the box'? The /3GB switch should be added into the boot.ini file, not as a SQL Server startup parameter. Adding it in as a SQL Server startup parameter should not have an impact on your server's ability to restart. It may cause SQL Server to have problems restarting, but you should be able to remove it as a startup parameter and restart your SQL Server. Open up your registry and go to [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters]

and delete the key value.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

SeeCoolGuy SSCrazy Points: 2902 More actions · Answer 4

sweet, thank you,... this was dumb... but at least it was on my "dev" box (not even test) . I removed the parameter out of the registry and life is good .

-- Francisco