September 19, 2013 at 10:47 am
In our enviornment we have encountered recent SQL connection issue which lasted from 10 seconds to 2 mins .
Observations:-
1. Nothing funky was going in SQL just before the connection issue started .
2. As SQL refuses connection so our monitoring tool can't connect during that time to report the cause .
3. Memory might be one of the reason but it was not triggered by any SQL query .
4. I set some counter to isolate the issue and cause .
Below is the counter history which shows that when Page/sec and Page Reads/Sec spiked at 2:35pm as in example here .
CST Page Faults/sec Page Reads/secPages/sec
9/18/13 2:34 PM4965.794570.1333618340
9/18/13 2:34 PM4318.3830211.4998320230
9/18/13 2:35 PM22507.73607441.65377642577.672614
9/18/13 2:35 PM54878.84902813.05829283594.619162
9/18/13 2:36 PM35788.83947804.74870494166.690995
9/18/13 2:36 PM41066.90062917.27417823384.964632
9/18/13 2:37 PM7825.4449061081.1251761581.255276
9/18/13 2:37 PM1589.648151222.67808093392.37389
9/18/13 2:38 PM6247.529166513.32570951567.539806
Can anyone give direction to troubslehoot how I can fix this issue or to capture which process can cause this spike as if not SQL .
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply