Report Portal

What You Need to Know About SSAS Processor Affinity

I've been looking into using processor affinity on our SSAS instances to help control the workload on our servers. Sometimes a process can run which will grab as much CPU resource as it can, which means that queries on the cubes cannot run, grinding the front end to a halt. Unlike the db engine, there is no resource governor for Analysis Services. Sure you can set the min/max memory simple enough, but setting limits on IO and CPU is a more complex task.

Read more...

Tags: management, performance

 

2007-2015 VidasSoft Systems Inc.