January 13, 2011 at 1:49 pm
Hello,
I know what is GhostCleanUpTask. But my question is how to prevent it from running every 2 minutes? I surfed on the internet and found that if you have SP2 then it should only run every 15 minutes, but it is not true in my case.
Secondly, why is it running only on some databases and not others. Again googling shows that a possible cause could be auto shrink set to true on those databases. But I found that is not the case. So following are 2 questions:
How to prevent GhostCleanUpTask from running every 2 minutes or how to increase the run time?
Why is it running on some databases and not others?
Thanks.
January 14, 2011 at 9:45 am
Is there any one who knows this?
Thanks.
January 14, 2011 at 10:45 am
Why are you so concerned about the ghost cleanup task?
Ghost cleanup runs in the background at regular intervals. As you stated, frequency depends on the version of SQL you are using. Additionally, when the engine reads in a page with ghost records on it, it triggers the ghost cleanup to run. So if it is running every 2 seconds, then it is being triggered by scanning pages that have ghost records. In other words, it's running more often because it needs to try to keep up with the number of deletes that are occurring.
For the most and best info on ghost cleanup, read Paul Randal's blog: http://www.bing.com/search?q=ghost+site%3Asqlskills.com&form=QBLH&qs=n&sk=&sc=8-24
January 14, 2011 at 11:53 am
I am concerned because ghost cleanup is running on databases that does not have any activity what so ever. These are dead dbs and yet ghost cleanup is running on them.
January 14, 2011 at 12:10 pm
Are you sure there's no activity? I've heard similar reports before but when I looked into it, they had a data archive job that was still running daily and they didn't think to look for SQL jobs or Windows services running that might hit them.
You can verify activity (or lack thereof) by checking sys.dm_db_index_usage_stats.
You can also check out ghost record and version ghost record counts in the database with sys.dm_db_index_physical_stats.
January 17, 2011 at 8:41 am
You are right. A scheduled is running against such databases.
Thanks.
January 17, 2011 at 8:50 am
You're welcome!!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply