IMO, the most important aspect of internet security is to sit behind a firewall, which is typically a NAT firewall living in your modem/router. In addition, Windows has its own built-in firewall. These protect against malicious inbound connections, port scanning attacks etc.
Due to this inbound protection, the only way malicious software can get a foothold on your computer is via an outbound connection you make (unless you do something really crazy like run a nasty executable).
So as long as you're careful enough to not visit dodgy websites, open obviously su****ious emails etc. (and especially not clicking any links in such), all should be well. In addition, I would suggest not to open any ports though your firewall (i.e. don't provide external services) unless you know what you're doing.
I personally just use the built-in AV software that comes with Windows 7, ' Windows Defender' I think it's called, and it's never caused any performance issues for me. A reasonable policy would be to always make sure your AV software is active if you're accessing the internet, but otherwise you could disable it if you find that it affects performance of the DAW software. A regular scan of the file system's not a bad idea either, schedule it for when you're not using the computer.
[edit, why the hell is 's u s p i c i o u s' dumped upon by the forum's word filter? :-(
edit 2: I think I know why now, that really is quite far beyond stupid]