SQL Server Performance

Wait_type of SLEEP_TASK and SUSPENDED Status

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by gujsa01, Jun 10, 2008.

  1. gujsa01 New Member

    Hi,
    One of the queries in our Timekeeping application (vendor app) takes around 4 mins to complete from the application Interface. Ran this query in Query Analyzer, runs immediately.
    Vendor app details:
    JBOSS using JDBC running on Windows 2003 SP2 with IIS . SQL Server 2005 SP2 64-bit.
    Looking into the waiting tasks and requests, found the following:
    wait_type = SLEEP_TASK
    wait_duration_ms = 0
    status = SUSPENDED
    The status changes to RUNNING which triggers the wait_type to change to PAGELATCH_EX ( buffer latch for I/O from disk to memory) for a brief second and then back to SUSPENDED mode. I don't see any CPU pressure and also the statistcis on the query are updated daily. Indexes are well defragmented.
    I'm trying to understand the SLEEP_TASK / SUSPENDED issue...
    Appreciate any help.
    Thanks
  2. techbabu303 New Member

    What type of JDBC driver does JBOSS version use ?
    This looks more like issue from access method and driver used as you mentioned the same query perfroms faster with ISQLW.It would'nt be bad idea to check with JBOSS or Application developers.
    Cheers
    SAT
  3. gujsa01 New Member

    Appreciate your response. Probably can try vendor's point of view..
    Thanks!

Share This Page