I have Avast antivirus running literally all the time on any of my computers that run Sonar, and have no performance issues from it.
I DO have every computer's Avast software's "Exclusion List" populated with specific paths where I do NOT want Avast to scan everything, and that seems to be the key to it all working well performance-wise.
So, by adding one or more paths to an antivirus software's Exclusion List, it lets Avast scan everything BUT what is contained within the excluded paths.
For MY computers. I have the following types of paths excluded from being scanned by Avast:
Sample Libraries (3+ Terabytes of samples)
Cakewalk Content (All of the Rapture Pro, Dimension Pro, Rapture, Session Drummer 3, etc.)
Cakewalk Projects
Some folks add additional libraries, but basically the sample libraries are all scanned during download and installation, and it is only after any of that when I added them to the exclusions, so the zillions of little and big files that make up the samples for the sample-based instruments are already thoroughly checked for viruses, and those files are all static - read only, other than the occasional tweak. So, they just don't need to be scanned every time I open any of them to load into a Cakewalk project.
Adding the above kinds of paths helps things run a whole bunch faster, without any weakening of my defenses - the files WERE all scanned, so, now Avast just skips all the extra overhead of checking them out every time I load a giant piano sample or whatever.
Bob Bone