Post reply

Table is loading for long time and becoming time out?

  • November 28, 2012 at 4:54 am

    #393683

    Hi Friends,

    I have a table just containing 150 records and when i select the table it is keep executing for more than 5 minutes. The table was working very well since last night but today i got screwed up. so gimme your suggestions what might be the possible problem?

    any suggestion would be really appreciated

    Thanks,
    Charmer

  • November 28, 2012 at 5:08 am

    #1563035

    Did you check there is any session is blocking select query?

  • November 28, 2012 at 5:32 am

    #1563049

    dbasql79 (11/28/2012)

    Did you check there is any session is blocking select query?

    Yes, i checked for the blocked session ID with the help of select queries as well as the activity monitor...

    but found nothing...

    Thanks,
    Charmer

  • November 28, 2012 at 5:40 am

    #1563053

    Can you post the wait_type your select session is hanging on?

  • November 28, 2012 at 5:46 am

    #1563059

    also post the query; you might have an accidental cross join or something, so your 150 rows is actually billions of rows by mistake.

    a little peek might explain it better.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 28, 2012 at 5:54 am

    #1563064

    Hi,

    My query is just simple select statement....select * from table....like that

    i used this " SELECT * FROM sys.dm_os_wait_stats" statement but i am not sure which one is the result...

    could you help me to find out?

    Thanks,
    Charmer

  • November 28, 2012 at 6:03 am

    #1563067

    ok, does select * from table have any text or varbinary columns that are huge in size?

    can you get teh actual exection plan and post it?

    when that query is running, in another connection did you run sp_lock or sp_whoisactive to look for blocking ?

    when was the last time DBCC CHECKDB('db name') WITH NO_INFOMSGS, ALL_ERRORMSGS was run ?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 28, 2012 at 6:40 am

    #1563094

    Lowell (11/28/2012)

    ok, does select * from table have any text or varbinary columns that are huge in size?

    No text or varbinary datatype

    can you get teh actual exection plan and post it?

    i have attached it..Please take a look at it...it is straight forward plan..

    when that query is running, in another connection did you run sp_lock or sp_whoisactive to look for blocking ?

    when was the last time DBCC CHECKDB('db name') WITH NO_INFOMSGS, ALL_ERRORMSGS was run ?

    Sorry Lowell....i ran the sp_lock but i don't know how to check for blocking...and i don't know about the DBCC checkDB .....

    so please bare with me and help me to find out the problem...

    Thanks,
    Charmer

  • November 28, 2012 at 8:03 am

    #1563175

    There must be another process blocking your query. That's the only thing that makes sense.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 9 posts - 1 through 8 (of 8 total)

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