Hi Jovan,

Want to know the effect of recompile option with SP execution in these versions considering the introduction of the mentioned query plan enhancements.

Thanks...Arshad

In the query above, pls include io stall type column also and let know value ... 1 indicates pending to write on the disk.. If the same file name is...

Hi,

Thank you everybody for the valuable advices. Would like to know if it's feasible to see if one can use the statistics data in this situation. Please put some light...

As long as there are no performance issues , the tempdb activity here looks normal , as the temp tables are not pure memory only objects and hence the IO's are...

I would suggest to see if the password has been changed .And also the SPNs , which generally are causes if created from other server login script.

Arshad

Most of the time outs occurs as a result of statistics becoming stale too early due to increasing in data volume . Even if the auto update stats is...

I suggest doing a DBCC checkdb to rule

out any corruptions. Also pls check the status of the database in sysdatabases.

Arshad

Hi Sue,

Thanks so much on the points mentioned by you. Really helpful.

Thank you...Arshad

Hi Sue,

Thank you for throwing light on this. I know the 20%+500 and the other criteria for the auto update.. Now it means that even if i issue a manual...

and choose a security context to run under impersonation of the login account used to access the target server.

Arshad

If I were you , I would go with option 2 , more so considering scalability etc. .Since the SQL to SQL will have no issues due to backward compatibility...

Thank you Brandie , Jacob , Gail for such useful insights.

Thank you

Arshad

Small correction above .. over 1 million inserts are there for the table I mentioned . 

Thank you

Arshad