I'm using a machine running Windows XP SP3 to develop .NET applications. I use VS2010 with SQL Server 2008 and Office Professional 2007. The machine has 2GB of RAM.
After I work for a short period of time, VS 2010 becomes resource-hungry. It starts consuming 500-700MB of memory, and SQL Management Studio uses between 1-2GB of memory. Then Windows becomes sluggish and crashes, or I need to restart. I'm also using Trend Micro Office Scan client. It's not possible for me to have viruses or threats as the admins check for threats every night. The issue happens when VS 2010, SQL Management Studio and Office (Outlook) are open at a same time.
Also, if I leave VS minimized for 10-15 minutes, it hangs. All copies of software are licensed and genuine. What's going wrong, and how can I fix it?