?
Solved

how to add a Table to SQL Server 2008 Maintenance Plan

Posted on 2012-03-16
4
Medium Priority
?
194 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
[X]
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
  • 2
4 Comments
 
LVL 10

Assisted Solution

by:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 1336 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 40

Assisted Solution

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

Accepted Solution

by:
Ramesh Babu Vavilla earned 1336 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

762 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