The last one might be heped by trace flag 4199. You can apply it to individual queries with option (querytraceon 4199):
https://blogs.msdn.microsoft.com/psssql/2010/09/01/slow-quer...
https://blogs.msdn.microsoft.com/psssql/2010/09/01/slow-quer...
No comments yet.