dear all,
i have an application which could have more than 150 users, I have set it up
to use windows integrated authentification.
What I have to do to be sure that my application will use connection pooling ? 8 1697
just use performance monitor to watch pooled sql connections...
--
HTH
Thanks,
Yunus Emre ALPÖZEN
BSc, MCSD.NET
"serge calderara" <se************@discussions.microsoft.com> wrote in
message news:84**********************************@microsof t.com... dear all,
i have an application which could have more than 150 users, I have set it up to use windows integrated authentification.
What I have to do to be sure that my application will use connection pooling ?
Not to muth just make sure you use a single connection string.
If you want authentication towards your database use sspi=true or interated
authentication=true (These are the same)
The rest is done by the platform.
Bye,
--
Rainier van Slingerlandt
(Freelance trainer/consultant/developer) www.slingerlandt.com
"serge calderara" wrote: dear all,
i have an application which could have more than 150 users, I have set it up to use windows integrated authentification.
What I have to do to be sure that my application will use connection pooling ?
It depends on "who" establishes the connection.
If you have impersonation enabled (<identity impersonate="true"/>),
and your connections to the database use integrated security, you'll
have one connection pool per user.
If you are not impersonating, or if you use a SQL login and password,
you'll still have a single connection pool for the application
(assuming the connections meet the other pooling criteria).
--
Scott http://www.OdeToCode.com/blogs/scott/
On Sun, 27 Nov 2005 09:40:02 -0800, serge calderara
<se************@discussions.microsoft.com> wrote: dear all,
i have an application which could have more than 150 users, I have set it up to use windows integrated authentification.
What I have to do to be sure that my application will use connection pooling ?
Hi scott
You said :
"If you have impersonation enabled (<identity impersonate="true"/>),
and your connections to the database use integrated security, you'll
have one connection pool per user."
=================================
Does it works similar as if you create a user account for each of them ?
In this case I have read than performance is decrease and its better to use
one single connection string
When connection pooling is prefered then ?
regards
serge
"Scott Allen" wrote: It depends on "who" establishes the connection.
If you have impersonation enabled (<identity impersonate="true"/>), and your connections to the database use integrated security, you'll have one connection pool per user.
If you are not impersonating, or if you use a SQL login and password, you'll still have a single connection pool for the application (assuming the connections meet the other pooling criteria).
-- Scott http://www.OdeToCode.com/blogs/scott/
On Sun, 27 Nov 2005 09:40:02 -0800, serge calderara <se************@discussions.microsoft.com> wrote:
dear all,
i have an application which could have more than 150 users, I have set it up to use windows integrated authentification.
What I have to do to be sure that my application will use connection pooling ?
On Mon, 28 Nov 2005 01:51:02 -0800, serge calderara
<se************@discussions.microsoft.com> wrote: Does it works similar as if you create a user account for each of them ? In this case I have read than performance is decrease and its better to use one single connection string
Yes. The connection pooling can only pool connections that use the
same security context. When connection pooling is prefered then ?
Generally for performance, a single pool will work better, but you
might have requirements that override performance. For instance, you
might have security requirements or auditing requirements that force
you to log a user into the database with their own identity.
--
Scott http://www.OdeToCode.com/blogs/scott/
At last, my advice u to setup distinct user accounts for every C-R-U-D
operation. For instance, when u are reading data, u should connect db via a
user who is only datareader, etc.. In this circumstance, you will have four
different connection strings.. And u can easily monitor load on any
operation by using your own custom performance counters. And u can monitor
sql server pooling by using performance monitor using .NET CLR Data
performance object.
--
HTH
Thanks,
Yunus Emre ALPÖZEN
BSc, MCSD.NET
"Scott Allen" <sc***@nospam.odetocode.com> wrote in message
news:2d********************************@4ax.com... On Mon, 28 Nov 2005 01:51:02 -0800, serge calderara <se************@discussions.microsoft.com> wrote:
Does it works similar as if you create a user account for each of them ? In this case I have read than performance is decrease and its better to use one single connection string
Yes. The connection pooling can only pool connections that use the same security context.
When connection pooling is prefered then ?
Generally for performance, a single pool will work better, but you might have requirements that override performance. For instance, you might have security requirements or auditing requirements that force you to log a user into the database with their own identity.
-- Scott http://www.OdeToCode.com/blogs/scott/
thnaks for your reply.
Oups what is C-R-U-D ?
"Yunus Emre ALPÖZEN [MCSD.NET]" wrote: At last, my advice u to setup distinct user accounts for every C-R-U-D operation. For instance, when u are reading data, u should connect db via a user who is only datareader, etc.. In this circumstance, you will have four different connection strings.. And u can easily monitor load on any operation by using your own custom performance counters. And u can monitor sql server pooling by using performance monitor using .NET CLR Data performance object.
-- HTH
Thanks, Yunus Emre ALPÖZEN BSc, MCSD.NET
"Scott Allen" <sc***@nospam.odetocode.com> wrote in message news:2d********************************@4ax.com... On Mon, 28 Nov 2005 01:51:02 -0800, serge calderara <se************@discussions.microsoft.com> wrote:
Does it works similar as if you create a user account for each of them ? In this case I have read than performance is decrease and its better to use one single connection string
Yes. The connection pooling can only pool connections that use the same security context.
When connection pooling is prefered then ?
Generally for performance, a single pool will work better, but you might have requirements that override performance. For instance, you might have security requirements or auditing requirements that force you to log a user into the database with their own identity.
-- Scott http://www.OdeToCode.com/blogs/scott/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mithun Verma |
last post by:
Hello All,
I am working on a windows application which will talk to the database
through the Web services.
So i need to enhaance the performance, for which i m using connection
|
by: John |
last post by:
Does COM.ibm.db2.jdbc.DB2DataSource, (which supports connection
pooling) need to be run within a J2EE container environment before the
connection pooling facility is actually available to a user?
...
|
by: Rob Nicholson |
last post by:
We're getting an occasional occurrence of the following error when two users
try and open the same record in our ASP.NET app:
"There is already an open DataReader associated with this Connection...
|
by: Lenny Shprekher |
last post by:
Hi,
I am getting issues that Oracle collecting opened sessions (connections)
from my webservice using regular System.Data.OleDb.OleDbConnection object.
I am guessing that this is connection...
|
by: JimLad |
last post by:
Hi,
In an existing ASP/ASP.NET 1.1 app running on IIS 6, I need to RELIABLY
pass the logged in username through to the SQL Server 2000 database for
auditing purposes. The current method is...
|
by: crbd98 |
last post by:
Hello All,
Some time ago, I implemented a data access layer that included a simple
connectin pool. At the time, I did it all by myself: I created N
connections, each connection associated with...
|
by: fniles |
last post by:
I am using VS2003 and connecting to MS Access database.
When using a connection pooling (every time I open the OLEDBCONNECTION I use
the exact matching connection string),
1. how can I know how...
|
by: fniles |
last post by:
In the Windows application (using VB.NET 2005) I use connection pooling like
the following:
In the main form load I open a connection using a connection string that I
stored in a global variable...
|
by: viswarajan |
last post by:
Introduction
This article is to go in deep in dome key features in the ADO.NET 2 which was shipped with VS 2005.
In this article I will go trough one of the key features which is the Connection...
|
by: Sylvie |
last post by:
I have a static function in a class, everytime I call this function, I am
creating a SQLconnection, open it, use it, and null it, All my functions and
application logic is like this,
Every...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |