• Kevin,
    May I please ask you to clarify some of your your comments.

    1) Any time I see nvarchar(4000) parameters I think ORM, mismatched data types, and a butt-ton of CONVERT_IMPLICITs with their correspondingly horrible performance and concurrency issues.
    What are you talking about?
    What nvarchar(4000) parameters ?

    2) You clearly have repeated complete buffer flushes. That's brutal.
    How did you find it out?
    If that's the case, what is the impact on performance?
    How to find out what's causing buffer flushes?

    3) Solarwinds is aggregating all IO stalls into 15 minute buckets. Your graphs just show latency, not how many things were running concurrently and collecting fileIO stalls. Just yesterday I captured a 180 SECOND run of IO stalls on a client and they totaled a mind-blowing 2.5 MILLION MILLISECONDS in duration!!! That is 28.94 DAYS of IO stalls in 180 clock seconds!! Guess what, you can't run almost 2TB of BUSY and REALLY BADLY DESIGNED AND CODED OLTP databases with 2 synchronous AGs for each database on a four 6-disk RAID10 sets.

    Are you referring to your client's case?
    Ours is not 2TB, it's 3TB OLTP database.
    I also have no clue what disks we use.
    All I know it's SAN storage. Nimble system.