November 10, 2012 at 2:53 pm
I have tried using the exactly same hardware, just insert 5000 records into a simple blank table, results:
sql2008R2 standard: 5100ms
sql2012 standard: 6500ms
It seems like the performance has dropped nearly 30%, anyone can help?
November 12, 2012 at 12:36 am
This might be an issue with Management Studio, not with SQL Server itself.
Try simulating a heavy workload with SSIS or with BCP, and see what happens.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2012 at 8:46 pm
i do not think it's caused by Management Studio itself, as I already tried create job, create stored proc, results the same, SQL2012 slower than SQL2008R2 for the same simple insert/delete queries (I have not tried update and select yet).
November 13, 2012 at 10:25 pm
Are you seeing difference in I/O or CPU Time? Duration is notoriously unreliable in these kinds of comparisons.
November 13, 2012 at 11:40 pm
Take a look at the actual query plans. Is there anything different?
(also, more than 5 seconds just to insert 5000 rows? There seems something off at your system)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply