SPN's are all good , verified with Kerberos manager. Sounds like i need to enable constrained delegation which i what i am targeting towards

Not sure, how would that help in mapping a remote share? Any examples would be helpful

This is related to another post i have , copy/pasting here

"In a nutshell we have a package stored in SSIS catalogue on Server – S1 which reads files from Server...

I had to do something similar where database size was growing out of control, simple maintenance tasks were taking for ever. The sooner the better you have this implemented. In...

Works. Thank you

You can start with 48 and keep adding 4 files until you see acceptable improvement.

How many logical and physical cores do you have?  We have a 48 physical core and 96 logical cores box,  we found 48 files for us seems to be helpful....

Try server level DDL.

We were in exact same situation, i will be honest our migration was very painful. We were almost at a point where we wanted to rollback  to 2008R2 but after...

I would definitely do log-shipping any given day , you want your production and development to be isolated as much as possible. Log-shipping can be pretty much independent of the...

Define contention. Are you seeing lot of pfs/sgam wait types? Are any on your custom temdb settings still there post applying CU6?

Are you sure CNO ( cluster name object ) has enough permissions into DNS? Were you successfully able to create listener with less than 15 characters?