how to add a Table to SQL Server 2008 Maintenance Plan

The database keeps growing and growing in memory until it gets full and no more messages can get process.
sqlServer-Memory.png
iscivanomarAsked:
Who is Participating?
 
Ramesh Babu VavillaCommented:
you can use sp_confiogure

USE master
EXEC sp_configure 'max server memory (MB)', 64
RECONFIGURE WITH OVERRIDE


check this for more info
http://www.teratrax.com/articles/sp_configure_max_memory.html
0
 
Ramesh Babu VavillaCommented:
it is the default methodology of SQL Server 64 bit . and over all memory is consumed by the buffer pool in SQL server, check the memory occupied by using  
DBCC Memorysstatus

you can use perfmon counters to monitor the sql server.

if available MBytes are less to 10 % of installed RAM. i mean if your server has 4 GB of RAM and available MBytes should not be less than 400 MB,


if you want to restric the memory,


open sql server managerment studion
right click on server-> Properties-> memory _

set min and MAX memory ,
by default MAX Memory is 2 TB
0
 
lcohanDatabase AnalystCommented:
0
 
iscivanomarAuthor Commented:
Thank you all, this was helpful .
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.