CODEWITHSUNDEEP
sql-serversql-server-2008
George2
George2

Reputation: 45771

how to configure SQL Server max memory usage

I am using SQL Server 2008 Enterprise. SQL Server 2008 always tries to eat as much as memory as it could. Any ways to configure per database or per instance or per server level max memory usage of SQL Server 2008?

thanks in advance, George

Upvotes: 0

Views: 2317

Answers (2)

phoebus
phoebus

Reputation: 14921

The purpose of memory is to be used to speed up data access, not to sit around looking pretty (and empty). SQL Server should use as much RAM as it can get its hand(les) on for caching in order to make the best use of available resources.

With modern server applications it's best, 99.99% of the time, to let them manage their resources as designed.

Upvotes: 1

gbn
gbn

Reputation: 432210

Are you sure?: SQL SERVER 2008 - Memory Leak while storing Millions of records

If you really must:

sp_configure 'show advanced options',1
reconfigure
GO
sp_configure 'max server memory',100
reconfigure
GO

Upvotes: 2

Related Questions