Monday, March 30, 2009

Configuring sqlsrvr.exe process memory usage on ISA server

If sqlsrvr.exe process is using huge amount of memory you can follow steps below to limit memory for this process.
Install SQL Server Management Console on ISA Server then;

Execute the following command on Management Studio;

EXEC sp_configure 'max server memory (MB)', 1024 \\ Memory in MB

USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE

USE master
EXEC sp_configure 'max server memory (MB)',1024

USE master
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE

No comments:

Post a Comment

 
span.fullpost {display:inline;}