topic Re: Should we use SQL Server Advanced or Standard as RDBMS for ArcGIS Enterprise? in ArcGIS Enterprise Questions

Should we use SQL Server Advanced or Standard as RDBMS for ArcGIS Enterprise?

StevenMenefee1 — Wed, 19 Jul 2017 14:40:35 GMT

We are potentially going to purchase ArcGIS Enterprise and I'm trying to find the differences between Microsoft SQL Server Enterprise vs SQL Server Standard. I know they're both compatible with ArcGIS Enterprise, but am curious to know what the differences between them are from an ArcGIS Enterprise standpoint.

What I'm really trying to figure out is if the Enterprise level is necessary and justifies the nearly $10,000 price difference between it and the Standard edition. If I can get by using the Standard edition without sacrificing too much then I'd rather go that route. So another question I would ask is if there are any users out there using the Standard edition of SQL Server and how it's working out for them.

This site does a good job of showing the differences between Enterprise and Standard, but when it gets beyond the cores, memory, and database sizes, I start to become confused as to how it will impact ArcGIS Enterprise. In any case, any help or guidance on this would be greatly appreciated, thank you!

Re: Should we use SQL Server Advanced or Standard as RDBMS for ArcGIS Enterprise?

RebeccaStrauch__GISP — Wed, 19 Jul 2017 17:33:07 GMT

tagging https://community.esri.com/groups/geodatabase?sr=search&searchId=acabed1e-06f9-4b2b-a00e-0f704e935e45&searchIndex=2‌

Re: Should we use SQL Server Advanced or Standard as RDBMS for ArcGIS Enterprise?

JoshuaBixby — Wed, 19 Jul 2017 17:55:31 GMT

One issue that isn't highlighted well in your link is Degree of Parallelism. SQL Server Standard has limited parallelism for query execution, indexing, and Columnstore and Real-time Operational Analytics.