A way to track open data connections? - ASP / Active Server Pages

MostlyH2O

Hi Folks,

I've been cobbling together a rather complex web utility, and was wondering
if there is a way to monitor the number of data connections and open
recordsets currently being used by the server. I am using IIS5. I'm
essentially looking for a tool that would help identify sloppy code by
showing a list of currently open data connections or recordsets.

Thank very much,
Jack Coletti

Jul 19 '05 #1

Subscribe Post Reply

1303

Ray Costanzo [MVP]

Well, you didn't tell us what database you're using. If it's SQL Server,
you can use perfmon (Performance Monitor) which is included with Windows NT,
2000, XP, and 2003.

Check out the links here. http://www.aspfaq.com/show.asp?id=2513

Ray at home

"MostlyH2O" <jm*@takeitouthrmp.net> wrote in message
news:9w****************@tornado.tampabay.rr.com...

Hi Folks,

I've been cobbling together a rather complex web utility, and was
wondering
if there is a way to monitor the number of data connections and open
recordsets currently being used by the server. I am using IIS5. I'm
essentially looking for a tool that would help identify sloppy code by
showing a list of currently open data connections or recordsets.

Thank very much,
Jack Coletti

Jul 19 '05 #2

Similar topics

Can't Open Anymore Databases

by: Steve | last post by:

Access97 Database The database is split into a frontend and backend and not connected to any other database. The database has an unbound report with 15 subreports. Some of the subreports include...

Microsoft Access / VBA

Cannot open any more databases.

by: ultraton | last post by:

While trying to print a report from Access the user receives the following error: Cannot open any more databases. Okay Help Does anyone have any ideas about this behavior? Thank you very...

Microsoft Access / VBA

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

asp.net ms-access oledb connection open error

by: Mathew Vording | last post by:

Hi. I have an application that after using it for a while, continually forcing it to hit the database it will fail on connection open with the OLEDB "Unspecified Error" message. ...

ASP.NET

SQLConnection.Open() Timeout Error - but...nothing has changed?

by: Nevyn Twyll | last post by:

I've been working on an asp.net application and everything's been great. But suddenly, whether I'm tyring to use a database on my own machine, or on my server, I'm getting a timeout when trying to...

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

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

ftplib question (cannot open data connection)

by: Laszlo Nagy | last post by:

Hi All, I'm using a simple program that uploads a file on a remote ftp server. This is an example (not the whole program): def store(self,hostname,username,password,destdir,srcpath):...

Python

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

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

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

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

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp