PowerShell™ for SharePoint® 2013 How-To

Throttle Access Services Memory Utilization

Scenario/Problem: You want to modify the amount of memory that Access Services can utilize.

Solution: Use the PrivateBytesMax parameter with the Set-SPAccessServiceApplication cmdlet.

By default, Access Services is configured to use up to 50% of the physical memory of the application server that is hosting the service application. This is denoted by a -1 value for the Maximum Private Bytes setting. To change this value, you can use the PrivateBytesMax parameter with a value between 1 and the maximum amount of physical memory available. Listing 23.13 shows a sample modification of memory usage using the Set-SPAccessServiceApplication cmdlet.

Listing 23.13. Modifying the Memory Usage of Access Services ...