Wrote this post in Jan 2015 as a quick draft, and remained as it is still today. I thought it’s not that useful so tried to delete it, but changed mind and released here. Hope it helps.
Recently I developed a logging server based on C#/asp.net on Windows 2008 R2 server. The server primarily does receiving log files from clients and write into database and also drop files to that server. After I released it to production, I met some unexpected issues.
1. Huge(99.9%) memory consumption issue
The logging server writes huge excessive IO to the disk and it instantly caused the os SYSTEM process to consume almost all physical memories. I searched online and analyzed it through the Sysinternals’ RAMMap. It turns out the OS’s system cache takes all the memories. You can find out details from following links:
http://www.microsoft.com/en-us/download/details.aspx?id=9258 Windows Dynamic Cache Service
KB article http://support.microsoft.com/kb/976618/
Lesson learned: Reduce the file IO as much as you can!
- Don’t forget to use the indexing
- You can figure it out whether it uses the index or not by using ‘Explain’
3. Deleting files from disk will take longer than you expect
- My initial design approach was complete wrong and failure. The server used to drop huge number of files into the physical disk, and just deleting the very small portion of files required actually even hours.
Lesson learned: Does your server collect a number of files? Store it into the database directly.