number of database users

Hi,
Does anybody know whether performance is affected if all database
connections are done through the same database user name? Ie will performanc
e
be better if I had 20-30 different database users instead of one I am using
at the moment.
Personally, I am not expecting better performance!. Thanks a lot.
Panos.Rather broad question, but if you are using Connection Pooling somewhere
along the line you should see an increase in "performance" by using a single
user as opposed to multiple users since new connections may not need to be
created or maintained - SQL Server can just keep using the same one(s) over
and over- though with only 20-30 users you probably won't see much of an
increase in performance (if anything). The actual overhead on the processor
s
for 20-30 users vs one singe user probably won't be noticable, and the
queries themselves won't care.
HTH
"Panos Stavroulis." wrote:

> Hi,
> Does anybody know whether performance is affected if all database
> connections are done through the same database user name? Ie will performa
nce
> be better if I had 20-30 different database users instead of one I am usin
g
> at the moment.
> Personally, I am not expecting better performance!. Thanks a lot.
> Panos.|||You will not get worse performance using same user. You might get better per
f, if using the same
user will mean better cache hits for proc and query plans (depends on how we
ll written your SQL is).
There are other implications, of course, like traceability.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Panos Stavroulis." <PanosStavroulis@.discussions.microsoft.com> wrote in mes
sage
news:FEB14413-F110-4C8F-8E4A-294AC45BCB5C@.microsoft.com...
> Hi,
> Does anybody know whether performance is affected if all database
> connections are done through the same database user name? Ie will performa
nce
> be better if I had 20-30 different database users instead of one I am usin
g
> at the moment.
> Personally, I am not expecting better performance!. Thanks a lot.
> Panos.