Memory Performance

select * from master.dbo.sysperfinfo where counter_name like ‘%server memory%’

exec sp_configure ‘max server memory’, 3072
reconfigure
go

exec sp_configure ‘min server memory’, 0
reconfigure
go

Update me when site is updated

One Comment to “Memory Performance”

  1. Alex 28 January 2010 at 8:53 am #

    sp_configure ’show advanced options’, 1;
    GO
    RECONFIGURE;
    GO
    sp_configure ‘max server memory’, 16384;
    GO
    RECONFIGURE;
    GO
    sp_configure ‘min server memory’, 8192;
    GO
    RECONFIGURE;
    GO


Leave a Reply

You must be logged in to post a comment.