Post reply

Long time running query

  • November 12, 2008 at 3:49 am

    #202619

    Hi guys,

    i'm facing an issue :

    I execute a simple query, select * from mytable, and it takes 3 secondes from my computer.

    But when I execute this query on the server it takes less than a second.

    What could be the problem?

    Thank you,

    regards.

  • November 12, 2008 at 4:11 am

    #897412

    1. Server is dedicated. No other application is running on it.

    2. Different hardware. More memory, Disk, CPU, etc.

    3. Different setup. Data and log file, tempdb, etc.

    4. Index, number of rows, fragmentation, etc.

  • November 12, 2008 at 4:25 am

    #897416

    Hello Suresh,

    from my computer I execute the query to the remote server.

    It's a dedicated server.

    Logs an datas files are on separate disks.

  • November 12, 2008 at 7:10 am

    #897492

    Network latency

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 12, 2008 at 7:36 am

    #897525

    Yes that is the network setup - if it runs that fast on the server it isnt doing any additiona hops through routers and network traffic. Ask the network team to look into it and priority SQL traffic over over traffic

  • November 12, 2008 at 7:45 am

    #897536

    Ok thank you very much

  • November 12, 2008 at 7:50 am

    #897542

    Ok thank you very much

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

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