Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

请教一个sqlserver数据库连接的问题

WBOY
Release： 2016-06-07 15:33:30
Original
1104 people have browsed it

我使用oledb进行excel的导入导出工作，导入数据量不算小大约多的时候大约在4W左右。 今天访问突然出现了 问题 ，查了一下发现是 数据库 连接 池用完了。然后查看了一下 数据库 连接 发现有大约600个左右的 连接 ，其中550个都是oledb 连接 ，且全部处于睡眠

请教一个sqlserver数据库连接的问题

我使用oledb进行excel的导入导出工作，导入数据量不算小大约多的时候大约在4W左右。

今天访问突然出现了问题，查了一下发现是数据库连接池用完了。然后查看了一下数据库连接发现有大约600个左右的连接，其中550个都是oledb连接，且全部处于睡眠状态。

我已经确定我所有的Oledbconnection操作完之后都关闭了。但是为何这里会有那么多的连接？我明明已经close()了。怎么还会存在那么多睡眠的连接？

谢谢了

Related labels：
o sqlserver use database connect question
source：php.cn
Previous article：使用SqlDependency监听SqlServer2005数据库变更通知 Next article：mysql 导入导出数据库以及函数、存储过程的介绍
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Scatterplot points do not maintain values ​​when zooming in d3.js This is my first time using d3.js, so please bear with me. I implemented it as pure JavaSc...
From 2024-04-06 18:16:26
0
1
403
The entity warehouse extends JpaRepository<Entity, Id> and JpaSpecificationExecutor<Entity>, and EntitySpec extends Specification<Entity> This is my endpoint http://localhost:8080/country/all replies are ok for all countries and...
From 2024-04-06 17:11:03
0
1
421
Why does omitting 0ms sleep break my css transitions? I'm trying to implement a FLIP animation to see if I understand it correctly. In this code...
From 2024-04-06 16:29:50
0
2
490
Invalid React child element (found: Object with key {clientVersion}). If you want to render a collection of child elements, use an array instead I have a multi-step form and when I try to submit it shows this error. However, if I use c...
From 2024-04-06 16:25:39
0
1
346
How do I get my image to appear on the page's main display? What I want to do is receive some photos using NASAAPI. These photos are then displayed on...
From 2024-04-06 15:33:12
0
1
433
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template