Never mind i found the solution

Granting access to the master db it didn't work

They are not viewing query store, this is from a user db which they have db_owner permission but below erro

No permission on master but i will give it a try and feedback if all working

Thanks for the advises

The maintenance is done well on my side. The puzzling thing is after the OS upgrade on non-prod env i'm having this issue of tempdb...

Hi, 

Isn't based on the number of processors on the box to create the same number of tempdb data files? I guess will have to up the disk size...

Would be great to hear what would be the best specs

I hear you but my problem is that I did mention to powers that be but it has fallen to deaf ears, I have to make mini cooper pull a...

@Gail, what else to look for?

I've been monitoring the load on the VM and noticed the CXPACKET wait was too high, so for now I have changed the maxdop to 1 and cleared the waits...

Microsoft stated I should use my old SSMS 2008 as there's no solution or just update the SSMS with 2014SSMS but introduces other errors

SSMS 2008 works fine

Hi All,

Thanks for your response. To answer a few

The VM is hosted with other VM's running on the same tin of which I dont have the number of other vm's...

Thanks sorted

Apologies missed the script attachment

Thanks, will give it a try. I also use 2012 Data Tools