In SQL Server Activity monitor I am currently seeing very high Batch Requests per second - fluctuates from 1200 - 2000 Batch Requests/sec - The cpu usage is not very high on the box - it is around 18%. The network I/O is also not very high. It is fluctuating between 100-150 in Recent Wait Time [ms\sec] - Not very much activity going on when I look at sp_who2 Active - just a few calls for FETCH API_CURSOR
Has anyone else had this issue and what can be done for me to pinpoint the exact issue going on here.
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.