| Tibor Karaszi 2002-10-31, 1:23 am |
| This was spid number 6, right?
This process does a few things. One thing is that it compresses the data on pages after DELETE
statements have removed rows on the pages. This is also responsible for shrinking database files
(for instance if you have autoshrink turned on).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Sanjayg" <sanjayg@hotmail.com> wrote in message
news:104c01c2805d$e10af220$37e
f2ecf@TKMSFTNGXA13...
> I saw a backgroup process running and COMMAND in sp_who2
> output was GHOST CLEANUP
>
> Can someone explain what exactly that means
> If someone could explaing exactly what functions do these
> background processes perform that would help too
>
> sanjay
|