In case nobody wants to download the file, this is the content (I viewed it safely):

SELECT TOP 25
 
dm_mid.database_id AS DatabaseID,
 
dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,
 
dm_migs.last_user_seek AS Last_User_Seek,
 
OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id)...

Just to add to hmbacon's reply, sometimes the problem isn't found during the deployment. I've had problems found days or weeks after deployment. Rolling back in those scenarios can be...

You asked if we got "desired results" - what results were you desiring? Are you looking for performance gains (or losses)?  If so, turning compression on across the board will...

• This reply was modified 2 days, 6 hours ago by Mr. Brian Gale.
• This reply was modified 2 days, 6 hours ago by Mr. Brian Gale.

Just to add to what deubel_m said, Ola's scripts are not managed, maintained, or supported by SQLServerCentral. SOME users of this forum use them and can offer advice about them,...

My opinion - if you don't have access to their systems, that means it is not your problem. You can't see how they have their script configured plus I doubt...

Another thing - like Steve Jones said - having the API server just moves the load. If the API server caches things, you run the risk that the API server...

Another question for you is what problem are you trying to solve and how will you know it is solved? "Too many connections" is very arbitrary and not helpful. BUT...

Probably a dumb question, but you created a key correct and updated the instructions to use your key not the example one they have in their sample scripts, correct?

What I'd...

Also, just to confirm but I suspect you are right with the CASE statement, but is it the CASE statement or the date comparison that is slow? If it is...

Probably a few dumb questions but:

1- did all of the installs succeed or did any give errors?

2- you installed the connectors on your local machine AND the server, correct? Local...

I was reading up a little bit on this and it's not the greatest news for sure. PBIRS requires a PBI Pro license to develop reports and that doesn't come...

My advice - check all of the logs. On the primary and on the secondary. The SQL logs, the event logs, every log you can find. Start with the Cluster...

Sounds like a bug to me. I'd reach out to Microsoft about it and see if there is a fix or known workaround.

That being said, looks like someone reported this...

With what you confirmed through testing, I would personally confirm in logs. There should be a log on one of the systems (gateway, SSAS, SQL) that indicates what the problem...

My approach is similar to Steve Collins'. I like stored procedures to handle database logic that doesn't need to be in the application layer. SOME things belong in the application...