Use connection pool
Wang ranMicrosoft Certified lecturerWangran@itgoldenbridge.com
Click "add MSN robot"Download the msdn Chinese network broadcast course for you!
This course includes? Connection Pool? Use a connection pool? Ma
Document directory
Performance bottleneck
Performance counters
Monitoring servers are a key part of server management..By using appropriate monitoring tools, you can detect server problems, evaluate the results of website content changes, and plan upgrades to facilitate your access to the site. Select an appropriate monitoring tool and method based on the i
rebuilt, ensure that the Connection object obtained from the Connection pool is available. Of course, to ensure absolute availability, you can also use testOnBorrow to be true (that is, to check the availability of the Connection object), but this will affect the performance.
To perform SQL
Symptom
The IIS application pool crash (crash) has the following features:
1. From the client, the browser is always in the connection status, and the Web server does not respond.
2. From the server side (Windows Server 2008 + IIS 7.0), an error with event ID 5010 will appear in the event log:
A process serving appli
We monitored the SharePoint ontology in the previous section, and this section provides comprehensive monitoring of the IIS services that the SharePoint site service relies on.IIS is the Internet Information Services Internet Information Service, not only for SharePoint Products, but also for Web services in other Microsoft products, based on IIS services. such a
mechanism exists, there is always a truth about it. Since it is so painful to create a new connection, why not reuse the existing connection?
In fact, ADO. NET has provided us with an optimization method named connection pool.The connection pool is a container that stores
care why there is such a mechanism, there is always the truth of it. Since a new connection is so painful, why not reuse existing connections?In fact, ADO. NET has provided us with an optimization method called connection pooling. A connection pool is one such container: it holds a certain number of physical connectio
program connection problem) > and then I thought, "Can I create a few more application pools and then separate the Web site to prevent the bug affect other sites! (In IIS There's an application pool on the left, where you build it, and then point to the application pool of the Web site or folder to the one you c
Original article: http://www.codeproject.com/KB/dotnet/ADONET_ConnectionPooling.aspx
1: Merge database connections
Establishing a connection to the database server consumes a lot of system resources. If a system needs to query a database service, you must first establish a connection to the database and then perform the query.Can you feel that when you use the same query on the client to submit the qu
The IIS Global active flushed Entries active flushed Entries is a cached file handle that closes after the current transfer is complete. The IIS Global object.Web Anonymous users/sec The number of anonymous connections that users make through the Web service.the number of BLOB cache refreshes that IIS Global blob cache flushes since the server started.Total numbe
Label:
Brief introduction
Usage evaluation
Project Home
DBCP
DBCP is a database connection pool that relies on the Jakarta Commons-pool object pooling mechanism. DBCP can be used directly in the application
You can set the maximum and minimum connections, the connectio
1. The error log file is as follows:
Note: The file is located in the C: \ WINDOWS \ system32 \ LogFiles \ HTTPERR directory.
In addition, IIS also has a log, which is specified in the Properties window below.
After analysis, this error log mainly contains three types of errors
10:43:27 203.208.60.20.48675 210.192.111.49 80 HTTP/1.1 GET/showroom/vulpes/product-detail/LRPST/Rubber-Series-2006987705 export MyApplicationPool: this error ind
Some customers say they found that the current number of connections in the WEBLOGIC92 connection pool (active capacity) is less than the initial connection number (initial capacity) through connection pool monitoring. On the phen
A netizen said that IIS 7.5 always reports a 503 error. The author gave it a remote connection and began to suspect that it was a problem with IIS settings. For example, the. NET version and application of the application poolProgramThe version is inconsistent, or there is a problem with the website binding. Find the correct reason. Think of a try. in the case of
Label:
Brief introduction
Usage evaluation
Project Home
DBCP
DBCP is a database connection pool that relies on the Jakarta Commons-pool object pooling mechanism. DBCP can be used directly in the application
You can set the maximum and minimum connections, the connection
The Microsoft OLE DB Provider for Jet driver is not supported on 64-bit operating systems,Earlier Microsoft Access Driver (*.mdb) connections are also not supported.Causes the database connection string inside the program to not work correctly.Need to modify the work environment under IIS to 32-bit,In the Administration interface of IIS, enable the 32-bit mode in
We all know that ADO. Net comes with a link pool and is enabled by default. If not set, the maximum number of connections allowed is 100.
So how can we see the number of active connections in the connection pool?
After talking about the research, we found that a stored procedure in the data can help us, that is, sp_who
To verify this, we wrote an Asp.netP
/cpu, n is the number of threads, and t is the number of physical connections created each time. The test result is about 5-10 ms, the cpu is the number of CPUs of the current machine. In addition, the server load also affects the network usage. To avoid creating as few physical connections as possible during high concurrency, we can increase the Min Pool Size appropriately, but not too large, this is because the number of TCP links for a single machi
efficiency will be higher. Index Division: for example, Department numbers. Each workshop only stores part information of its own workshop, and divides the information of each workshop into separate tables for more convenient query. Longitudinal cutting:This is the so-called column cutting. When using big data, the number of columns directly affects the access effect.
Instance segmentation:It is to abstract the Common Business parts and store them in different databases. For example, account
connection string
See the following link for sqlconnection. connectionstring Property
Effect of IIS recycle application pool on Connection Pool
Asp. net program, we will find that if the website is not accessed for 20 minutes, it will be slow to access again, because
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.