SQL 2000 Configuration File

Question

SQL 2000 Configuration File

Ronnie Jones

Hall of Fame

Points: 3377
More actions
June 12, 2006 at 7:48 am

#61906

Hello All,
Is there a configuration file in SQL 2000 that can be edited to change various startup parameters such as memory or cpu? Or is there a location in the registry that can be altered. We suspect that there is a bad memory chip in our server and wanted to reduce the amount of memory SQL uses during start up. Our sQL server process is spiking at 90 - 100% CPU usage when ever we try to start the sql service. I initially thought about the code red virus but we are currently running at sp3 and are up to date on patches.
Thanks in advance for your help!
Ronnie

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

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

sqlstar2011 SSCertifiable Points: 6000 More actions · Answer 1

I dont believe there is any such file. However you right click on the sql server instance in enterprise manager and click properties. Under memory tab you can choose the fixed memory option, however I wont recommend using fixed option unless you want to use over3 gigs of memory.

Also I would recoomend that you upgrade to sp4.

Ronnie Jones Hall of Fame Points: 3377 More actions · Answer 2

Thanks for the info.

The problem that we are having is when ever we bring up the service, the system becomes unstable. We wanted to try to reconfigure the parameters without having to bring up sql. In order to use EM, we will have to start sql. And I agree, we need to upgrade to sp4 and will be doing so shortly.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

maybe you could try to start sqlserver with minimal configuration using startup parameters from the commandline.

sqlservr.exe -f

check out "sqlservr Application" in books online.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

vadba SSChampion Points: 11133 More actions · Answer 4

I think most of that info is stored in the master.dbo.sysconfigures table. However, I would use sp_configure to change any of those values.

Before replacing any memory, visit this link:

http://oca.microsoft.com/en/windiag.asp

and download the Microsoft memory tester. In any case, it would be better to remove the suspected memory module and either run with less RAM or put in a replacement.