@BlobEater????

[TerpFan2001]

We have been performing a performance audit on our SQL Server and the following came back as a high response query:

SELECT @BlobEater = CheckIndex(FactKeyA + FactKeyB + Facts)
FROM (SELECT TOP 100 PERCENT FactKeyA, FactKeyB, Facts
FROM { IRowset 0x18A7F13E }
ORDER BY FactKeyA, FactKeyB) as SortedFacts
GROUP BY FactKeyA OPTION(ORDER GROUP)

Does anyone know what this is? Or if it can be turned off?

 

[SQLSister]

The only thing I could find on this was this link, but it really doesn't shed much light except that it appears to be executed as part of the maintenance plan.

http://www.sqlservercentral.com/columnists/awarren/sqlmaintenanceplansunderthecovers.asp

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[TerpFan2001]

Thanks, I saw that article. I'm not sure what this thing is supposed to be doing, but it is impacting performance.