in addition to setting up delegation, I disabled the named pipe protocol on SQL server and it works perfectly

I've found something that may explain about the issue

http://sqlserverpedia.com/blog/sql-server-bloggers/spcachemiss-explained/

I have same problem with cachemiss occurs with sp even though the sp does not start with sp_ and it is called the same everytime.

Putting an adhoc query right after...

Thanks for the articles.

However, when I run the same SP a couple times, I see a cache miss right after cache hit and the usecounts in syscacheobjects does increase.

Everytimes I...

Reporting Service has problem with sending report as attachment. If I select send as link then there is no problem