Installation :: Stop W3wp From Holding Database Connections Open After Exit
Apr 22, 2010
We have an internal ASP.Net 3.5 application that opens Pervasive SQL databases, reads the data, and then closes the connection. Unfortunately, when the user exits the application, and even when they close their browser, the w3wp process seems to be holding the PSQL database connections open, which is causing licensing issues for us. I would like the w3wp process to release the database connections once the last user has exited from the ASP.Net application. How can I get w3wp to release the connections?
Someone told me that the Powershell command, "gps w3wp | kill" will stop the w3wp process. Is there any way I can automate this, so that the process will be killed automatically when the last user exits our ASP.Net application?
I am trying to determine if I have a database connection leak. So I need to see the number of open connections. I have some simple test code that creates a leak:
protected void Page_Load(object sender, EventArgs e) { for(int i = 0; i < 100; i++) { SqlConnection sql = new SqlConnection(@"Data Source=.SQLExpress;UID=sa;PWD=fjg^%kls;Initial Catalog=ABC"); sql.Open(); } }
Note there is no .Close and this does infact crash after being run 3 times in quick succession.
In order to measure the leak I am running the Performance monitor and measuring SQLServer: General Statistics/User Connections:
However, these seem to be zero when I run my code:
What should I change to actually see the connections?
ANSWER
I have approved an answer below. Even though it doesn't use the performance tools, its good enough for my use. Bottom line is I wanted to see how many connections remain open after opening a web page and this did the trick.
I am using Visual Studio 2008 Professional Version.i am trying to open a database of a starter kit which was created also created in VS 2008.everytime i try to open the database i get this message window: i don't know why i am getting this message i am using VS 2008 Profession Full Version
Is this necessary to open and close connection when i am using SqlDataAdapter and DataSet to get data from  from table from  databse in sql server? Which one will be better to use in the following code. Code1 or Code2.
Code: 1 With open and colse connection
public DataSet GetFAcadSlidingImage() { SqlConnection con = GetConnection(); cmd = new SqlCommand("Pro_GetFAcadSlidingImage", con); cmd.CommandType = CommandType.StoredProcedure;
[Code].....
Code:2 Without open and colse connection
public DataSet GetFAcadSlidingImage() { SqlConnection con = GetConnection(); cmd = new SqlCommand("Pro_GetFAcadSlidingImage", con); cmd.CommandType = CommandType.StoredProcedure;
I just recently installed VS 2008 on my workstation. I tried creating a simple web site just to check if the installation was fine. The project compiled without error but when I tried running it, the Macromedia Dreamweaver software is being launch. It tried it several time and it's all the same.I remember during the installation there was an option that was displayed asking me to select Designer or Coder. Since the default is Designer i just click next.
Is there a way to stop launching dreamweaver from VS 2008 every time i try running the web project? Is because I selected "Designer" during the installation?
I have recently moved our ASP.NET session state from InProc to a Sql Server solution. I can see session data being inserted into the Sql Server database. I'm monitoring the w3wp.exe process using the "Private bytes" & "# Bytes in all heaps" performance counters.As I navigate through the website it places data into session, however the private bytes counter still climbs on the server hosting the website? I thought the session data was being written to the database and not being stored in memory? The managed bytes remain constant, and I'm pretty sure all the objects going into the session are managed types.
I'm having some problems with connections to an SQL database not closing after being opened, which is maxxing out the pool and causing the site not to load any of the dynamic content (until eventually unused idle connections get close, as the problem seems to go away after a while).
I've been through my code several times and can't figure out where things are not being closed properly.
Is there a surefire way to make sure these connections are properly closed? Or to pinpoint where the problem lies?
Most places in the site I am using ObjectDataSource. You don't need to close a connection when using that, do you?
Where ObjectDataSource isn't used, a developer wrote this method and put it in a class file called "common.cs":
[Code]....
I searched the entire solution for every instance of "common.openDatabase()", and where it occurs I make sure there is a "cmd.Connection.Close();" that follows.
Am I missing something or doing it wrong?
Here's an example of where a db connection gets opened and then (purportedly) closed:
I have an application, which connects to a Oracle 10g R2 database, but what it is doing is opening lots and lots of connections and is not disposing them.
My application is using the MVC model, and I have Database Connection Class, which on unload of the page calls my dispose method, which consists the dispose and close commands. Further, on model control, on each of methods requesting data from the database, I am calling the close method on Oracle Data Reader.
I was asked to build a couple of small and basic websites, without the use of database connections, just plain forms with information and a couple of images and forms. So my question is, if I only use those "html" controls of the toolbox, the performance of the site will increase against those with lots of .net controls?
Some one told me to use php or any script language to do that kind of stuff, but I only know to code in .net.
I noticed that when I download a framework say like "Coolite" and open the solution, and find the Connection to the Database showed up in the Server Explorer.
In some other times, the Connection Dose not show.
I can create a connection to a Database in Server Exploere, but I need say to add it to my Web.Config directly, but not sure how. I am trying to drag-and-drop from the Server Explorer to Web.Config, it is not working.
When and how the Connections to Databases will show in Server Explorer ?
How I can create a connection to a Database using say a Wizard, and add it directly to Web.Config ?
We have an Oracle 11g database with two nodes. On occasion, one of the nodes goes down and for some reason one of my applications starts throwing this exception:
Error Message: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) at System.Data.OracleClient.OracleConnection.Open() Out IT group says that this is a program bug because the failover isn't working, but I am thinking that this is a function of the database.What is the cause, and if it is an application bug, what can be done code-wise to fix this problem? The connection string doesn't specify a particular node.
I just want to know, What parameters or attributes should be taken in connection string so as to handle high traffic enterprise applications? Like in general we use server, initial catalog, userid, passwd. Some times we add timeout , and in some scenario pool etc. But i don't know what attributes should i take in as my common practice apart from above.
i create a pdf dynamically it's perfect but the problem is that i want to open this pdf in popup but it cant't open in popup it open direct in browser. my code is below.
this is my first post and you can consider as someone with little knowlage in web development , after stuggling i figured out how to install or activate iis 7 on my vista home primeum , with asp.net 3.5 , when i type http://localhost i see the welocme screen of iis 7 , i did this steps inorder to see how a comy for my website look like after i recieved it from the developer by email. i put a copy in a foler in the c://inetpub/wwwroot
in adminstrative tool i opend iis7, under site i right clicked on (default web site) and i clicked (add to virtual directory )where i definded allias and the path for my website folder ( where i stored it in D drive), then i open firefox browser and typed[URL] , nothing showed up in the brower and there was error message, i tried to choose add application instead of add to vitual directoy and defined the allian and path again, guess what i could see my website .
now i recieved the final copy of my website from the developer and i'm so eager to see it after making the impovement , i can not open it , i repeat the same steps as above , i could not open it and i do not know what is wrong or what i missed ,
the error massage i recieved is as follow
Configuration Error Description:
An error occurred during the processing of a configuration file required to service this request.
Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
Source Error:
[Code]....
Line 36: ASP.NET to identify an incoming user. Line 37: -->Line 38: <authentication mode="Windows"/>Line 39: <!--Line 40: The <customErrors> section enables configuration
Source File: C:inetpubwwwrootsudan2web.config Line: 38 Version Information: Microsoft .NET Framework Version:2.0.50727.4200; ASP.NET Version:2.0.50727.4016
SQL Server Express 2005 MS Visual Studio 2005 Using ASP.NET with VB code behind. Requirements: Click a button on an ASPX page to disconnect temporarily all DB connections when not in use to allow a script to backup/copy the database to a safe backup location. When a user access the db afterwords, the DB connections will be re-established.
If this is imposible, recommend an alternative. Note: I am working with what I have been given and authorized to use.
I inherit an ASP.Net web site from my predecessor, it does not have a .csproj file or .sln file and it's not controlled by version control system. I install SVN server from CollabNet and use AnkhSvn as client since it integrates with VS.Net well, but when I try to open a subversion project, it must be a solution or project, can not be a website, are there any workarounds?
I started working on an Asp.net MVC website using Visual Web Developer Express 2008 a while ago. Just recently, I managed to get my hands on a copy of Visual Studio 2008 Professional (through DreamSpark ). I installed the Service Pack, and also the MVC2 files for Visual Studio.
However, now I can't open my project anymore. When I try to open the solution in Visual Studio, it tells me that the project type is not supported. Does this mean that I have to resort to using VWD Express again? Is there perhaps some way that I can edit the project file so that it will load and compile correctly?
Note: I installed MVC2 through the Web Platform Installer, and it says that it installed successfully. However, I notice that MVC references in my unit-test project don't seem to be resolved either - is this perhaps because MVC2 isn't actually installed properly?
i have a asp.net web site with it we have admin area with login page for admin only and all site is allowed for all - i need to ask how to define the right security configuration for it as i get this error Cannot use a leading .. to exit above the top directory. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the codeAn unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
I'm currently having an issue with asp net mvc and iis7 rewrite module. I'm rewriting a page from /kw.htm to /Listing/Search. And when it renders I have an exception that says "Cannot use a leading .. to exit above the top directory" I thought this scenario was now handle with the iis7 rewrite module. Did I miss something ?
I have a 32 bit number in my DB/ DAL layer that is used to represent some yes/no facilities about hotels. so I for example bit might mean "has swimming pool", bit 2 might mean "reception desk" etc etc.Currently I have some code in the BLL that says if (number and 2) = 2 then .ispool = true - this is repeated for any many boolean hotel referances I have.What happens then is in the UI have then say something like if .ispool = true then display swimming pool icon.
Then it occurs to me that I am testing the value twice 1) To test the bin to bool in the BLL and create the structure 2) to test the structure to dislay the icon.
If I move the if (number and 2) = 2 to the UI I get the same result with one less if.Is there some better way or code do deal with this, maybe loop through the structure or something like that or an asp way that is more suitable to deal with binary representation of boolean's.
I have encountered a weird problem that does not exist in Firefox or IE. I have a user control that has a text box and a required field validator. When the user control is hosted in an update panel, the UpdateProgress tag never closes the first time that the UpdateProgress is triggered on the page when the page is viewed in Chrome. Has anyone else encountered this, and if so, is there any solution other than removing the validator? I could manually validate, but who wants to do that to support a browser bug?
I've just completed my first iPhone-compatible & Droid-compatible mobile app. At one time, I was confounded by differences in back button behaviour between the two platforms, but I came up with a suitable workaround.One thing remains that I'd like to correct if it's at all possible. The application is very session-variable dependent, so naturally, its very dependent on sessions. Users invariably use leave pages open when they turn off their smartphones, and this means that they return to a non-repsonsive timed-out page when they turn it back on. Can anything be done to preclude this? As in active web app or no web app?
We have a web application using VS 2008, c#. We try to filter siteMap nodes based on security roles. We have our customized the mether GetRolesForUser() in RoleProvider class to determine a user's role. In this method, roles will be returned by querying an SQL Server database. However, we found that each time a page was loaded/refershed, this GetRolesForUser() was called, and the database would be queried. This is too MUCH and expensive. We thought the roles should be queried only once when a user logs in. After that, role info should be stored somewhere for this user, rather than query DB all the time.
