is your Anti-Virus Strangling SQL Server?
Its very common when I arrive on site to do a performance review or some tuning that a good first place to look for is windows task manager and anti-virus. By selecting View-Select Columns we can add interesting counters such as Threads, Handles, I/O Reads (since start-up) and I/O Writes since start-up (a sample is below) The screenshot above shows that while anti-virus has only read 10% of the bytes of SQL Server, it has performed three times as much read I/O as the read activity isn’t as efficient as SQL Server – its a lot more ad-hoc with smaller avg read sizes. If Anti Virus exceptions are not configured, its possible for the Anti-Virus to consume many times the I/O’s of SQL Server which can really hamper performance
Here is the original:
is your Anti-Virus Strangling SQL Server?
Submit Links to Social Bookmarking Websites Automatically! Get Thousands of Visitors! Increase Website Traffic and Income with Automatic Social Bookmarks Submitter. Prepare to upgrade your servers today – you will have thousands of real and highly targeted visitors who will make you the money like crazy!