Post reply

Select blocked sometimes

  • June 29, 2012 at 6:28 am

    #260658

    Hi,

    Sometimes, some action, triggered for someone blocks the database, in other words, querys that should be executed quickly, takes too long.

    Question:

    Is there some tool that could help me to find the "why"? Profiler?

    I know this problem could be related to Transactions, but how to know?

    Tks

  • June 29, 2012 at 6:50 am

    #1507104

    how big is the table ( no of columns and records)?.

    index details?

    update and select are happening frequently?.

    Regards
    Durai Nagarajan

  • June 29, 2012 at 7:21 am

    #1507125

    denisribeiro (6/29/2012)

    Hi,

    Sometimes, some action, triggered for someone blocks the database, in other words, querys that should be executed quickly, takes too long.

    Question:

    Is there some tool that could help me to find the "why"? Profiler?

    I know this problem could be related to Transactions, but how to know?

    Tks

    Sorry, I did not get your question that you want to know the query creating blocks or why that is creating block ?

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
     🙂

  • June 29, 2012 at 9:03 am

    #1507164

    I want to know where do I have to start to know why this specific query is takes too long to execute sometimes.

    I dont know if there is a block, how to get it?

  • June 29, 2012 at 9:23 am

    #1507174

    Try that in SP_who2.

    Regards
    Durai Nagarajan

  • July 3, 2012 at 2:00 am

    #1508049

    Using profiler will give you a good way to find long running queries.

    The standard tsql_duration template should be fine.

    Just start running it. You can filter the data collection using the "Column filters..." on the "Events Selection" tab.

    Running profiler will use system resources. Please keep that in mind.


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

  • July 3, 2012 at 6:31 am

    #1508202

    I think Profile will be the best... will use it.

    Tks.

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

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