Amazon

Friday, April 4, 2008

Does SQL Server need more memory? Page Life Expectancy Indicator of SQL Server buffer Memory counter is a valuable performance monitor indicator

Your Microsoft SQL Server performance is going down day by day and becoming a nightmare for you. How you will figure out that SQL Server is under memory pressure, page life expectancy counter will help you in this regard.

Go to Start -> program -> administrative Tools -> performance

















Then














See page life expectancy counter value in performance monitor as fallows.














According to Microsoft Page life expectancy counter minimum value is 300, if it is less than 300 then adding more memory in Microsoft SQL Server machine will help to increase your Microsoft SQL Server performance. Incase this counter about more than 300 then adding more RAM in machine may not significant increase in Microsoft SQL Server performance

3 comments:

TalaT said...

Good Job. IK.

angelenaalessandro said...

London colocation is the world’s data centers designed to support business applications and other factors. London colocation is the means or source of data which is important to any types of business and its websites. You are curious to know more about london data centres, go here.

liamloyarsmith said...

You should look at how the company can support your data centres and their customer service and after this you should contact them for further information and to get some estimates on the cost of their services. Interested to know more about colocation in london? Browse this site.