j21283 (5/25/2016)

---

I'm hoping some folks might be able to help out with a poor performance situation for our SQL server.

We recently did a major system upgrade from SQL 2008 and Windows 2008 and Xenserver to:

SQL 2012 R2 (build 11.0.6020) 21GB max memory, 24GB total

Windows Server 2012 R2

Xenserver 6.5 (build 6.5.2.2477)

After upgrading we are getting user complaints and noticeable slowness\time outs at our more peak times of use. Looking at DMV's most of our wait times center around the following:

BACKUPIO

WRITELOG

ASYNC IO COMPLETION

Looking at the virtual file stats DMV I am noticing read and write latency across multiple files:

Master DB Log File - Read Latency 191ms, Write Latency 8ms

Temp DB Data File - Read Latency 21 ms, Write Latency 98ms

Production DB Data File - Read Latency 121ms, Write Latency 38ms

Production DB Log File - Ready Latency 331ms, Write Latency 12ms

The data and log files are on separate RAID 10 disk groups on the SAN - however the tempdb currently resides in the same disk group as the data drive does - however we don't have another disk group to allocate tempdb to - only other option would be the disk group where all the server OS's are located.

I'm looking for some advice to narrow down where the problem might be at - whether SQL or SAN/Citrix Performance Issues.

Thanks,