Forum Replies Created

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

  • RE: Poor SQL Performance

    Hi Alex - we provisioned an entirely new server and installed SQL 2012 fresh and then backed up and restored the databases to the new server.

  • RE: Poor SQL Performance

    Ah ok I see how you got to that calculation now - I think with this information I'm going to see if I can get a resource to look at...

  • RE: Poor SQL Performance

    Hi Kevin,

    The elapsed_time column is the interval between the baseline I took and the next polling. So the first few lines in the excel sheet would be about 6 minutes...

  • RE: Poor SQL Performance

    Ah ok that makes sense to track seperate - after benchmarking for a bit today if I'm calculating that right it doesn't seem like it is that bad right now?...

  • RE: Poor SQL Performance

    Ah ok thought I was perhaps missing something for the analysis - I've ran a few scripts related to this and this is what we get:

    TempDB avg io stall ms:...

  • RE: Poor SQL Performance

    Hi Kevin,

    Thanks for your response - this was where I was leaning as well - I will say before the upgrade of these various components our performance seemed to be...

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