performance problem

Zarko
It seems that you need to add more memory.PLE counter shoud have a value
more than 300
"Zarko Jovanovic" <mind_lessIsHsAsTsEsSsPsAsMs@.inet.hr> wrote in message
news:fph6bc$806$3@.sunce.iskon.hr...
> sql server 2005 standrard, 4gGB ram, 4 processors, win 2003
> buffer cache hit ratio (BCHR) going from 97% down to 94%, page life
> expectancy (PLE) staying between 3 and 7!? sql memory default
> configuration (automanage), system free memory cca 1.7GB.
> q: how can PLE be so low and not bring down BCHR?
> q: looks like a memory pressure, but there's free memory?!!
> help apriciated
> tia
> Zarko
Zarko
Monitor your queries/locks/blocking. How much memory do you have in the
server?
"Zarko Jovanovic" <mind_lessIsHsAsTsEsSsPsAsMs@.inet.hr> wrote in message
news:fphaf8$806$6@.sunce.iskon.hr...[vbcol=seagreen]
> didi you notice : system free memory cca 1.7GB?!!
> Uri Dimant wrote:
|||Zarko, may I suggest that you bear in mind that people that answer these
forums are doing so on their OWN TIME and VOLUNTARILY. I strongly suggest
you cut them some slack or you will find that no one will answer your posts
and you will have lost a tremendous resource.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Zarko Jovanovic" <mind_lessIsHsAsTsEsSsPsAsMs@.inet.hr> wrote in message
news:fplu5a$ihc$1@.sunce.iskon.hr...[vbcol=seagreen]
> Uri, you DON'T READ! first line says: 4GB ram
> Uri Dimant wrote: