Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insert slow in SQL 2012 Expand / Collapse
Author
Message
Posted Wednesday, November 7, 2012 7:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 10, 2014 3:35 AM
Points: 21, Visits: 270
Insert 100000 records need to take 8 mins in sql 2012 if compare to sql 2008 just take 1 mins. Any ideal why like that?
Post #1382234
Posted Wednesday, November 7, 2012 7:52 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, October 9, 2014 4:06 PM
Points: 450, Visits: 1,342
You'll need to supply a lot more information than this.
Are there server differences, disk differences, have you compared execution plans,....

Have you rebuilt indexes, updated stats?

There are a host of things that can affect performance, so it's impossible to say from your short comment what it could be.

Cheers

Leo
Post #1382235
Posted Wednesday, November 7, 2012 8:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 10, 2014 3:35 AM
Points: 21, Visits: 270
If assume the server, disk , index are all same. Just use different SQL version, SQL 2012 vs SQL 2008, why the SQL 2012 will take longer time to insert the data? very curious now.
Post #1382237
Posted Thursday, November 8, 2012 1:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:28 PM
Points: 13,263, Visits: 11,053
It shouldn't be.
Take a look at the query plans to find out what's wrong.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1382311
Posted Thursday, November 8, 2012 1:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 10, 2014 3:35 AM
Points: 21, Visits: 270
I get a solution from this article, seems faster abit, but not very useful.

http://social.msdn.microsoft.com/Forums/en-NZ/transactsql/thread/1a47f409-7288-438b-adcf-b8ff3f3aacbc
Post #1382314
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse