I'm running a pretty complicated query on a pretty large PeopleSoft database, and am having problems with the query taking a long time due to going into SUSPENDED status with a Wait type of SLEEP_TASK.
Everything I've looked at seems to say this type of wait is just normal, and its doing something it should - but the behavior doesn't seem right. For example, if I just run the query in ISQL, it starts returning data fairly quickly. If I run
it on the server, I start getting rows back in about 10 seconds. However, the rows of data kinda seem to trickle in. All in all, there are about 20,000 rows returned. Even though I start getting data in 10 seconds, it will take 30 minutes
or so for the query to complete as it continues to move to the SLEEP_TASK status and and stop returning data.
Can anyone give me some good ideas on things to look at here - or at least some examples of what that type of wait might really be waiting on? There can certainly be some contention on the system, but nothing shows up as blocking this query.
View Complete Post