change configuration settings to improve performance

[holdahl]

does anyone know how much impact a low value for the Page Life Expectancy has on performance for the SQL Server?
Today the value was only at 50-150, while microsoft says that this should be 300 or above. (recommended).
Is there any configuration settings which could be changed to improve performance of the sql server?
The SQL cache memory for sql server is at 12720(KB).
Should this be adjusted to the amount of RAM installed?
Could this have any effect on the performance of the SQL Server?

sH

 

[ptheriault]

This can have a big impact on performance. That number is the number of seconds a page will stay in the buffer pool. What is the total memory on your server and have you set the max memory or is it dynamically allocated? If that number is always below 300 then you might need to add more memory to the server. What is your buffer cache hit ratio. That number should be about 90%.

- Paul
- Database performance looks fine, it must be the Network!

 

[holdahl]

total memory on the server is 8GB.
I have set a min mem to 2GB and max mem to 6GB.

the buffer cache hit ratio is currently on 99,862

could the sql cache memory be increased to get any improved performance, or does it require more memory to improve the performance?

sH

 

[ptheriault]

That's a good number for the Buffer Cache Ratio. Is the Page Life Expectancy always below 300?
I wouldn't add more memory till I've checked the other performance counters. Here is a link which will tell which counters to check.

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

Also, check the size of your page file.

- Paul
- Database performance looks fine, it must be the Network!