We have 96 physical cores and 192 logical processors.

Yes, we are seeing sporadic pfs/sgam wait types.  We currently have 40 TempDB data files.  We are thinking about going up to 48.

Yeah, we tried an INSERT trigger on that DMV but apparently you can't put a trigger on a DMV.  🙁

So for a multi-instance cluster(s) like this I run the SP3 once and it will update all of the instances, or do I run SP3 three times, once per instance?

Memory = 2TB

Fill Factor = 75 because our system (OLTP) is so active (3500 transactions at any given time) that indices get highly fragmented (like over 90%) daily.

No, we're still updating the stat several times per day.

Unfortunately we are seeing the exact opposite. We accidentally altered our index maintenance job so since late March we've only been defragging about 20% of our indices. Since...

How is IO increased?

Thanks guys! That's exactly what I was looking for.

We've discovered a bug with AGs. The first time it occurred after a fail over the SQL Agent jobs on the secondary kept executing even though they were disabled. A...

Yes, that will take care of the service, but how do I run that automatically on failover?

Where would I find this?

It is set to "Quit the job reporting failure".

No, I'd like not just the first 50 characters but all of the characters in the field. I'd like the first 50 characters, then a carriage return, the next...

Nope, didn't help unfortunately. Here's the query, if that helps.

selectcast(A.name as varchar(30)) as User_Name,

cast(A.type_desc as char(15)) as Account_Type,

A.create_date as Date_Created,

case is_rolemember('appconfiguration',A.name) when 1 then 'appconfiguration |...