+ Reply to Thread
Results 1 to 3 of 3
  1. Member
    Join Date
    Jul 2014
    Location
    SOUTH AFRICA
    Posts
    40

    Certifications
    MCSA,MCSE,SQL 2012
    #1

    Default SQL Server Memory

    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!
    Reply With Quote Quote  

  2. SS -->
  3. Junior Member Registered Member
    Join Date
    Sep 2015
    Posts
    1
    #2
    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
    Reply With Quote Quote  

  4. Member
    Join Date
    Jul 2014
    Location
    SOUTH AFRICA
    Posts
    40

    Certifications
    MCSA,MCSE,SQL 2012
    #3
    Thanx Amix,i tried it it seems the server is stable for now.Are you a dba as well?
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks