sql memory setting-server properties

[nirmalsp]

hi

i am having a server performance problem , i have been recomended to setup the memory settings in sql server properties.

is there a standard ?
what is recomended for most severs

need help

 

[tlbroadbent]

SQL Server 7 and higher dynamically handle memory. Adjusting the memory settings is not recommended. If needed, you can do this by setting the Min and Max Memory server options.

In reality, too little memory will adversely impact performance but most performance problems are caused by:

1) Poor query design
2) Lack of proper indexes on tables
3) Poor database design

If all those issues are taken care of and performance is still bad, you should analyze whether the performance problems are related to the SQL configuration, lack of memory, lack of disk space, poor i/o performance, processor usage, etc.

See

http://www.sql-server-performance.com/

for more information about performance tunning. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.