Skip to content

Instantly share code, notes, and snippets.

@ronascentes

ronascentes/get_resource_pool_pct_needed.sql

Created January 9, 2018 17:53
Show Gist options
  • Save ronascentes/a1aec6ad752d9ef2ac8b1cfe52ddc56b to your computer and use it in GitHub Desktop.
Save ronascentes/a1aec6ad752d9ef2ac8b1cfe52ddc56b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_resource_pool_pct_needed.sql
USE master
GO
DECLARE @memoryNeeded INT = 16
SELECT percentNeeded = @memoryNeeded /
ROUND(((committed_target_kb/1024)/1024) *
(CASE
WHEN (committed_target_kb/1024)/1024 <= 8 THEN 0.7
WHEN (committed_target_kb/1024)/1024 <= 16 THEN 0.75
WHEN (committed_target_kb/1024)/1024 <= 32 THEN 0.8
WHEN (committed_target_kb/1024)/1024 <= 96 THEN 0.85
ELSE 0.9
END), 0)
FROM sys.dm_os_sys_info
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment