daknetworks.com

You are here: Blog SQL Server 2014 High CPU After Installing SP2

SQL Server 2014 High CPU After Installing SP2

SQL Server 2014 High CPU After Installing SP2. There are 3 steps I used to fix this:

STEP 1: find the username of the SQL

  • -open "SQL Server 2014 Configuration Manager."
  • -right-click on the instance of SQL that you are running.
  • -click PROPERTIES (a box opens).
  • -click LOG-ON tab (at the top).
  • -take note of the USERNAME that is running.
  • -click OK
  • -exit out of "SQL Server 2014 Configuration Manager."

STEP 2: add the username to the LOCK PAGES IN MEMORY section

  • -click START > RUN
  • -type: gpedit.msc
  • -click COMPUTER-CONFIGURATION > WINDOWS-SETTINGS > SECURITY-SETTINGS > LOCAL-POLICIES > USER-RIGHTS-ASSIGNMENT
  • -find LOCK-PAGES-IN-MEMORY
  • -click ADD-USER-OR-GROUP
  • -type in the USERNAME from above.

STEP 3: adjust the MAX MEMORY

  • -open the 2014 MANAGEMENT STUDIO
  • -login to the SQL DATABASE you are running.
  • -right-click the SQL DATABASE name (at the top, on the left-hand side)
  • -click PROPERTIES
  • -click MEMORY (on the left hand side).
  • -you will see the MINIMUM SERVER MEMORY and the MAXIMUM SERVER MEMORY areas.
  • -leave the MINIMUM SERVER MEMORY at 0 (zero).
  • -find the MAXIMUM SERVER MEMORY box.
  • -type in the number for your server. This number is based on the amount of RAM in your system.
  • -the chart is here: https://www.brentozar.com/blitz/max-memory/
  • -click OK.

That's it!!! You did it!!!

Contact Dak Networks

We are not taking on new clients at this time.