Random SQL connection drops .

• SQL Severe DBA

  Hall of Fame

  Points: 3579

  More actions

  September 19, 2013 at 10:47 am

  #298941

  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 .