DriveByCheckmate
Programmer
Hi everyone,
I'm having a disk queue length issue and I'm trying to figure out what exactly is causing it.
What I'd like to do is setup a performance counter so that when disk queue goes over a certain point it will start logging the SQL queries that are being executed.
Anyone have any feedback on how that could be done or maybe have a better idea? Thanks!
FYI - we're using Microsoft SQL Express 2005.
I'm having a disk queue length issue and I'm trying to figure out what exactly is causing it.
What I'd like to do is setup a performance counter so that when disk queue goes over a certain point it will start logging the SQL queries that are being executed.
Anyone have any feedback on how that could be done or maybe have a better idea? Thanks!
FYI - we're using Microsoft SQL Express 2005.