If I need to run virus scanning software on a machine running SQL Server, what do I do without impacting performance? This depends on the type of virus scanning software that you want to run. There are currently three types of virus scanning software-active virus scanning, virus cleanup, and vulnerability scanning. Active virus scanning software we recommend that you use active virus scanning for the following SQL Server usage scenarios: run on the internet. Read and execute files from other servers. Run an HTTP server, such as Microsoft Internet Information Services (IIS) or Apache. If you use XML for SQL Server (SQLXML) to access SQL Server via HTTP on IIS, it applies to your operating environment. Host file sharing. Use SQL Mail to process incoming and outgoing e-mail messages. The main performance cost is to open and close the file. Although active virus scanning may cause significant performance losses on heavy duty machines, it is still a recommended virus scanning software for security reasons. Virus cleanup Software If the virus cleanup software has to scan the SQL Server database files, SQL Server will degrade performance due to the large number of read operations on the I/O subsystem, especially on servers with a larger number of files. If the software opens a file for scanning and you open SQL Server at the same time, the software will mark the database as "suspicious", causing the database service to break. It is worth noting that this type of software does not take effect until the virus has invaded your hard disk. Therefore, it is best for your organization to take precautions by adopting reliable and safe operations. Vulnerability scanning software vulnerability scanning software primarily targets HTTP servers. This type of virus scan is a good way to clear out potential vulnerabilities. Microsoft did not notice any SQL Server performance loss when using vulnerability scanning software. The responsible editor Zhao Zhaoyi#51cto.com TEL: (010) 68476636-8001 give force (0 votes) to be tempted (0 Votes) nonsense (0 Votes) Professional (0 Votes) The title party (0 Votes) passing (0 Votes) Text: Run virus scanning software on the computer where SQL Server resides Back to network security home
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.
