Im getting nasty performance on my server.
It happens radmonly while accessing a website, but more often, right on the first time I load it. The server/webapp are still in dev, so I'm the only one accessing it.
Specifically, timeout expired error. Can only post one link, so screenshot follows...
I started running perfmon on the Database VM and after a couple page loads, got it up to 100! Here's the screenshot.
When it went to 100, it still loaded the page, there was just a delay. On the other times, I can imagine it went higher.
And, apparently it cuts off at 100, so it could have gone even higher, but not showing it.
This question seems to come close in describing the issue, but Im not sure what to do about it: SQL Server Slow but CPU Normal
As far as db access, my queries are all automatically optimized, via using linq-to-sql. I dont do any indexing on the db...but the load right now is just me hitting it.
so, so-far my gut is telling me its some kind of hyper-v configuration issue.
Single Server: Xeon E5520 @2.27GHz (2 processors). Windows 2008 Ent. 6gb of rame, broken down: 2GB - Parent 2Gb - DB server running SQL 2008 Web Edition 1.25Gb - Web server running IIS7 .75GB - DNS, Misc
Hyper-V was setup by hosting company, probably just double clicked and clicked next, next, next until it was done, so I'm thinking there's got to be some best practices for configuration that's going to make all the difference.