Loads to the a data warehouse from source databases. I also have a 3rd party db I support with awful design (no control over it) so tempdb gets pounded.

THis is a data warehouse with monster ETL's I have seen great things about the Fusion product. The fact is it is cheaper than adding the SSD to the...

that was it thanks very much

still no traces show in query but last night of course a new trace file. No alerts trigger wonder if there is a trace flag at startup which may...

Developer changed something in SSAS to persistent state and it fixed it

max is set, I am not an SSAS expert and what it is doing to the resource instance, will start digging. Might try simple approach of having them spin...

Hope to avoid going down that rabbit hole. The whole disk subsystem is SSD, was not formatted with 64K offset like I wanted, not to sure how much that...

I vote for Idera not cheap but still the best product out there, the snapshot it takes of things tied to alerts is invaluable, I know the Tech Politically Correct...

really need to avoid the replication, this is a 3rd party app/db which is OLTP where the vendor will scream about anything outside the box impacting anything including replication. ...

Used sql safe from Idera for years, proved to be fast and reliable

so if I have node that is dedicated to the OLTP then I can not have a read only AG node? So I have to go back and ask...

main goal of AG is the read only node trying to offload some of the reporting

thanks to both, waiting on 2nd node, realize the way to do it is passive first, we got tired of waiting on 2nd node and trying to fix some issues...

that's what I want to avoid, with active/passive cluster not an issue, any hiccup with Vmotion and now my AG read only server could be hosed. Gives me one...

It is an issue of using only one solution of the two, Microsoft is pushing not to use the Vmotion with AG