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