Hi , we are supporting the MOSS Medium server farm.recently we found onissue MOSS query has blocked in MOSS PRD database server and could find based on the site id ,one of the site collection that was having huge content causing the issues. please provide any pointers how to addrees this issue. Here is the query that was blocked: select,AllDocStreams.Id,AllDocStreams.SiteId,AllDocStreams.DeleteTransactionId,AllDocStreams.ParentId,AllDocStreams.Size,AllDocStreams.Level,CASE WHEN DATALENGTH(AllDocStreams.Content) > 5242880 THEN 0x0 ELSE AllDocStreams.Content END, DATALENGTH(AllDocStreams.Content), AllDocs.DocFlags FROM AllDocStreams LEFT OUTER JOIN AllDocs ON AllDocs.Id = AllDocStreams.Id AND AllDocs.Level = AllDocStreams.Level WHERE (AllDocStreams.SiteID='xxxxxxxxxxxxx'

Is that a MOSS query or customized SQL? AllDocStreams stores the actual document content. This query is reading the content of documents < 5MB in the site collection. The options are either reduce the size of the site collection or refine the query.-Bin