Forum Replies Created

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

  • RE: Extremely slow SQL server

    John Mitchell-245523 - Tuesday, March 13, 2018 6:10 AM

    You can't just remove the cursor, because now the stored procedure isn't doing the...

    March 13, 2018 at 6:24 am

    #1982895

  • RE: Extremely slow SQL server

    Hi John

    The @@Fetch was the cursor from the query was removed, this is the original query as per the execution plan:

    March 13, 2018 at 6:01 am

    #1982889

  • RE: Extremely slow SQL server

    John Mitchell-245523 - Monday, March 12, 2018 10:05 AM

    Do you have the option to change code?  The SelectWaybillID stored procedure uses a...

    March 13, 2018 at 4:26 am

    #1982869

  • RE: Extremely slow SQL server

    Jeff Moden - Monday, March 12, 2018 11:14 AM

    You've got some pretty nasty problems.  First, your transaction log file is 2 and...

    March 12, 2018 at 1:04 pm

    #1982817

  • RE: Extremely slow SQL server

    I cannot change it myself, but I can give my recommendations to the developer and they would change it for me.
    The first query is the biggest problem, it takes...

    March 12, 2018 at 11:03 am

    #1982796

  • RE: Extremely slow SQL server

    John Mitchell-245523 - Monday, March 12, 2018 9:30 AM

    Sounds as if you may have a disk bottleneck.  But I think you need...

    March 12, 2018 at 9:53 am

    #1982778

  • RE: Extremely slow SQL server

    Hi John

    The server runs Pastel, some backup software, the IIS software, DNS, DHCP, Domain controller. They typical everything on one server of a small company, but we have...

    March 12, 2018 at 9:16 am

    #1982773

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