Update rsreportserver.config file using PowerShell

I’m sure there is an easier way in to achieve this in PowerShell, but here is 1 way to add and set the WorkingSetMaximum and WorkingSetMinimum entries in the rsreportserver.config file (ref: Configuring Available Memory for Report Server Applications)

 

$xfile=’E:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config’
[xml]$xml=gc $xfile
$new=$xml.CreateElement(‘WorkingSetMaximum’)
$new.InnerText=204800
$xml.Configuration.Service.AppendChild($new)
$new=$xml.CreateElement(‘WorkingSetMinimum’)
$new.InnerText=102400
$xml.Configuration.Service.AppendChild($new)
$xml.Save($xfile)

 

 

Leave a Reply