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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-03-30 : 08:26:05
|
| I have a 1Gb server running both IIS and SQL. The SQL engine provides data only for the webs, but there size of the data is growing and recently SQL was scarfing the entire 1Gb to the detriment of IIS.I've set SQL's maximum memory size to 800Kb. It seemed to improve overall performance, but this was an arbitrary decision. Does anyone have any tools, measurements and guidelines which would lead to a better decision? Looking at the problem another way - what are the indicators that it is time to add more memory to a server? |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-30 : 09:37:28
|
| It's recommended not to run IIS on the same box as sql server anyway.Are you sure 800K is enough ? Not even 1 meg ? ;)-------Moo. :) |
 |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-31 : 16:58:33
|
| It's been my experience that if left to its own devices, SQL server will take as much as you will give it. It seems to prefer cache as it primary media.If you can't dedicate a server to SQL, then you've already taken the 1st step. You could even contine dropping the available memory to SQL until you see a performance hit. Eventually, you will have your answer. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-31 : 20:54:31
|
| Look at the target and total server memory for SQL Server. You can keep decreasing it until the target slightly exceeds the total if you want to balance. If regardless of how much memory you give SQL, it asks for more, then you need to swallow the hard truth and buy more RAM. RAM is cheap and 1GB isn't very much.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-03-31 : 20:58:20
|
quote:
Originally posted by derrickleggett
Look at the target and total server memory for SQL Server.
Target? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-31 : 21:21:39
|
| targett-a-r-g-e-tTargetYes, that would be the one.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Memory Allocation