open connection

Owen

Hello:

How know how many open connection have my application made in asp.net?, To
know if a open a new connection and not close?

Best regards.
Owen.

Nov 18 '05 #1

Subscribe Post Reply

1515

Peter Rilling

What type of connection are you talking about -- a database connection or a
website connection or something else?
"Owen" <an****@prensa-latina.cu> wrote in message
news:#n**************@TK2MSFTNGP09.phx.gbl...

Hello:

How know how many open connection have my application made in asp.net?, To
know if a open a new connection and not close?

Best regards.
Owen.

Nov 18 '05 #2

Owen

sorry for not explain what kink connection, it database connection.

"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

What type of connection are you talking about -- a database connection or a website connection or something else?
"Owen" <an****@prensa-latina.cu> wrote in message
news:#n**************@TK2MSFTNGP09.phx.gbl...
Hello:

How know how many open connection have my application made in asp.net?, To know if a open a new connection and not close?

Best regards.
Owen.

Nov 18 '05 #3

Peter Rilling

I do not know if there is any global way, other then communicating with
SQLServer at a very low level, of finding the number of connections that are
open. Presumable you would have some mechanism for knowing when you open a
connection and keep track of them there. Also, I would suggest that you
close a connection as soon as you are finished with it. If you need to know
how many connections are open, then you may not be closing them when you
should.

If this answer does not suffice, then maybe you could explain specifically
what you are trying to do.

"Owen" <an****@prensa-latina.cu> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

sorry for not explain what kink connection, it database connection.

"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
What type of connection are you talking about -- a database connection or
a
website connection or something else?
"Owen" <an****@prensa-latina.cu> wrote in message
news:#n**************@TK2MSFTNGP09.phx.gbl...
Hello:

How know how many open connection have my application made in
asp.net?, To know if a open a new connection and not close?

Best regards.
Owen.

Nov 18 '05 #4

Rick Strahl [MVP]

Hi Owen,

You can query a performance counter for open connections. The counter is:
float count = new PerformanceCounter("SQLServer:General Statistics", "User
Connections");

+++ Rick ---
--

Rick Strahl
West Wind Technologies
http://www.west-wind.com/
http://www.west-wind.com/weblog/
----------------------------------
Making waves on the Web
"Owen" <an****@prensa-latina.cu> wrote in message
news:#7**************@TK2MSFTNGP12.phx.gbl...

sorry for not explain what kink connection, it database connection.

"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
What type of connection are you talking about -- a database connection or
a
website connection or something else?
"Owen" <an****@prensa-latina.cu> wrote in message
news:#n**************@TK2MSFTNGP09.phx.gbl...
Hello:

How know how many open connection have my application made in
asp.net?, To know if a open a new connection and not close?

Best regards.
Owen.

Nov 18 '05 #5

Ashish M Bhonkiya

Hi Owen,

In line with what Rick explained.

Also if you directly want to monitor the number of connections instead of
programatically accessing it from your application you can also query the
same details using the PerfMon Utility.

follow the following steps.

click on startmenu -> run-> type perfmon
click on the + sign (to add the new counter)
select the sql server general statistics in the performance object
dropdownlist and choose userconnections in the counter and add it.
run your application and monitor the counter.

Regards
Ashish M Bhonkiya

"Owen" <an****@prensa-latina.cu> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

sorry for not explain what kink connection, it database connection.

"Peter Rilling" <pe***@nospam.rilling.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
What type of connection are you talking about -- a database connection or
a
website connection or something else?
"Owen" <an****@prensa-latina.cu> wrote in message
news:#n**************@TK2MSFTNGP09.phx.gbl...
Hello:

How know how many open connection have my application made in
asp.net?, To know if a open a new connection and not close?

Best regards.
Owen.

Nov 18 '05 #6

Similar topics

closing open connections

by: C Sharp beginner | last post by:

I'm sorry about this verbose posting. This is a follow-up to my yesterday's posting. Thanks William for your reply. I understand it is a good practice to open connections as late as possible and...

C# / C Sharp

Database question - Database Open, Close Design

by: Macca | last post by:

Hi, I have an windows forms application that accesses a SQL database I have a few questions as to connecting to the database. This application will run 24 hours a day. It is a monitoring...

C# / C Sharp

SqlCommand Open VERY slow on application load

by: B B | last post by:

Okay, here is what's happening: I have a reasonably fast laptop (1.4 GHz Mobile M, so comparable to 2.5GHz P4) doing .net development. Running Windows XP pro, SP2 IIS is installed and running...

ASP.NET

check database connection/open

by: martin1 | last post by:

All, I want to check wether db connection/open or not, if not it will post db connection error to user in message box The code is like: Dim objConnection As New SqlConnection _...

Visual Basic .NET

There is already an open DataReader associated with this Connection which must be closed first

by: fniles | last post by:

I am using VB.NET 2003, SQL 2000, and SqlDataReader. As I read data from tblA, I want to populate tblB. I use SQLDataReader for both tables. I do not use thread. When I ExecuteReader on tblB, I...

Visual Basic .NET

There is already an open datareader with this command which must be closed first

by: jimmy | last post by:

Hi again, sorry for posting two questions so close together but im working on a school project which is due in soon and running into some difficulties implementing the database parts. I have the...

Visual Basic .NET

ExecuteReader requires an open and available Connection. The connection's current state is Open, Executing.

by: fniles | last post by:

I am using VB.Net 2003 and MS Access (connecting using OleDBConnection). I read using DataAdapter and DataSet, not DataReader. When many people try to access the database at the same time, I get...

Visual Basic .NET

Problem: Database connections remain open

by: Usman Jamil | last post by:

Hi I've a class that creates a connection to a database, gets and loop on a dataset given a query and then close the connection. When I use netstat viewer to see if there is any connection open...

.NET Framework

Open MS Access Exclusive

by: =?Utf-8?B?RyBIdXN0aXM=?= | last post by:

I am creating a new MS Access DB in code, which works fine. I then try to open it & set a password. I keep getting an error that the DB is already open by my machine's Admin account. In reality it...

.NET Framework

open a connection to the pool

by: Tony Johansson | last post by:

Hello! How does this connection pool function actually ? As I have been told is that when the connection is returned to the pool the connection to the database is still open. What you do is that...

C# / C Sharp

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

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...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

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...

Computer Hardware

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General