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
Monday, March 30, 2009
Configuring sqlsrvr.exe process memory usage on ISA server
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment