We have a custom application that seems to run fine but when multipe users on
a Terminal Server run it at the same time the processor time for the sqlsrvr
service on the SQL server goes to max.
We can see in the SQL enterprise manager that the CurentActivity\ProcessInfo
that the Process ID for all requests from the terminal server are the same
regardless of the user. For workstations they each ahve their own ID.
We see no other correlation.
Is there something we need to change in the configuration of SQL, the client
or the program so that the termianl server doesn't single handedly overlaod
the sqlsrvr service?
Thanks