So no way to fix it with less blood?

I see only one way for now - replace most used requests to be in the Stored Procedure.

Alex.

Plans are exactly the same, only difference in CompileTime, CompileCPU, and GUID parameter, both plans attached.

Is it possible there some other options on the database level which I missed or...

I posted exact SQL query which can not be auto parameterized. It's not use anything restricted.

I found another info here

http://technet.microsoft.com/en-us/library/cc966425.aspx

SQL Server's LPE (Language Processing and Execution) component auto-parameterizes...

Nothing look fishily, I will monitor SQL instance and will add more info.

Thanks, guys.

"Most queries by CPU time" tsql not help, because in this time almost all queries work long, very very long time , It seems I need first query which started...

It seems SQL server worked ( I see records in the dm_exec_query_stats for this time) , but quries worked slow and applications generated timeout errors.

So real question : Is it...

Any ideas? Maybe anything related, so I will try to do more investigations. Please....