SQL SERVER MEMORY

Viewing 1 post (of 1 total)
  • Author
    Posts

  • MarkJones
    Member
    #165558

    Hello…….

    I have a query that you guys hopefully be able to assist with.

    When you assign memory to SQL SERVER using the SQL SERVER properties|MEMORY settings, there are 2 options that I’m interested in….. MINIMUM SERVER MEMORY(MB) & MAXIMUM SERVER MEMORY(MB) If these are left at the defaults the system could in theory consume all server RAM, thus causing the system to become unresponsive..

    So take this scenario……………

    If my Server has 2 GB ram installed, and I set SQL SERVER “MAXIMUM SERVER MEMORY” SETTING to 1GB. This is what’s allocated to SQL as “buffer pool” is this correct?

    My OS now has only 1GB of ram to do it’s normal things with.

    When SQL is servicing requests from clients/applications, the SQL server will run queries/stored procedures to return data to the clients/applications. What location do the queries get executed in. BUFFER POOL or the 1GB of OS RAM?

    Regards
    Mark Jones

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by: