• coolchaitu (7/27/2015)


    Thanks for the reply. My doubt is that why did it timeout only on that day and not on the other days?

    It's really hard to tell for sure why your query did timeout a week ago without having any information. The only thing I can see from the screenshot is that you have tempdb contention (2:1:88968 is PFS tempdb page). Please read these articles to get familiar with thess kind of issues:

    http://www.sqlskills.com/blogs/paul/the-accidental-dba-day-27-of-30-troubleshooting-tempdb-contention/

    http://www.sqlservercentral.com/blogs/robert_davis/2010/03/05/Breaking-Down-TempDB-Contention/

    http://www.brentozar.com/archive/2014/05/tell-need-tempdb-files/

    http://sqlblog.com/blogs/adam_machanic/archive/2011/04/21/analyzing-tempdb-contention-a-month-of-activity-monitoring-part-21-of-30.aspx

    Basically you need to create more tempb files to avoid this issue. But if this really the reason why the query had got timeout? Who knows. But I doubt it.


    Alex Suprun