Are others experiencing similar issues?
Is your version of SSMS compatible with your version of Apex?
Is your SSMS version the same as the SQL Server version you are connecting...

I've also seen this issue when I leave SSMS open for weeks at a time or when my system gets low on resources.  You say you have 8GB of RAM...

I think like Grant said, I'd test the restore.  Go with the assumption of worst case scenario:
the VM gets corrupted

Time how long it takes from getting your...

I'd look at what is causing high CPU.  is it SQL or something else?
If it is SQL, I'd start by looking at what is running on the SQL instance....

That looks right to me.
A few things to check though:
1 - remote desktop into the physical/virtual machine hosting the 2012 instance (the machine that you are trying to...

I think it depends on what the processing is actually doing.  SQL does some things really well, others poorly.  C# does some things really well, and some things poorly.

I think knowing what you are trying to accomplish would be a good first step.

That being said, you can make a FK point to any PK.  So there...

Not sure what "best practice" is, but we swapped windows defender out for a more enterprise ready antivirus and then set up ignore rules on the databases as those get...

To clarify, when you say "16 GB" is that the memory allocated to the resource pool or to the Server?

Does your resource pool have enough space for that...

Another thing to watch for is Windows "Available" memory vs "Free" memory.  Available memory is Free + Cached and Cached doesn't get cleaned up all that quickly unless there is...

What tools are you using to build this out to display to end users?  And does the formula table change often?  If the formula table will change very infrequently or...

I am fairly confident that subscription processing is done in parallel.  We have a lot of report subscriptions that occur in parallel.

Is the 16 GB of RAM for...