We are currently hosting our ArcSDE geodatabase on SQL Server 2008 SP3.
I was wondering if there'd be any type of performance boost if we jumped up to 2008 R2?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
There are no known issues of performance degradation with upgrading to SQL SERVER 2008 R2. In the recent times the only bug that I can think of is [NIM082657:When working with an SQL Server 2012 geodatabase and Geometry or Geography type data, ArcMap drawing performance is slower than it was using SQL Server 2008. This affects all rendering and editing operations]
Be cautious, check the compatibility page for your ArcGIS version, take a backup and upgrade to SQL SERVER 2008R2