memory allocation to SQL

Customer Support Customer Only Discussion
1

I have VPS Value pack (480Mb memory). I’m planning to set up a maximum memory amount allocated to SQL Server to keep some portion available for the rest of the server.

I started with 300Mb set as max SQL memory but it went out of memory with 2-3 users online. Moreover somehow server resource usage also hit 99%. Withut any activity on server (1-2 web users, remote desktop connection only) the server system usage is at 94% level. Is that normal?

What can be the advised level of SQL Server memory allocation?

I have mailserver, ftpserver, MS sql server and IIS running. 1-2 small application may run later on (like mysql, livezilla etc.).

2

that is going to be a real struggle with Value, I am guessing either SQL Express 2005 or 2008?

MSDE(2000) ran quite well in value as it had a lot lower overhead, but 2005/2008 need about 512MB by itself from what I have seen.

3

It’s SQL 2008 R2 web edition.

Also recognized that when I run management studio while connected through remote desktop system usage is jumping from 70% to 96% level in 10-15 minutes, going down in 5 minutes after I close the management studio application. I’ve already stopped additional sql services/agents.

2000 is not an option for us but in terms of resource needs if 2005 is much better than 2008, we may go for 2005 since the original database we’re about to move is also 2005 (standard edition).

Which tool would be best to monitor which application is using how much memory and system resource?

4

Task Manager :slight_smile:

Yes management studio can jump it up quick, even on my desktop it uses 60-100MB sitting idle.