Solved

SQL Maintenance Plan - Check Database Integrity

Posted on 2008-10-26
7
1,067 Views
Last Modified: 2012-06-27
I have a new database server with 64 Gigs Ram.
I created a Maintenance plan which runs "Check Database Integrity" every night.
When that check runs, my Ram useage goes from 30 Gigs to 60 gigs.
It then remains at 60 gigs unless I stop/stop SQL.

My question:
Is it overkill to run the checks every night?
Is it normal to use so much ram to do the checks.
Does use of that ram affect performance?  (It appears that I start getting more paging after the checks)

My system is Windwos 2003 x64  with MSSQL 2008 x64
0
Comment
Question by:superbrian
  • 4
  • 2
7 Comments
 
LVL 4

Accepted Solution

by:
randy_knight earned 500 total points
ID: 22807675
If you are seeing paging, I'd recommend reducing the Max memory for SQL Server.  How big is your database?  Your memory usage is growing because it's moving all those data pages into cache as it runs the integrity checks.

Yes, it is normally overkill to run all integrity checks every night.  However, which optiosn do you have chosen?
0
 

Author Comment

by:superbrian
ID: 22808749
This server was just setup and installed and I just created the maint plan.
There are several databases on this server totally 46 gigs.
The server has 64 gigs or ram and is dedicated to sql, so it's using more ram that the total of all databases combined.  When Sql is started (or restarted) ram usage climbs slowly to about 40 gigs then stops, until integrity checks run.
Not sure what you mean by options but it says include indexes.
I can simply set this up to run weekly, but without a sql restart it may just continue to cause paging?
As for reducing max sql memory, to what would you suggest?  60 gigs?
0
 

Author Comment

by:superbrian
ID: 22808757
I also do not have AWE enabled, I did on my prior server, since it was the only way to address over 2 gig ram.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 63

Expert Comment

by:SysExpert
ID: 22808831
THe server should be self balancing, so it really should not matter if it sits at 60 GB the whole time, as long as there is no paging to disk.

I would check the MS site for any additional info on how often  to run checks if it worries you, but if you watch long term, and no disk paging occurs, leave it alone.

just my $.02

 
I hope this helps !
0
 

Author Comment

by:superbrian
ID: 22811302
I changed the checks to run weekly, I guess I'll need to wait a week to see if the check consumes all the memory and causes paging again.
0
 
LVL 4

Expert Comment

by:randy_knight
ID: 22813639
I assumed this was a 64-bit OS/SQL Server.  True or False?
0
 

Author Comment

by:superbrian
ID: 22815152
Yes.  2003x64  sql2008x64
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Addition to SQL for dynamic fields 6 47
SQL Server tables join on parse list 6 33
SQL Insert parts by customer 12 42
Are triggers slow? 7 11
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 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