Works fine in PCC, CPU usage, at least on my TS connection, barely spikes at all.
Exact same query, exact same everything as far as the interaction goes.
I'm trying to get User OS details at the moment
As far as the users, there are three that are attempting/sometimes successfully to run. I have a connection to a Terminal Server at their site and most of the time I have no issue executing. Other times, the connection will fail and not even make it to the execution point of the stored procedure (unable to connect to database XXX as seen below), at which point the rest of the applications in use there that are connecting to PVSW start receiving 3014 errors, at which point the services are manually restarted to correct. All seems to coincide with the "unable to connect to database 'paiTHM'" error received in this application. When the error does occur, message is reproducable via windows "ODBC Manager" as expected. Same intermittentness from all three machines and users involved, no direct cause/problem known yet.
The application receives a 'unable to connect to database 'paiTHM' (which is the DSN name) whenever we fail, which corresponds to the log entries for the errors. All The pvsw.log (client and server both) show nothing about the errors, everything I have found so far has been through the event viewer on the server.