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 |
|
bpsintl
Posting Yak Master
132 Posts |
 Posted - 2011-05-30 : 10:08:10
|
| Hi all, I've just got a new dedicated server that I will be using as both a webserver and sql server.I've got 16Gb of ram on it. Is it worth restricting that max ram that sql server is allowed to use or would you just leave it to sort itself out? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-30 : 10:59:01
|
| How much do you need for non sql server things?I would normally leave it unless I thought it was causing an issuee (checked by monitoring) but sounds like you are using it for other things.Left to itself sql server will take as much memory as is allowed and it thinks it needs so your web server could be starved.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2011-05-30 : 11:03:39
|
| Thanks. I think I'll keep an eye on it but there's only a few small databases on there anyway but the websites get quite a lot of traffic... |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-05-30 : 13:21:58
|
| Is this an x64 or x86 system? If x64 and you have set the locked pages in memory right - then you will definitely need to set max memory. In this situation, SQL Server can and will take all of the memory on the server and starve not only the web applications but the OS.What we have found for our web based applications is that it is much better splitting the web servers off on their own servers. We create virtual machines to host the web application and leave the physical machine dedicated to SQL Server. Since we can use load balance web servers, we can create multiple web servers in the VM farm to support additional users quite easily - and each individual web server doesn't need a lot of resources (usually 2 CPUs and 3GB of memory).I would not recommend running both the web application and SQL Server on the same system. However, if you don't have the resources then you have to do what you can.Jeff |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2011-05-31 : 03:46:51
|
| It's 64 bit. What do you mean by "set locked pages in memory right" please? |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-06-01 : 11:50:13
|
| Lock Pages In Memory: http://msdn.microsoft.com/en-us/library/ms190730.aspxYou want this for 64-bit but you don't care about AWE.In Re: "I've just got a new dedicated server that I will be using as both a webserver and sql server."It's either dedicated or its used for both.=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
|
|
|
|
|
|
Restricting SQL server max ram