Hi, guys. I've run into a situation at work, just started not so long
ago, and I'm trying to figure out what is going on behind the scenes.
This place has the instance in question running in dedicated server
mode. Well, it's the backend to a webapp that uses the same
username/login to fulfill each of the 100's of users sql requests.
That having been said, is the same dedicated server process handling
ALL of the requests? If that's the case then would changing it to a
MTS mode make any difference seeing as how the same username/login is
used for each request? I'd appreciate anyone's help. Thank you.