SQL Server 2008R2 Ent not using all available memory

  • See https://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Memory%20Management for some details about how SQL Server uses memory. There is also a lot of advice (some right, some wrong) if you Google specific topics.

    Applying a service pack to SQL Serve will not affect the underlying mechanisms for using memory, such as AWE. However, a service pack will fix various bugs in memory usage.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • Tried to download SQL fine build but got blocked with the following msg:

    Gateway Anti-Virus Alert

    This request is blocked by the Firewall Gateway Anti-Virus Service. Name: Kryptik.BHAQ (Trojan)

  • Can you tell me which FineBuild download you tried, and if you used the Codeplex site for the download. I have just checked all the items I uploaded and my AV reports no problems.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • this is the URL

    http://sqlserverfinebuild.codeplex.com/releases/view/121215

    Trying to download using Chrome and at first it gives me the option to save the zip file but then that fails and when I try again it gives the trojan warning.

  • The problem with the FineBuild download is a mystery. Can you look at https://sqlserverfinebuild.codeplex.com/discussions/571439 and continue the discussion on that site, as this thread is about a different problem.

    I have downloaded the zip file both at home and at my employers site with no virus warning, and have checked the download at both places with different AV tools and also found no problems. If you are able to isolate which file is causing your AV to be upset I will replace it, but there is also a possibility your AV is throwing a false positive.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply