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
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