Thanks Eddie.  That's helpful,  Much appreciated.

SQL Pirate, That was the answer to my specific question, so thanks.  

Jeff, I've frequently had to use the SET SINGLE_USER WITH ROLLBACK IMMEDIATE phrase but I'm not...

Phil,  Thanks for that query.  I've used that approach before on other things, I just didn't think of it this time.

SSISDB did not create successfully after that error.  The error prevents the wizard from finishing. I next looked to see how long the password was.  It was longer than I...

Yep Phil.  L is a local drive.

And this is why I like forums and reading what other people are doing!  Thanks so much Lowell.  Much simpler solution than the road I was on.

Lowell, thanks for the reply.  The process isn't even getting far enough to start the job that executes a PowerShell command inline in the job.  It gets an error when...

If we just add the machine to the Windows cluster, but not the SQL Server cluster, will that create a problem?  I just wasn't prepared to add the node to...

I eventually found an answer here: http://www.widriksson.com/ssrs-scale-out-deployment-configuration-error/

I just needed to delete the entry from ReportServer.dbo.Keys that was related to the old SSRS instance.

Someone previously mentioned SolarWinds, which is a good product.  They actually have two database monitoring products.  You can register SQL Server instances in SolarWinds SAM (Server and Application Monitor) and...

SolarWinds DPA shows you what is going on in your server at any given moment.  Since you have very large drops in PLE, correlate that to the queries that DPA...

Stephen,

Can you provide queries to the application care takers and ask them to run them right after a problem is reported?  If so, you can offer them something...