August 17, 2017 at 9:02 am
does any one knows how to setup SSRS process affinity permanently? I have two SSRS servers in scale-out deployment.. both CPU hitting 100%, i guess i need to add one more box until then, I want to set process affinity so that box does not freeze
September 8, 2017 at 2:17 pm
You might be able to do it modifying the start properties of the SSRS service in the registry specifying the affinity you want in the imagepath value of the service registry key.
Check this out for a quick and dirty example of setting affinity for a program.
How To: Launch Program with Affinity Automatically Set - YouTube
What I would do is identify the affinity value you want to set for SSRS and then append that value to the imagepath data in the registry.
Ex:
Registry key: Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ReportServer
Name: ImagePath
Data: "C:\Program Files\Microsoft SQL Server\MSRS13.MSSQL\Reporting Services\ReportServer\bin\ReportingServicesService.exe" /affinity 01
Restart SSRS and see if it works.
Let me know if it works for you or not. I am interested in the results and unfortunately do not have time to test right now, so this is only a theoretical fix at this point.
Joie Andrew
"Since 1982"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply