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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
iscivanomarAuthor Commented:
Thank you all, this was helpful .
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.