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.
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.