Increase Minimum Connections Pool To 100?
Jun 8, 2010I have a website with high traffic.
Maybe I will increase minimum connections pool, to 100.
This is too high? Website have 10000 pageviews/day
I have a website with high traffic.
Maybe I will increase minimum connections pool, to 100.
This is too high? Website have 10000 pageviews/day
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.
[code]....
I'd like to describe strange issue I've noticed while analyzing my asp.net application in production and ask for some advice or opinion on the following matter.Application usually runs with some 80-90 MB of memory footprint. This seems stable since no memory leaks have been detected so far - no slight increase in memory usage over time. Yet, problem occurs when application pool recycles (I'm using shared hosting and judging by logs it occurs either when app is idle for 20 mins or every ~30 hours - something like that). The issue is that used memory almost doubles for some period on recycle - it goes to some 160-170 MBs without any explanation. This is confusing, since it is common claim that recycling should purge the memory and all other resources - at least I get it that way. System holds this amount of memory for some 7-8 hours and then memory usage drops to it's usual level of 90-100 MB, again, with no apparent reason (at least not know to me).
View 1 RepliesIf I create a new thread on an ASP.NET page the IsThreadPoolThread property is true.
First question is, is it from ASP.NET pool or CLR pool ?
Second question is, if it is from ASP.NET pool then how to create a thread from CLR and don't use ASP.NET pool ?
i am working on my master site, and i want to add an image that increases its lenght as the website's length increases...
but im not sure how to do that, i know it's possible because i've seen it done on banners, but im not completely sure how to do it.
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.
View 2 RepliesI have one Hotel class that contains many properties. When I retrieve all hotels data from database, I store them in Generic List object.Now what I want that I have two properties called LowestPrice and HiestPrice. I want to get Minimum(LowestPrice) and Maximum(HiestPrice) from generic list directly.
Something like HotelList.Min();
Right now I have following logic implemented in my project, but I dont want to use foreach loop.
[Code]....
I'm building an asp.net application and have a problem. Im building now a stored procedure in sql server and need the min (1/1/0001) and max(12/31/9999) value of the datetime. Is there some method I can execute to get this dates?
View 1 RepliesMySqlCommand cmd4 = new MySqlCommand("select emp_name from employee_details where emp_category='" + cat[j] + "' and no_ofcassigned=(select MIN(no_ofcassigned) from employee_details)", AL.con);
MySqlDataReader reader2 = cmd4.ExecuteReader();
string emp=null;
while (reader2.Read())
{
emp = reader2[0].ToString();
}
reader2.Close();
i am using the above code to fetch the employee name from the datatable according to the minimum value in the column 'no_ofcassigned' in specific category but here if i have more than 3 employees with the same no_ofcassigned is there then the query is not
gularExpressionValidator on my textbox that I am already using, but I need it tweaked. Here is the one I'm using: ^(([0-9]|[1][0-9]|2[0-3])(.)(25|50|75|00))|(24.00)|([0-9]|[1][0-9]|[2][0-4])$It is for the input of hours worked in a day. The minimum is 0.00 and the max is 24.00. The hours are rounded off to the quarter hour, so it allows for .25, .50, .75, and .00.
View 4 RepliesI am trying to put a range validator on a date entered by a user. However, I want the minimum date to by dynamic to only have a user with a DOB which is over 17 yrs ago. Is there a way to put a dynamic value i.e Date.Now() - x;.
View 11 RepliesI have a textbox1, want to set a minimum length of atleast 8 chars, how to do the min length validation.
View 7 RepliesBackground - I've started with a VS2010 dynamic data project, but now I want to add some other custom pages based on MVC to it. Question - What is the minimum I would need to do to get this non-MVC project to look/act like an MVC project?
View 6 RepliesWhat is the regular expression for accepting password that should accept only 8 characters
Presently iam using this one [a-zA-Z0-9]{8,}$
But it should not accept Special Characters
My Requirement is to Minimum Length of Password Should be 8 Whether it may contain Special Characters, Special Character are not Required Password Should be 8
When i set Minimum to below 100 or 100, the NumericUpDownExtender is work as expected.
<asp:TextBox ID="TextBox3" runat="server" />
<ajaxToolkit:NumericUpDownExtender ID="NumericUpDownExtender1" TargetControlID="TextBox3" Minimum="100" Maximum="3000" Width="50" runat="server" Enabled="true">
</ajaxToolkit:NumericUpDownExtender>
Now change the Minimum to more than 100, let's say 101, it won't work.
This my code:
[code]...
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:
[Code]....
I get this error on line 39 -"Server does not support secure connections.".
[Code]....
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)
My ISP manager complains that my pages open too many connections and it should be dealt with immidiatly.Now, i'm not sure what exactly he means.Most of my pages look something a like : Two drop-down-lists, one gridview, and few other controllers.now, MOST OF THESE CONTROLLERS POST BACK AND FETCH INFO FROM THE DATABASE.each of the eventhandler create a new connection instance, open a connection, fetch info, and than closes the onnection.Thing is that many users visit the site at (probably) the same time, so i was wondering how could I decrease the number of connections?Perhaps making sure that the connections do close immidiatly post command execution?
View 7 RepliesIs 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;
[Code].....
I have an mschart control which is databound in code-behind. The Y axis values can vary from vary small to very broad. So the range is set to auto. This works fine except when the values in range of 0 and <1.
In this range the axis only has a zero, it does not have a "1" at top. Is it possible to set to dynamically set the maximum? So if the maximum value is less than one, still show a one.
i.e. get maximum value and set the Y axis maximum = maximum value +1
I am re-loading the Oracle 10g client on my .NET development machine. This Oracle client install is not the most intuitive and I just would like to know what the bare minimum client install is to run my ASP.NET project and what selection do I need to make at the beginning of the install process?
View 1 Replies