Skip to main content
Database Administrators

Return to Question

Incorporated comments
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 424
  • 663

Under heavy Load, my SQL Server database is executing queries really slowly. I have 96 GB of RAM and my CPU is high (100%) but my physical memory usage is at 9%. I looked at the SQL Server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. I'm wondering if there is anything I can do in SQL Server to utilize more memory.

  • Version: SQL Server 2012 Web Edition SP3 (x64)
  • OS: Windows Server 2012 R2 (x64)

max server memory is set to the default. It's a web garden for one site. My database is 2 GB. I thought SQL Server would use more memory under a heavy load with more RAM, scaling up for the number of users/queries.

enter image description here

enter image description here

Under heavy Load, my SQL Server database is executing queries really slowly. I have 96 GB of RAM and my CPU is high (100%) but my physical memory usage is at 9%. I looked at the SQL Server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. I'm wondering if there is anything I can do in SQL Server to utilize more memory.

  • Version: SQL Server 2012 Web Edition SP3 (x64)
  • OS: Windows Server 2012 R2 (x64)

enter image description here

enter image description here

Under heavy Load, my SQL Server database is executing queries really slowly. I have 96 GB of RAM and my CPU is high (100%) but my physical memory usage is at 9%. I looked at the SQL Server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. I'm wondering if there is anything I can do in SQL Server to utilize more memory.

  • Version: SQL Server 2012 Web Edition SP3 (x64)
  • OS: Windows Server 2012 R2 (x64)

max server memory is set to the default. It's a web garden for one site. My database is 2 GB. I thought SQL Server would use more memory under a heavy load with more RAM, scaling up for the number of users/queries.

enter image description here

enter image description here

added 7 characters in body; edited title
Source Link
marc_s
marc_s
  • 9k
  • 6
  • 45
  • 52

Sql SQL Server 2012 doesn't use enough memory

Under Heavyheavy Load, my sql serverSQL Server database is executing queries really slowslowly. I have 96 GB of ramRAM and my CPU is high  (100%) but my physical memory usage is at 9%. I looked at the sql serverSQL Server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. Im wonderI'm wondering if there is anything iI can do in sql serverSQL Server to utilize more memory.

Version: SQL SERVER 2012 Web Edition SP3 (x64) OS: Windows Server 2012 R2 (x64)

  • Version: SQL Server 2012 Web Edition SP3 (x64)
  • OS: Windows Server 2012 R2 (x64)

enter image description here

enter image description here

Sql Server 2012 doesn't use enough memory

Under Heavy Load, my sql server database is executing queries really slow. I have 96 GB of ram and my CPU is high(100%) but my physical memory usage is at 9%. I looked at the sql server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. Im wonder if there is anything i can do in sql server to utilize more memory.

Version: SQL SERVER 2012 Web Edition SP3 (x64) OS: Windows Server 2012 R2 (x64)

enter image description here

enter image description here

SQL Server 2012 doesn't use enough memory

Under heavy Load, my SQL Server database is executing queries really slowly. I have 96 GB of RAM and my CPU is high  (100%) but my physical memory usage is at 9%. I looked at the SQL Server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. I'm wondering if there is anything I can do in SQL Server to utilize more memory.

  • Version: SQL Server 2012 Web Edition SP3 (x64)
  • OS: Windows Server 2012 R2 (x64)

enter image description here

enter image description here

deleted 1 character in body
Source Link
rlshaw
rlshaw
  • 1
  • 1

Under Heavy Load, my sql server database is executing queries really slow. I have 96 GB of ram and my CPU is high(100%) but my physical memory usage is at 9%. I looked at the sql server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. Im wonder if there is anything i can do in sql server to utilize more memory.

Version: SQL SERVER 2012 Web EdidtionEdition SP3 (x64) OS: Windows Server 2012 R2 (x64)

enter image description here

enter image description here

Under Heavy Load, my sql server database is executing queries really slow. I have 96 GB of ram and my CPU is high(100%) but my physical memory usage is at 9%. I looked at the sql server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. Im wonder if there is anything i can do in sql server to utilize more memory.

Version: SQL SERVER 2012 Web Edidtion SP3 (x64) OS: Windows Server 2012 R2 (x64)

enter image description here

enter image description here

Under Heavy Load, my sql server database is executing queries really slow. I have 96 GB of ram and my CPU is high(100%) but my physical memory usage is at 9%. I looked at the sql server memory usage which is in the screenshots below. I enabled Locked In Pages but it didn't seem to help. Im wonder if there is anything i can do in sql server to utilize more memory.

Version: SQL SERVER 2012 Web Edition SP3 (x64) OS: Windows Server 2012 R2 (x64)

enter image description here

enter image description here

Source Link
rlshaw
rlshaw
  • 1
  • 1