Sorry for late reply but limiting the RAM in SQL server management Studio has fixed the issue

🙂

Thank you so much guys

Ahh ok

So I have set it to use max memory of 7GB

Lets see what happens

@ Gila

I am reading through that chapter right now

@Arjen

I guess I might be over thinking about it too much

I don't know how much memory it was...

@ Arjen

Principle server sits at around 7GB and goes up and down but never to extreme as the SQL Mirror

Only things I have changed recently was the one...

Thank you for the response and links

I will take a look at them here soon.

I forgot to mention that this server acts as a sql mirror which...