Hello Gail,

Table LOJA_VENDA has 6+ million. The plan was generated with all indexes defragmented, so I think indexing is not the problem.

Hello Grant,

I attached the files yesterday. They're in my original post.

This is really a problem. After SP3 I was getting the very same error:

DESCRIPTION:The SQL Server performance counter 'Buffer cache hit ratio' (instance 'N/A') of object 'SQLServer:Buffer Manager' is now...

So it's better not to change the server names???