Post reply

SQL 2005 Reports Server - Determine what report is hammering my DB server

  • August 6, 2009 at 4:21 pm

    #133794

    OK, here's the situation. I have a SQL 2005 SP2 Report server (SHOWMYSTUFF) and a SQL 2005 SP2 DB server (ALLYOURSTUFF). The report server has, we'll say 8 reports that hit's the same DB Server and the same DB name called WHOSSTUFF.

    My question is, how can I determine which report has my SQL DB Servers CPU pinned to 100%?

    All connections show in "Activity Monitor" as the Report Server SHOWMYSTUFF. I can derrive the connection that eats up my CPU but that doesn't tell what report ran that may have a mathmatical flaw or an infinate loop.

    Thanks

  • August 7, 2009 at 12:23 am

    #1035797

    Run a trace against your db server and the CPU column will show CPU resources consumed. The textdata column will show what is being executed and you should be able to figure it out from there.

    Alternatively, right-click on the server name in SQL Studio and select Reports and click on "Performance - Top Queries by Average CPU Time" and it may show up in there.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply