July 20, 2009 at 2:43 am
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
July 21, 2009 at 7:38 am
There isn’t a tool or a formula that will tell you how much memory the server needs. The database’s size is only one parameter, but you also need to take into account that the queries that are running on this database are even more important then your database’s size. You should also notice that there are other ways to solve memory pressure then adding memory. Sometimes adding few indexes can make a huge difference. Sometimes modifying the code will make a huge difference. You need to find the queries that use most I/O and see how what you can modify to make it run more efficient.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply