| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2012-03-27 : 14:11:50
|
| Hi,We upgraded our software this morning and also installed windows updates. We rebooted the SQL Server. We are now getting complaints about performance. One metric I found odd is that "cached" memory isn't increasing. I would expect that it would gradually rise but it is stuck at 3080. Total memory is 98290, available is 44535, free is 41529. Any idea why "cached" is not going up? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-27 : 14:28:57
|
| How are you measuring 'cached' memory?--Gail ShawSQL Server MVP |
 |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2012-03-27 : 14:29:38
|
| Just using "task manager". I'm not sure how it measures it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2012-03-27 : 14:42:46
|
| PLE is increasing. it is almost at 20000. usually it gets up to about 100000 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2012-03-27 : 14:46:54
|
| I use ignite to monitor waits and everything looks fine. other than the weird memory metric i mentioned the database server stats look fine. we have a second instance of sql on the box with an older copy of the database and it is running smoothly so it is defininately instance/software related. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-27 : 15:03:31
|
| First thing, don't use task manager to monitor SQL's memory. Under some conditions it will show completely incorrect numbers.Second, if by 'cached' you meant the value at the bottom of the tab 'Performance' (Physical memory: Total, Cached, Available, Free) that is nothing at all to do with SQL Server. That's the memory used by the OS system cache. If it was constantly rising on a server I'd be very, very worried.--Gail ShawSQL Server MVP |
|
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2012-03-27 : 15:09:48
|
| I'm running the reorganize indexes and stats maintenance plan. hopefully it will help. we are also trying to optimize the "worst queries". stressful times :( |
|
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2012-03-27 : 15:26:21
|
| Looks like it was a bad stored proc. Thanks for listening to me freak out :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
sql not caching in memory???
Tara Kizer