Skip to content

Instantly share code, notes, and snippets.

@matt40k

matt40k/AggregationMemoryLimit.sql

Created June 25, 2018 12:15
Show Gist options
  • Save matt40k/8496adf0139b4705fb8ae866a30e7077 to your computer and use it in GitHub Desktop.
Save matt40k/8496adf0139b4705fb8ae866a30e7077 to your computer and use it in GitHub Desktop.
Download ZIP
Tuning Analysis Services (SSAS) for better Parallel Aggregation/Index Processing - http://geekswithblogs.net/ManicArchitect/archive/2010/11/02/142558.aspx
Raw
AggregationMemoryLimit.sql
-- Reference: http://geekswithblogs.net/ManicArchitect/archive/2010/11/02/142558.aspx
-- number processing cores
DECLARE @noCores TINYINT = (
select COUNT(1)
from sys.dm_os_schedulers
where status = 'VISIBLE ONLINE'
)
SELECT
AggregationMemoryLimitMax=ceiling(100/(@noCores-2))
,AggregationMemoryLimitMin=ceiling(100/((@noCores-2)*1.5))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment