.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server


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

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend