Post reply

Queries running slow

  • September 27, 2010 at 8:58 am

    #72941

    Every time I'm trying to run a query it is taking too long to run the simplest query, in order to run the queries, I have to go to the Activity monitor and kill off processes that have been sitting even though they are not running. Is there a way the processes can be killed off when they have finished executing?

    Thank you

  • September 27, 2010 at 10:45 am

    #1227817

    I don't think killing processes is the right approach here or in most other scenarios.

    What processes do you usually kill and what status those are at?

    You should run profiler to see what's causing the delay. You might face blocking/locking situations.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • September 28, 2010 at 9:00 am

    #1228453

    LutzM (9/27/2010)

    I don't think killing processes is the right approach here or in most other scenarios.

    What processes do you usually kill and what status those are at?

    You should run profiler to see what's causing the delay. You might face blocking/locking situations.

    An example of a query that I'm running which takes about 17mins to run instead of just few mins is:

    select * from supply

    inner join supplydates on sd.orderno = sc.orderno

    please find the execution plan, which might give an indication on how the query is getting executed.

  • September 28, 2010 at 9:23 am

    #1228468

    Am I the only one NOT seeing a plan in that excel file??

  • September 28, 2010 at 10:11 am

    #1228503

    Ninja's_RGR'us (9/28/2010)

    Am I the only one NOT seeing a plan in that excel file??

    The file attached is the results of my query of the execution plan, that's the only way that I can get the results, as far as I know this is the only way that it can be done in sql 2000.

    Thank you

  • September 28, 2010 at 10:21 am

    #1228510

    not quite...

    SET SHOWPLAN_TEXT ON

    GO

    SELECT * FROM dbo.sysobjects

    GO

    SET SHOWPLAN_TEXT OFF

Viewing 6 posts - 1 through 5 (of 5 total)

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