Antivirus Excluding SQLServer

Question

Hi All,


How to find how much memory is using by the Antivirus in our production db server?
How to determine how this cause to performance degradation.

Please advise me.

Thanks and Regards,
Ravi.

Answer 1

>>>How to find how much memory is using by the Antivirus in our production db server?

It is possible that Antivirus has more than one processes in Task Manager, so please take a look at Memory  tab.

>>>How to determine how this cause to performance degradation.

Slowness?  http://blogs.msdn.com/b/john_daskalakis/archive/2008/12/03/9169624.aspx

---

Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing

Answer 2

Hi

You could use Performance Monitor (perfmon.msc) counters i.e. 'Process -> Private Bytes' & 'Process -> Working Set' for the Antivirus service account as a start.

The Description section in Performance Monitor gives an insight into what the counters monitor.