April 21, 2017 at 5:39 am
Hi
I'm busy investigating and issue are performance differences between SQL 2014 Developer and Enterprise editions. Our company program-magically create Integration Services Packages.
We have noticed however that the process takes roughly ten times as long on Developer Editions when compared to Enterprise editions.
Has anyone experience something similar? Am I missing something?
April 21, 2017 at 5:48 am
ianbruwer - Friday, April 21, 2017 5:39 AMHi
I'm busy investigating and issue are performance differences between SQL 2014 Developer and Enterprise editions. Our company program-magically create Integration Services Packages.We have noticed however that the process takes roughly ten times as long on Developer Editions when compared to Enterprise editions.
Has anyone experience something similar? Am I missing something?
Should not happen. Are the instances identical in every other way (hardware, file structure across disks, SQL settings, other processes running, network bandwidth)?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 21, 2017 at 6:00 am
The instances are absolute identical. In fact I'm running the test from my laptop. Everything is on my laptop. Performed test on dev edition. Uninstalled dev edition and installed enterprise edition. Performed test again. Then uninstalled enterprise and intalled dev edition and repeated test once again. Enterprise is lightning, Dev is dog slow.
April 21, 2017 at 6:04 am
ianbruwer - Friday, April 21, 2017 6:00 AMThe instances are absolute identical. In fact I'm running the test from my laptop. Everything is on my laptop. Performed test on dev edition. Uninstalled dev edition and installed enterprise edition. Performed test again. Then uninstalled enterprise and intalled dev edition and repeated test once again. Enterprise is lightning, Dev is dog slow.
That is interesting. Have you investigated whether the slow performance is across the board, or whether it's just certain tasks which take longer?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 21, 2017 at 6:17 am
Haven't investigated anything else. In general everything else appears to be equal. Was hoping someone else could simply tell me that Dev edition is configured slightly differently and that I can go and change it.
April 21, 2017 at 6:58 am
Are you using the checked build of dev edition? 32 bit version by mistake?
Watch CPU utilization on both runs, and do a differential wait stats and file IO stall analysis while processes are running.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
April 21, 2017 at 12:07 pm
only differences between Developer and Enterprise is that the enterprise version may be limited by the number of cores it uses.
If for some reason the Enterprise version used is one of the limited ones then that could explain the difference.
Other than that there are no differences whatsoever between them so if both versions are the same (e.g. both 32bit or both 64bit) then all should run the same
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply