Recently we faced a performance issue in one of the box so, we increased RAM 32 to 70 GB.
We feel it is more than as required.
Is there any scientific calculation/utility/scripts to measure required RAM on that box or particular user database.
Present Box having sql server 2008 enterprise edition and one user database (250 GB capacity)
i am on bottle neck for finding this. Any one can help me
Thanks,
kk