• sotn (1/14/2013)


    I think this is fixed.

    We have found that the CPU settings in the bios were set to balanced

    Thanks SQLRNNR for the pointer.

    A 'real' workload before changing the setting now takes just a 3rd of the time, we are doing more tests and my simple select * from 1 million rows takes between half and a third of the cpu ms time.

    Thanks for all the replies.

    Good to hear.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events