Yes, it makes no difference.

Wow, checked last week - nothing. Great stuff I'll do that.

Hi,

The log drives are faster 4TB NVME Intel 3700 flash cards, so I doubt that can be the problem.

The index jobs are the same (Ola Hallengren).

In the meantime I...

Hi,

The setup as follows:

There are 2 servers in the setup, placed approx 100 meters apart in 2 different buildings.

Both the client and Sync is on 10Gbe network.

Availability mode is...

Hey guys,

This has been sorted out. Ended up building a new AG from scratch.

I have AlwaysOn availability group

I just found this:

use afregndb

go

select * from dbo.sysusers

where [name] = '\SW'

Returns a result - however it's not aliased.

If I try to create a login with the same SID I get...

WUPTI 😀

Great - that worked - got another error, but I know how to fix that.

Thnx a million.

I have done some performance tuning for an electricity company, where we did the following - and got heaps of extra performance:

1. Created 2 filegroups and split into 9 files on...