


This article mainly introduces the solution to the slow speed when win2008 R2 and sql 2008 run asp. Friends in need can refer to
using SQL Server 2005 database as the background The access speed of the ASP website is slow. The situation is as follows: There are two ASP websites on one server, one is accessed very quickly and the other is very slow.
Things and steps for troubleshooting:
First, open these two websites in sequence on my computer. One opens in two or three seconds, and the other takes 10 seconds. bell. It seems that the problem is true;
Log in to the server and open the two websites in the local IIS of the server. The result is that one is faster and the other is slower. This excludes the impact of DNS resolution time and network;
Open the homepage ASP files of the two website programs and find that the website with fast access does not have a database Query, and the website with slow access has queried the database. Since the database query statements in the program are also very simple, problems with the program and database query statements are eliminated, and finally the problem is located on the database SQL Server;
Open SQL Server 2005 and there is only one database on it. Two complex query statements were executed on Management Studio, and the speed was very fast. It did not seem to be a problem with the database query speed.
The system CPU and memory load are not high. I really can't find the reason. Just open the command prompt and use netstat-ano to check the network connection. It was found that only the 1434 port of sqlserver was listening, but there was no 1433 port of sqlserver listening and connecting. However, why could the website be accessed even though there was no monitoring or connection. Wondering if sqlserver has modified the listening port.
Open the SQL Server Configuration Manager of SQL Server 2005 SQL Server 2005 Network Configuration->MSSQLSERVER Protocol->TCP/IP and find that TCP/IP is disabled in the protocol Only Shared Memory is enabled. PropertiesThe listening port set in it is the default 1433. So TCP/IP is enabled. After restarting the SQL Server service, the speed of opening the website is very fast.
The problem is finally solved. The reason is that the TCP/IP protocol in SQL Server is not turned on and Shared Memory is used to connect to the database, so website access is very slow.
The following are the supplementary methods from other netizens:Recently encountered a WEB server hard disk failure, and because the server had been running for 10 years, the WEB service was replaced. On a new server, various problems occurred after the migration. Here is a summary of the problems and solutions:
Windows2003+asp+sqlserver2000 New WEB server:
Windows2008R2+asp+SQL Server2008
Website After all the files and databases were migrated, opening the homepage, content page, and backend was normal. However, I found that the page for signing a file opened very slowly and sometimes could not be opened.
After checking the code, everything was normal and I couldn't find the reason. It felt like a problem when querying the database. Then Baidu found that the database used the memory shared connection mode, so I changed the database to the TCP connection mode. This It can be turned on, but it's still slow, taking about 5-8 seconds.
Continue to look for solutions online. Some people say that the database is not closed after querying. I have tried various methods. The last article helped me solve the problem in just a few sentences. The reason was that the database connection statement was incorrect.Provider=Sqloledb;User ID=数据库帐号;Password=数据库密码;InitialCatalog=数据库名;Data Source=数据库IP;
There is no problem with this statement under the original server, but it does not work under the new server environment.
Driver={SQL SERVER};Server=数据库IP;UID=数据库帐号;PWD=数据库密码;Database=数据库名;
The above is the detailed content of Detailed explanation on the solution to the slow speed when running asp in win2008 R2 and sql2005 and 2008. For more information, please follow other related articles on the PHP Chinese website!

asp内置对象有Request、Response、Session、Application、Server、Session.Contents、Application.Contents、Server.CreateObject、Server.MapPath、Server.Execute、Server.Transfer等。详细介绍:1、Request:表示HTTP请求对象等等。

asp扫描工具漏洞检测:1、选择合适的扫描工具;2、在扫描工具中配置扫描目标;3、根据需要,配置扫描选项;4、在配置完成后,启动扫描工具开始扫描;5、扫描工具将生成一个报告,列出检测到的漏洞和安全问题;6、根据报告中的建议,修复检测到的漏洞和安全问题;7、在修复漏洞后,重新运行扫描工具,以确保漏洞已经被成功修复。

asp开发工具有Visual Studio、Dreamweaver、FrontPage、EditPlus、UltraEdit、SQL Server Management Studio、RAD Studio、Delphi、Asp.NET和Oracle SQL Developer。

asp手动检测漏洞:1、检查ASP应用程序对用户输入的验证和过滤机制;2、检查ASP应用程序对输出数据的编码和过滤机制;3、检查ASP应用程序的认证和会话管理机制;4、检查ASP应用程序对文件和目录的权限控制;5、检查ASP应用程序对错误的处理方式;6、检查ASP应用程序对数据库的安全性;7、检查ASP应用程序的配置文件和服务器配置。

asp安全审计漏洞检测步骤:1、收集有关ASP应用程序的相关信息;2、仔细分析ASP应用程序的源代码;3、检查ASP应用程序对用户输入的验证和过滤机制;4、检查应用程序对输出数据的编码和过滤机制;5、检查应用程序的认证和会话管理机制;6、检查应用程序对文件和目录的权限控制;7、检查应用程序对错误的处理方式;8、检查应用程序的配置文件和服务器配置;9、修复漏洞。

iPhone平均售价(ASP)去年实现两位数增长,同比增长14%。iPhone13的流行是关键驱动因素,帮助推动全球智能手机市场整体创下$448B的年收入记录。尽管零部件短缺,智能手机市场仍同比增长7%,其中苹果占据了迄今为止最大的份额……市场情报公司Counterpoint今天发布了最新估计。根据Counterpoint的MarketMonitorService的最新研究,2021年全球智能手机市场收入超过4480亿美元。即使组件短缺和COVID-19限制继续扰乱全球供

方法有:1、使用专门的漏洞扫描工具;2、手动测试来发现和验证ASP应用程序中的漏洞;3、进行安全审计,检查ASP应用程序的代码和配置文件;4、使用漏洞利用框架;5、对ASP应用程序的代码进行审查。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

SublimeText3 Linux new version
SublimeText3 Linux latest version

SublimeText3 English version
Recommended: Win version, supports code prompts!
