• GilaMonster (10/31/2013)


    Logical reads are reads done from memory. Not necessarily scans.

    Slower queries isn't important to you? Really?

    yes thx ,,..

    slower queries are important but i think the CPU time = 78 ms, elapsed time = 79 ms are ok no??

    or do you think that is it problem ?

    and I read the info about this solution with database snapshot (I will read some example next time ), I am not sure about it, we have lot of procedures or few programs have adhoc queries or i dont have source code from this ... and I am not alone who has access to DB, but I try optimize most running queries ( logical reads and etc... ) .. , it is very dangerous, because we work 24h/5days.

    now we have full RAM -- 30GB from 32GB,, but next months we will increase to 64 or 128.. depends on few issue, you know I work in Korea company and buy something is for looooong time... very long time...