SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


HOW TO SET SSRS PROCESS AFFINITY PERMANENTLY


HOW TO SET SSRS PROCESS AFFINITY PERMANENTLY

Author
Message
goher2000
goher2000
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4454 Visits: 1859
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



Joie Andrew
Joie Andrew
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25190 Visits: 2133
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"
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search