Max Memory Sql 2005

[AzDan]

Where and how exactly do I change the max memory in Sql 2005?

 

[mrdenny]

In the object explorer right click on the server and select properties. Memory section.

Or you can use the sp_configure procedure.

exec sp_configure 'max server memory', 1024
reconfigure

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog