Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
denis_the_thief
Aged Yak Warrior
596 Posts |
 Posted - 2011-01-13 : 11:01:53
|
| I run this query:select *from master..sysperfinfowhere object_name = 'SQLServer:Buffer Manager'I get:counter_name cntr_valueFree pages 75Total pages 11452Target pages 28499Database pages 5559The Server has 3.75G Ram. I checked the Maximum server memory and it is set to the Max. Any ideas how to increase Buffer Pool Size or why it is so low? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-13 : 14:33:36
|
| What edition of SQL 2008 are you using? And is it 32x or 64x? What does the Page Life Expectancy look like? Is anything other than SQL Server running on the box? And, what OS? |
 |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2011-01-14 : 11:38:01
|
quote:
Originally posted by russell
What edition of SQL 2008 are you using? And is it 32x or 64x? What does the Page Life Expectancy look like? Is anything other than SQL Server running on the box? And, what OS?
Thankyou. It is Windows Server 2003, SQL Server 2005, 32x, nothing else running on the box. The Page Life expectancy is 84245. I am wondering if the reason the Target Pages are low is because the total Data in the Databases is plain small. Is raising the Min Server Memory a good/bad idea? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-14 : 12:24:15
|
| Could be. If your data footprint is less than the RAM, then it may all be in cache already. The PLE is excellent, so unless you're experiencing problems, I wouldn't worry too much about it. But I would continue to keep an eye on things.Are you using the 3GB switch? If not, you can only access 2 GB anyway.I never set the minimum memory, but I do set the max memory. I'd likely set it to 3GB or maybe 2.75 GB in your case, leaving the rest for the OS. Unless something else besides SQL Server is running on the box. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-14 : 12:59:21
|
| Is the PLE value min or max?From the value you are getting I guess it is the max value.What is the min PLE value?In ideal condition target pages and total pages should be almost same.With 3.75 GB RAM and with 32 bit I doubt it is not using more than 2 GB of memory.I think the best option would be for you to enable AWE so that buffer pool uses the maximum memory for data pages.PBUH |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2011-01-14 : 14:11:07
|
quote:
Originally posted by Sachin.Nand
Is the PLE value min or max?From the value you are getting I guess it is the max value.What is the min PLE value?
That was the current PLE, I'm not sure how you'd get the min or max.quote:
In ideal condition target pages and total pages should be almost same.
That's partly why I posted. But after more looking around. Like executing select * from the 2 biggest tables, I'm strating to think SQL Server doesn't need the target memory, at least not at the moment. |
|
|
|
|
|
|
|
|
Why is my Target Pages so low?