Were there any server changes? Are there new instances? Did your hardware change?

Do you have any server monitoring set up (not just sql monitoring)?

Is your CPU/Hard Drive/Memory bottlenecked?

Have you checked...

1 ip will work. I have two AG's with the two listeners on the same IP.

Here's a good article that I used to set up Alerts. This may be better than scanning the server log.

http://sqlmag.com/blog/alwayson-ags-and-sql-server-jobs-setting-failover-alerts

So, no resolution yet guys so I've decided to just Step Over those dynamic sql statements for now. It's not a resolution but at least it doesn't freeze.

Just a question, if you're using 2014, why not use the backup encryption provided?

Perfect, thanks all.

Hey Guys,

I didn't get an answer here so I'll answer my own question for those of you who are curious. I went ahead and did the decryption last night after...

Did that, there were...

This is great advice, thanks a bunch.

Thanks for the information. So it sounds like contracting through a company may be the way to go as I'm only expecting a max of 10/hr per week. Is there...

You can do it with a powershell script. Are you not wanting to link the servers for a specific reason? Like security vulnerabilities?

You definitely need more counters. I would run 8k, 16k, 32k, 64k, 128k sequential and random reads/writes to evaluate the performance. From my initial view, it looks great but running...

Using SSDT - Analysis Services project - Right clicked the entire project which contains all cubes and selected process. So I believe it would be default as I made no...

Just so you know, one of the purposes of a left join is to return results (NULLS) when there is no corresponding data in the joined table. Sounds like you...

Not sure who says that, but that's not a good idea.