Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

how to add a Table to SQL Server 2008 Maintenance Plan

Posted on 2012-03-16
4
190 Views
Last Modified: 2012-08-14
The database keeps growing and growing in memory until it gets full and no more messages can get process.
sqlServer-Memory.png
0
Comment
Question by:iscivanomar
  • 2
4 Comments
 
LVL 10

Assisted Solution

by:sqlservr
sqlservr earned 334 total points
ID: 37729897
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
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 166 total points
ID: 37730473
0
 
LVL 10

Accepted Solution

by:
sqlservr earned 334 total points
ID: 37730696
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
 

Author Closing Comment

by:iscivanomar
ID: 37731333
Thank you all, this was helpful .
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question