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 a web application that use a MySql DataBase. In a page, i have used the sqlDatasource control. The problem is that the conection with the database doesn't closed and i have a lot of open conections until show me the error that says me that the conection pool is full.
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 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.
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?
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 need to store opening and closing time of Restaurants in database as well as compare them with current time to see whether it is closed or open when user is viewing it... How to do??
i am not able think how to desing UI through which resturant owner can save opening n closing time for their resturant ? like what control.
I am using a adapted version ofhttp://www.mikesdotnetting.com/Article/45/Programmatically-accessing-data-from-DataSource-controlsDon't we need something like a closing-routine / close connection command after getting data from the database?If yes: What is the correct closing command?
I nearly completed my project and was about to put it out to be run. My boss was going to make a minor change to the connection string and then put it out there. In short, my application was running off a dummy database, while the real database was out there. I have the connection string comiple and built through out my project in the aspx pages and the cs pages.
However, my boss wants to be able to change a single connection string in a single place, essentially in the web.config file. I'm fine with that, but I don't know how to access the connection strings stored in the web.config files. How do you do that? So far, I've only created a new connectionstring in my code on each page. I've told him you could do a "find and replace" on all the files but he doesn't want to do that. In short, he wants to change the connection string the same way he does all the other projects he works with, php, vb and etc.
how do you access the connection strings stored in the web.config file programmatically?
I have a web page with a button. When I press the button something happens (it doesn't matter what). What I want to do is: when I close the browser (the page is closing, too) I want to call the button1_click event. How can I do that?
I have simple asp.net web service, for monitoring and managing about 10 computers, with 4 webMethods and all of this methods are quite simple. In general they look sometning like: (1)make WMI connections to certain machine, (2)do some simple task, (3)return result.
Problem is that WMI connections to remote computers takes about 15s and I offten need to call 2 or 3 methods successively for the same machine.
From what I know, there is new instance of my service class (public class MonSvr :
System.Web.Services.WebService ) created every time webMethod is called.
So how can I share WMI or DB connection betwen all instances of my service that I could reuse this connection ? When there all multiple calls to webMethods of my service, does then each instance of web service runs in separate thread ?
I've inherited a very large project in ASP.net, SQL 2005 and have found where some SQL connections are not closed - which is bad. Without going thru every line of code, is there a way to detect if connections are not being closed? Performance counter? as a follow up - how does SQL reclaim unclosed connections. I'm using non-pooled connectionstring.
I am working on a web application which is designed as master and web content pages. I designed login and logout for the application. When logout is clicked, it will call a method to clear the session variables and also some other methods which will clear some data in the oracle tables.
But if the user is clicking on the internet explorer close button, then there is no way to know that the application is closed. For this I got a link where we can write a javascript method and find the unload of the page and execute all of these but pages will be loading and unloading each time user navigates inside the application and I cannot depend on unloading the page.
how can I do all the process of clearing session and other things when user clicks close button of internet explorer.
Also this application needs to be holding the session for more than 1 or 2 hours, so session should not expire till logout is clicked or close button is pressed.
I have a web page (aaaaaa.aspx) which opens a popup window (bbbbbb.aspx). From the popup window vb.net code, I do a Response.Redirect("cccccc.aspx") to another page. On this page I have a button and when I click it, I want to close this page (cccccc.aspx) and refresh the original page (aaaaaa.aspx) so that the changes can be seen. Presently, the page cccccc.aspx close but the original page (aaaaaa.aspx) does not refresh. Normally this works fine with just a popup window. But the response.redirect is what messing me up, I think. I did not write this code but just trying to make it work. Here is the code I am using in the button_click event of page cccccc.aspx:
I'm having an issue with my hosting provider (winhost.com). My app is built on ASP.NET 4 MVC 3. Up until a few days ago, everything was running fine. All of a sudden I've started getting 503 errors when trying to access my site (wikipediamaze.com). It doesn't happen all the time, just most of the time.
When someone starts playing the game a request is made to wikipedia.org to get the contents of the page for the current step in the puzzle. Basically I'm screen scraping wikipedia.org, injecting some html and then displaying the results. All of my web requests are closed immediately after receiving the data.
What winhost is telling me is that there are connections remaining open and causing any additional requests to the site to get the 503 Service Unavailable Error. What I can see from my end is that only 1 request is ever allowed to be made to wikipediamaze.com at a time. If you keep refreshing the page you'll eventually get the HTML but all subsequent requests (css,images,js) all get the 503 error. Even pages that don't ever call out to wikipedia.org.
If it was an issue with connection throttling in IIS, do both incoming and outgoing (requests made internally) fall in to the same bucket? If I'm sure all of my connections are being closed (and I've never had this issue before) what else could cause this?
I have a problem with the connection of external files - northwind.MDF Connection to SQL Server is fine. But to connect to external files wrong. Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Intance Specified)
