Memory consumption- Windows or SQL Server

Question

Memory consumption- Windows or SQL Server

coolchaitu

SSChampion

Points: 10332
More actions
May 7, 2017 at 11:59 pm

#402038

Good morning Experts,
How to find whether Windows is consuming high memory or SQL Server is consuming high memory

Viewing 13 posts - 1 through 12 (of 12 total)

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

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 1

SQL Server will always use all the memory allocated to it. How much memory do you have on your server and what have set as your max server memory for SQL Server?

Thanks

coolchaitu SSChampion Points: 10332 More actions · Answer 2

The server has 640 GB. SQL Server max server memory value is set to 605GB. We are getting alert that 99% virtual memory is used. How to fix this?

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 3

Is it purely a database server or is anything else running on there?

Thanks

coolchaitu SSChampion Points: 10332 More actions · Answer 4

NorthernSoul - Monday, May 8, 2017 1:49 AM
Is it purely a database server or is anything else running on there?
Thanks

Not sure about that.

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 5

NorthernSoul

SSCertifiable

Points: 6869

May 8, 2017 at 2:00 am

#1941521

Can you find out?

Thanks

coolchaitu SSChampion Points: 10332 More actions · Answer 6

NorthernSoul - Monday, May 8, 2017 2:00 AM
Can you find out?
Thanks

Database Server

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 7

You can always use Task Manager to have a look at what is running besides SQL Server and go from there. It possible you might need to either add more memory to the server for the OS to use or reduce the amount that SQL Server uses but make sure you monitor for any SQL Server related memory alerts.

Thanks

Perry Whittle SSC Guru Points: 233821 More actions · Answer 8

coolchaitu - Monday, May 8, 2017 1:44 AM
The server has 640 GB. SQL Server max server memory value is set to 605GB. We are getting alert that 99% virtual memory is used. How to fix this?

virtual memory?
At 640GB total with 605Gb set on the instance this is 94%
Confirm the exact message please

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

coolchaitu SSChampion Points: 10332 More actions · Answer 9

Perry Whittle - Tuesday, May 16, 2017 4:54 AM
coolchaitu - Monday, May 8, 2017 1:44 AM
The server has 640 GB. SQL Server max server memory value is set to 605GB. We are getting alert that 99% virtual memory is used. How to fix this?
virtual memory?
At 640GB total with 605Gb set on the instance this is 94%
Confirm the exact message please

Yes, thats the message we are getting

RandomEvent SSCrazy Points: 2963 More actions · Answer 10

try running

-- Get me physical RAM installed

-- and size of user VAS

select physical_memory_in_bytes/(1024*1024) as phys_mem_mb,

virtual_memory_in_bytes/(1024*1024) as user_virtual_address_space_size

from sys.dm_os_sys_info

go

--

-- Get me other information about system memory

--

select total_physical_memory_kb/(1024) as phys_mem_mb,

available_physical_memory_kb/(1024) as avail_phys_mem_mb,

system_cache_kb/(1024) as sys_cache_mb,

(kernel_paged_pool_kb+kernel_nonpaged_pool_kb)/(1024) as kernel_pool_mb,

total_page_file_kb/(1024) as total_virtual_memory_mb,

available_page_file_kb/(1024) as available_virtual_memory_mb,

system_memory_state_desc

from sys.dm_os_sys_memory

go

thanks to whoever I borrowed this code from at some point in the past.

Let us know the results.

RandomEvent SSCrazy Points: 2963 More actions · Answer 11

Also are you running Full text Search or anything like that as this can have an impact on the virtual memory settings. If I remember rightly the Virtual memory is allocated by the OS not SQL Server so it is feasible that it is higher, and with something like Full text search you actually need to set the Max memory setting to higher than physical memory by something like 1.5 times. Although that was a long time ago in a different life so I might be making it up.

coolchaitu SSChampion Points: 10332 More actions · Answer 12

RandomEvent - Tuesday, May 16, 2017 5:09 AM
try running
-- Get me physical RAM installed
-- and size of user VAS
select physical_memory_in_bytes/(1024*1024) as phys_mem_mb,
virtual_memory_in_bytes/(1024*1024) as user_virtual_address_space_size
from sys.dm_os_sys_info
go
--
-- Get me other information about system memory
--
select total_physical_memory_kb/(1024) as phys_mem_mb,
available_physical_memory_kb/(1024) as avail_phys_mem_mb,
system_cache_kb/(1024) as sys_cache_mb,
(kernel_paged_pool_kb+kernel_nonpaged_pool_kb)/(1024) as kernel_pool_mb,
total_page_file_kb/(1024) as total_virtual_memory_mb,
available_page_file_kb/(1024) as available_virtual_memory_mb,
system_memory_state_desc
from sys.dm_os_sys_memory
go

thanks to whoever I borrowed this code from at some point in the past.
Let us know the results.