October 21, 2016 at 4:17 am
yes, we tried maxdop but didn't help thanks
October 21, 2016 at 4:21 am
did you try to set the database compatibility level to 90?
October 21, 2016 at 4:47 am
Its a serial plan caused by Scalar function and is impossible to parallelise with the current versions of SQLServer up to 2016.
This used to be the reason why partitioning with SQL2005 was a bad idea.
Though I think that partitioning will still currently only allow one thread per partition since it is built on top of a Partition Scalar Function.
In summary, Scalar functions are the devil.
October 21, 2016 at 4:52 am
yes, one partition by one partition.
October 21, 2016 at 4:58 am
or can you just make a query plan and attach it to your query?
October 21, 2016 at 5:08 am
or maybe you defined some indexed view on your old 2005 instance, I do't think sql 2012 have that much memory difference to run a query, the most important thing is your should first make sure your have same query environment except sql versioin and memory.
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply