October 11, 2015

MS SQL - Instance level memory limit

Issue: Multiple sqlservr.exe processes use all RAM on server (SQL Server 2008 R2).

If you have more that one SQL Server instance you will see multiple sqlservr.exe processes in task manager.

"tasklist /svc" command can be used to determine SQL Instance name and its process id.

Then you can run "SQL Server Management Studio" and set a fixed amount of memory to instance which you want to limit RAM usage.

No comments:

Post a Comment