Select the product you need help with
Use of system filter drivers can lead to SQL Server Database Engine performance degradation and consistency problemsArticle ID: 2454053 - View products that this article applies to. SYMPTOMSYou might encounter the following symptoms when certain filter drivers are loaded into a system that is running Microsoft SQL Server components:
CAUSEFilter drivers can be installed on a system as part of the Setup program of an application to provide a certain kind of functionality. Examples include antivirus protection, online backups, encryption services, and data compression or defragmentation facilities. These filter drivers insert themselves into the Windows driver stack to enhance or alter the behavior of requests that pass through the driver stack and that are intended for a device. Under some conditions, these requests may either take a long time to complete or consume excessive resources. When this occurs, various problems occur that are discussed in the "Symptoms" section. Also, there might be some form of incompatibility between the different filter drivers that are present in the same driver stack and that could also lead to some of the problems that are discussed in the "Symptoms" section. RESOLUTIONThe general approach to resolve these situations is as follows. Note See the "More Information" section for more information about each of the following steps:
In some instances, you may have to perform all these actions. Refer to the "More information" section for instructions that are specific to certain filter drivers. MORE INFORMATIONMicrosoft Customer Support and Services team (CSS) had identified the following filter drivers that can cause the symptoms that are mentioned in this article. This list will be updated when new issues are found. This list is provided to help with the identification process that was described in the "Resolution" section. Finding the problematic filter driver typically involves collecting an iterative set of diagnostic and tracing data when the problem occurs. The following filter drivers that can cause performance and stability issues for SQL Server:
Collapse this table
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products. Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information. The information and the solution in this document represents the current view of Microsoft Corporation on these issues as of the date of publication. This solution is available through Microsoft or through a third-party provider. Microsoft does not specifically recommend any third-party provider or third-party solution that this article might describe. There might also be other third-party providers or third-party solutions that this article does not describe. Because Microsoft must respond to changing market conditions, this information should not be interpreted to be a commitment by Microsoft. Microsoft cannot guarantee or endorse the accuracy of any information or of any solution that is presented by Microsoft or by any mentioned third-party provider. Microsoft makes no warranties and excludes all representations, warranties, and conditions whether express, implied, or statutory. These include but are not limited to representations, warranties, or conditions of title, non-infringement, satisfactory condition, merchantability, and fitness for a particular purpose, with regard to any service, solution, product, or any other materials or information. In no event will Microsoft be liable for any third-party solution that this article mentions. PropertiesArticle ID: 2454053 - Last Review: June 4, 2012 - Revision: 3.0 APPLIES TO
|  |
Back to the top
