Database Management and Programing Article

  Q: If I need to have SQL Server running on the machine running virus scanning software, what to do will not affect performance »    A: This depends on the answer to the question you want to run the type of virus scanning software.    There are currently three types of virus scanning software - active virus scanning, virus elimination and vulnerability scanning. 

  Active virus scanning software we recommend will be active virus scanning for the following SQL Server Use: 

  Running on the Internet. 
  Read and the implementation of the documents from other servers. 
  HTTP server running, such as Microsoft Internet Information Services (IIS) or Apache.    If you are using XML for SQL Server (SQLXML) by the IIS on the HTTP access SQL Server, then it applies to your operating environment. 
  Host file-sharing. 
  Use SQL Mail handling incoming and outgoing e-mail. 
  The main performance overhead for the opening and closing documents.    Although the initiative virus scan may result in heavy-duty machinery on the apparent loss of performance, but for security considerations, it is still recommended the use of virus scanning software. 

  Clear virus software if the software had to remove the virus scanning documents SQL Server database, SQL Server will be because I / O subsystem lot of reading and lead to lower performance, especially in the larger number of documents on the server.    If the software to open a file to be scanned, and you also opened the SQL Server, the database software will be marked as "suspicious", so that the database service disruption. 

  It is worth noting that this type of software in the virus has penetrated your hard drive after the entry into force.    Therefore, the best in your body through the use of reliable security operation, take preventive measures. 

  Vulnerability scanning software vulnerability scanning software mainly for the HTTP server.    This type of virus scanning can be very good to remove potential loopholes.    Loopholes in the use of scanning software, Microsoft SQL Server not aware of any loss of performance. 

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.