Windows Forum

Ask something
Discussion Locked

Queries on SQL 7 settings running on NT

0 helpful
3 replies

by matthias.tan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can someone pls help me on my queries pertaining to SQL 7 settings.

Environment:
SQL 7 running on a NT4 Server with 1.4G of RAM and 2xP3 550mhz CPU.

1) My current setting for Parallelism is "Use 1 Processor(s)" under Processor of the SQL Server Properties. The other available option is "Use all available processors". Many times, I encountered the SQL processor, sqlservr.exe hogging the CPU at 100%, thus slowing down the system drastically. Will setting the option to "Use all availableprocessors" overcome my problem.

2) What is the ideal Memory setting on the SQL Server. My current setting is using "Dynamically configure SQL Server memory" with Minimum = 0Mb and Maximum = 1.4G.

Your advice will be fully appreciated. Thks.

3 replies

by joseph moore

Start with this Technet article:
http://support.microsoft.com/?kbid=319942
It lists configuration settings for SQL 7.0 that you might need.

As for memory, try this article:
http://support.microsoft.com/?kbid=224818
It specifically says, "The minimum dynamic memory setting for SQL Server 7.0 must be increased from the default of zero to a value of at least 32 megabytes (MB)."

Also, this article should be useful:
http://support.microsoft.com/?kbid=224587

And the SQL Books Online forSQL 7.0 has useful info on configuration settings. Click this link to download the books:
http://www.microsoft.com/sql/techinfo/productdoc/70/books.asp
(please remove any spaces)

hope this helps

This discussion is closed to new replies.