performance issues with an sql query service that executes a stored procedure in MS SQL

I have a stored procedure defined in an MS SQL database,  I have an sql query service defined in a thing template as follows:

SET NOCOUNT ON
EXEC [dbo].[sp_Local_GetWorkOrdersOperationStep_ByWO]
@WorkOrder = [[WorkOrder]]

where workorder is a test string

under previous versions of Thingworx (up to version 7.3) we had no issue (the service would run in about the same time it would take to run in server management studio -> between 5 and 15 seconds).  We upgraded to 8.1 within the last 6 months and now I observe that this query generally takes anywhere from 45 seconds to several minutes.  I have tried just about every ms sql jdbc driver available including (the latest preview release:   mssql-jdbc-7.1.4.jre8-preview) and nothing has changed.  I recently created a servlet to execute this stored procedure from and installed in on the same server.  The servlet executes this stored procedure in 5 to 15 seconds (same as server management studio) which tells me the problem in occurring within Thingworx.    I have this same code installed on about 7 different machines with each machine talking to the same database including my own laptop.   Every one show this same poor performance with one exception:  on my laptop I was able to define this sql query service directly in the thing (which is used to execute it) and it will execute in the same amount of time it takes in server management studio (or no other machine was this same behavior observed).  I am not sure how to diagnose what is causing the poor performance so any insight would be greatly appreciated