First time here? You are looking at the most recent posts. You may also want to check out older archives or the tag cloud. Please leave a comment, ask a question and consider subscribing to the latest posts via RSS. Thank you for visiting! (hide this)

lessons learned

There are 1 entries for the tag lessons learned

When Subtext DB gets out of control (and how to fix it)

During the last weeks I noticed that my blog was becoming slower and slower (and if you visited my blog you might have noticed it as well). After a bit of troubleshooting on the server (which was kind of painful due to the slow connection via RDC from Europe to my server in the US) I figured out that most of the slowness came from my SQL Server Express instance that was taking up too much memory. And I found out that I had 3 tables that were extremely big in size: Subtext_Log -...