GHOST CLEANUP ??

GHOST CLEANUP

INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.

  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers

These is the process which can’t be stopped. If you restart your server without knowing what this is, your efforts would be totally waste. Once the sql server comes up, you will again see them. So the question is what exactly GHOST CLEANUP is.

When any record is deleted then on the page header the bit is changed only and record remains there. This record is marked as GHOST record. This way your delete process is fast. GHOST CLEANUP is an internal DB engine mechanism which starts later on and delete these records.

If you see that GHOST CLEANUP is running it means that records are getting deleted physically which have been marked GHOST some time back.

Regards,
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com

Advertisements

3 comments

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s