Question 11.4 Sql Performance Issue

[Kalan]

Hi everyone,

I've 11.4 OE with ODBC setup to access SQL server 2012 located at the remote server and Sql Server Native client in my local system. I'm experiencing very poor performance of running a query or retrieving records with this environment setup as it taking hell amount time to bring the records to front end - whereas same code logic works well in OE 10.2B with Openedge local database. I'm sure no issues or no space to optimize the code. Is there any way for performance tuning or check-points I should consider to improve 11.4 OE Sql environment performance?

Thanks.
Kalan.

 

[TomBascom]

I'm sure no issues or no space to optimize the code.

What does this mean?

 

[TomBascom]

It sounds like you are comparing the performance of:

1) A local OpenEdge 10.2B database with an unknown client.

vs

2) A remote SQL Server 2012 database accessed with the native SQL Server client.

If I understand what you are saying the OpenEdge db works well and the SQL Server DB works poorly?

I may be crazy but I am assuming that the two databases have similar amounts of similar data in them and that you are comparing similar queries?

If that is true then your result strikes me as the expected result. Of course SQL Server sucks. Quite aside from it being a Microsoft product the fact that it is remote, whereas the OpenEdge db is local, should result in significantly worse performance.

To improve that performance I would 1) talk to the SQL Server DBA about tuning the SQL Server instance and 2) talk to the network engineers about possible network performance improvements.

Of course if I have misunderstood you then perhaps some other approach is in order.

 

[Kalan]

Thanks Tom, I'll check this network performance and SQL Server instance. I suspect its related to remote db server access thru ODBC and using SQL native client at my local system connect with DB server.

 

[TomBascom]

Maybe they should convert all the SQL stuff to OpenEdge