Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > SQLSERVER 18056 错误解决办法

SQLSERVER 18056 错误解决办法

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-07 17:49:18
Original
2483 people have browsed it

SQLSERVER 18056 错误解决办法有需要的朋友可参考一下。

解决办法：
0.首先排除DB是否有死锁
1.最直接的办法就是增加IIS连接池大小
2.就是找出程序中大的会话请求，修改代码
3.限制IIS进程数上限,根据日常运行情况设置连接池大小(不推荐，迫不得已)
4.数据库端限制sql回话时常:SQL防火墙或数据库限制长连接(不推荐，迫不得已,没办法的办法)

Related labels：
iis sql sqlserver
source：php.cn
Previous article：SQL Server数据库死锁原因与解决办法 Next article：通用分页存储过程(SQL Server 2005)
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
iis configuration
From 1970-01-01 08:00:00
0
0
0
IIS has built a website using port 80. Apache cannot be started. How can I make IIS and apache share port 80?
From 1970-01-01 08:00:00
0
0
0
How to bring up iis mode in phpstudy
From 1970-01-01 08:00:00
0
0
0
Server - How do IIS and Apache coexist?
From 1970-01-01 08:00:00
0
0
0
phpstudy integrates iis, can you customize the php version of different sites?
From 1970-01-01 08:00:00
0
0
0
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