Weird Performance problem. Fast on standalone laptop, slow on super-duper server.

  • Try setting MAXDOP to 1-8 on your test server instance and see if that changes things.

    Also run some typical queries that are behind some of the slowest actions on each platform (in SSMS on the server).

    Compare time, IO and query plan. This way you are taking the app out of the equation

    Is anything else running on the PROD server. What does cache hit ratio and page life expectancy look like?

  • Also, check the power saving settings on the PROD server.

  • Try setting MAXDOP to 1 on your test server instance and see if that changes things.

    Is restrciting SQL Server to 1 core really going to help performance?!

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • No, but in order to identify issues related to parallelism going out of whack, it is a place to start.

Viewing 4 posts - 16 through 19 (of 19 total)

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