Wednesday, December 14, 2011

Limit microsoft##ssee memory use in sbs 2011

Open SQL management studio as and administratror. This is the 2008R2 managemange studio, you must right click and run as admin. Once at the login screen type this in as the server:
\\.\pipe\mssql$microsoft##ssee\sql\query
and connect.

Once connected right click on the sql server DB, the very top thing and select properties.

Select the memory tab and adjust the max server memory.

No comments:

Post a Comment