Home Forums SQL Server 2014 Development - SQL Server 2014 Help with Performance on select count(*) SQL Server 2014 RE: Help with Performance on select count(*) SQL Server 2014

  • May 23, 2017 at 10:30 am

    #1943843

    zouzou - Tuesday, May 23, 2017 10:17 AM

    I have backed up DEV db and restored it on TEST server  and then i have run on that DEV db on Test server the same query i was running on the test db that is hosted on the same server and on DEV db the query ran very fast. sorry about the plans uploaded them again now.

    Have you looked at the differences in execution plans by comparing these 2 show-plans in SSMS?

    Top = DEV, Bottom = TEST

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle