SQL Server Memory

Tawaz

it has been long since i last posted/commented on this forum.Please guys i need help,i got a job recently as a DBA for a large organization.The Sql server is using all the Memory and its causing a problem as the server hangs sometimes during the day.I did all i thought could be the problem but no solution yet.We always restart the server during the day and it makes me feel bad that i am failing as a dba to identfy the problem and solution.What might be the Issue?Please help to save my skin!

amix

Hi,

You should start by limiting the memory used by your SQL instance. Usually I keep 4GB for the system.
For example, if your server has 32GB memory, set the limit memory of your SQL Instance to 28GB.

You'll find the option on the properties or launch this query:

EXEC sys.sp_configure N'max server memory (MB)', N'28672'
GO
RECONFIGURE WITH OVERRIDE
GO

Hope this will be enough.
Starting as a DBA is difficult. Is there any other DBAs ?
DBA is the kind of job that requires lot of skills throughout the years of experience. You can consider yourself lucky to have the opportuniy to learn it. You'll be rewarded

Any help, mp me and I'll give you my contact.

Good luck

Tawaz

Thanx Amix,i tried it it seems the server is stable for now.Are you a dba as well?