How to decrease SQLSRV.exe process memory usage

On 22 November 2010, in SQL Express, by Himselff

Connect to your SQL express instance

 OSQL -E -S SERVERNAME\INSTANCE

If advance options are not enable :


sp_configure 'show advanced option', '1'
RECONFIGURE WITH OVERRIDE
GO

Run the following code, replacing the in quote data with value you need :

EXEC sp_configure 'max server memory', 'memory in MB'
GO
RECONFIGURE WITH OVERRIDE
GO
Post Views: 40
If you enjoyed this article, please consider sharing it!
Facebook Twitter Delicious Digg

 

Comments are closed.