Poor performance with SDE on SQL Server 2012

[AaronKreag]

We recently completed a major upgrade and migration.  Our SDE went from Windows 2008 with SQL Server 2008R2 and we migrated to Windows 2012 and SQL Server 2012 (all new is 64bit).  We have the exact same settings, using a better and newer server even, the data is the same, server and sql and sde configs all the same, direct connect all the way around on all servers.

However, we immediately noticed that the SDE on SQL 2012 is HORRIBLE.  The desktop editing process lags and hangs, its like working through Citrix in 1994.  The web map application load times went from 1-3 seconds to 10-40 seconds depending on load.

Same RAM, Same CPU.... the only difference is we went to SQL 2012.

There was a similar bug reported for 10.1 here NIM082657 - When working with an SQL Server 2012 geodatabase a..‌

It appears this isn't actually fixed.  If someone has any experience with this scenario please comment and reach out to me.  Thanks!!!  Aaron

[Aaron_Kreag]

Interesting.  We have the same set up.  Can you email me?  akreag at bisconsultants dot com

Thanks!!

[AlinaTaus]

Aaron, I just sent you an email. If you don't receive it let me know.

[DavidColey]

Aaron, maybe a dumb question but you all don't have hyperthreading set up do you? 

[Aaron_Kreag]

David,

Back in the day IT told me it was not.  Just checked again it doesn't look enabled.

Aaron

[DavidColey]

oh good, sql and sde do not like hyperthreading.  Hyperthreading killed one my sql updates,  I think when we went from 2005 to 2008r2.  Could not figure it out until I found an obsucre thread in the old forums and sure enough, one of the admins had enabled hyperthreading on the database server...

[PhuNguyen4]

David,

Do we need disable hyperthreading on the database server?

Phu Nguyen

[DavidColey]

Phu-

sorry for the delayed response.  Anecdotally, yes I reccomend disabling hyperthreading on Windows Servers hosting SQL Server 2005 or 2008R2.  We found that performance was impacted when hyperthreading was enabled.  However, without performing tests and research, I can only speculate as to why.  Perhaps hyperthreading can cause an I/O or disk contention issue? 

David

[nishadwijesekara]

Does improving RAM, CPU power increase anything, we have 28 GB RAM and 4 Cores on the SQL server box.

Nishad Wijesekara

GIS Specialist, ext - 8370, TP: 403-387-8370

ALTALINK

http://www.altalink.ca/

[AaronKreag]

Are you using Hyper-V?

Sent via the Samsung Galaxy Note® 3, an AT&T 4G LTE smartphone

[nishadwijesekara]

We use esxi.

Nishad Wijesekara

GIS Specialist, ext - 8370, TP: 403-387-8370

ALTALINK

http://www.altalink.ca/