ASP.NET Tracing
What I learned today:
1. .net tracing is freaking awesome. Talk about being able to pinpoint your problems! Sheesh! I wish I had this a looooong time ago.
2. My db server needs more ram. I guess 512 isn’t enough 
All this time, I figured it was my code, or possibly something with the web server that was causing my site (BodyMod.org) to run so slow. Nope… DB server. I ran some trace events tight around all the DB calls, and low and behold, that’s where all the time was coming from. Up to 15+ seconds for a DB call!
So I head on over to my db server to check out whats up. I pull up my task manager and see cpu at 60-70% ( not great, but not bad ), and my ram usage at about 615 out of 1024. Not bad either. So wtf?
Oops… only 512 of that is physical. the other 100 is virtual. Crap.
So, I sent an IM to my server guy (it’s 5am, so I doubt he’s up) that I wanted to buy some more ram. I figure with prices the way they are, I’ll bump it up to 2gb =)
Better be the miracle fix I was looking for.
So to all you bmod members out there, hold tight, it’s about to get crazy fast! (probably not, but I dream big =)
Discussion Area - Leave a Comment