Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Utpal
Posting Yak Master
179 Posts |
 Posted - 2007-11-11 : 01:22:03
|
| Hi everybody,I am trying to determine the optimum amount of server memory that would be required for my SQL Server application. According to a book, it is calculated as follows:Minimum memory required = System memory + User memory + Database process memoryI have thought about ways to determine each component of memory.1) I could determine the System memory utilized from the Task manager (Total - Available), when the SQL Server service has been started, and no applications are running.2) I could determine User memory by ascertaining the number of concurrent users during peak usage time of the application and then multiplying it with 0.5 MB.3) I could determine Database process memory by summing up the "memusage" column in the SysProcesses table, at the time of peak usage and multiplying it with 8.Please let me know whether they are correct. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-11 : 01:34:05
|
| How do you determine data cache? What's total db size on the server? What's sql edition? |
 |
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-11 : 06:07:52
|
| If you already have a server, then allocate as much as possible.As much as possible = Physical memory - room for windows (512K-1M),Not always possible if you cant use AWE.THere is another, more interesting question.Is there any reason to buy and install more memory? On a given database and workload, how much memory do I need?(I know an answer :) ) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-11 : 19:49:20
|
| Windows needs much more than 1m memory. |
|
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-12 : 02:49:47
|
| >Windows needs much more than 1m memory.I did not knowMy laptop has 512M :) |
|
|
|
|
|
|
Determining the server memory required for SQL Ser