I experienced performance regression after a migration project due to differing collations between the source database and tempdb. As I prepared the Server for the Migration I forgot to...

Now I understand a Little more now that I know that the database Needs to be online 24x7x365.

What your employer is asking for is unrealistic and unreasonable under the circumstances....

paul.s.vidal (12/27/2016)

---

I already have the mirroring in place.

But in order for me to do maintenance i need to break mirroring and keep both databases open.

One database will be live...

paul.s.vidal (12/27/2016)

---

Agree with the previous answer, but also you can have an standard edition and use mirroring. The only thing you can't use some of the best features like, partitioning,...

Beatrix Kiddo (12/19/2016)

---

I think it should be ok, but are you planning to leave your DBs in the AGs for the duration? Keep an eye on the transaction logs if...

I normally never recommend an in-place upgrade due to the problems that can occur if it goes wrong.

The only exception is when it is a VM and that VM can...

It is possible that there are alternative 3rd Party Tools for mirroring but seeing as you have Enterprise software running you have it for free anyway and it is IMHO...

I wonder if the server was upgraded in-place from a lowerer version. My understanding is that the databases retain their collation and the instance will be upgraded.

My train of...

If it is a recent development I would suggest having a look at the changes made around the time that the "Problem" started occuring.

Chatting with the developers responsible will help...

My only option is to have to pull data directly from cassandra. I can't use any interface layer or staging for reporting.[/Quote]

Is there a technical reason for this or...

TheSQLGuru (12/22/2016)

---

Some of the versions of Visio can do ERDs by reverse engineering an existing database. I know they removed the functionality from some versions though so be sure to...

Is replication here the best solution?

I would personally be happier with mirroring (or Always On Availability Groups if that is an Option) because all changes are mirrored at the...

To be honest I think you have absolutely nothing to worry about. I reckon when you examine PLE for the instance that it will be very high, a good...

The max and min memory settings only affects the instance itself and not Services running outside of the instance.

So the question is:

Are there alot of Long running SQL Server Agent...

Many thanks for sharing! My advice about the checkdb though would be this:

It seems like you have a very large database and doing a full CHECKDB every night might...