Hi, I’m using Mobilink 12.0.1, MS SQL Server 2005 Enterprise Edition as consolidated Database and Microsoft native ODBC driver version 2005.90.1399.99. Mobilink synchronization events are written using SQL language.
Monitoring Mobilink activity in SQL Server (using SQL Server Profile Tool) I have noted that every table script event is executed as a different PreparedStatement with a pair of sp_prepexec and sp_unprepare commands.
Considering that synchronization scripts are stable artefacts and that Mobilink keep a pool of open connections to consolidated database, I wonder if there are any way to tune Mobilink to reuse PreparedStatements, reducing, this way, server load.
Thanks in advance.
asked 09 Jan '12, 08:25