Coffeehouse Thread

11 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

Perf and Stability of the site

Back to Forum: Coffeehouse
  • User profile image
    Sampy

    So I made a bunch of database optimizations last week to fix some CPU issues we were having on our database server. We got a DB trace that covered an hour of time and I fixed up every query that was running longer that 25 seconds (turns out it was just two). I deployed those fixes (one was a new index and the other was a change to a sproc) Wednesday and Thursday of last week.

    I was back east at a wedding all weekend so I didn't use the site much. Orcs didn't send us any "THE SKY IS FALLING!!!" emails so at least I didn't break it. You guys notice a decrease in random failures and crashes at all? Is the site speedier?

    If you're not seeing improvements, is there anything that is consistently slow? We have some app pools that like to overzealously recycle so that's probably the cause for random errors but if there's anything that you can repro let me know.

    Fixing up SQL queries and staring at Query Plans is a strange kind of fun. Taking a query from an estimated cost of 178 to 3 is quite the ego booster (as I'm sure everyone on the team can tell you as I've bragged about it 5 or 6 times). Thanks to Inside Microsoft SQL Server 2005: T-SQL Querying for my newfound SQL tuning powers.

  • User profile image
    W3bbo

    Well I haven't seen any error message after posting, so I guess that did the trick.

    Thing is though, why did it take over a year and a half to get fixed?

  • User profile image
    ScanIAm

    W3bbo wrote:
    Well I haven't seen any error message after posting, so I guess that did the trick.

    Nor I, but it was pretty sporadic.  We'll have to wait until the next flamewar and see how it handles Smiley

    W3bbo wrote:

    Thing is though, why did it take over a year and a half to get fixed?
    Thank you.


    There, fixed that for ya.

  • User profile image
    Simo

    Sampy,

    I had a DBA once who would email round the top20 misbehaving SPs once a month. The table was based of a column of cost * frequency (ie number of times sproc was executed in sample). Data collected over decent sample.

    It was damn good at catching those bits of code/Select sprocs that have ended up being called far too frequently for their own good.

    Shaming in front of your peers also being an effective tool for encouraging fixes. Or allowing the young whipper snapper on the team to step up and show what he's made of. Wink





  • User profile image
    mig

    Is it just me or does Sampy seem to have a soft side for kids stories?

    "oh noes!! the sky is falling!!" <- haven't heard that since grade school!

    On the other hand, the site does seem to be more responsive for me today, but it could just be me imagining things Tongue Out

  • User profile image
    littleguru

    Thanks Sampy Smiley

  • User profile image
    Angus

    Thanks, the search seems to be working a lot better. Before I was trying to do a search for all posts by user "Angus", and it would throw an error every time. I just tried it now and it works fine.

    Angus Higgins

  • User profile image
    Sampy

    Angus, that was the worst behaving query by far. Almost every call timed out.

    I'm working on a blog post describing exactly what I added to fix things up.

  • User profile image
    eddwo

    Thanks for that.

    So we can start using accessing more per-user RSS feeds without them failing to update most of the time now?

  • User profile image
    littleguru

    eddwo wrote:
    Thanks for that.

    So we can start using accessing more per-user RSS feeds without them failing to update most of the time now?


    I wonder I should run some of the queries with the LINQ thing again. I wonder if we are faster now... *trying*

  • User profile image
    littleguru

    Sampy is there a way to speed up RSS feeds? I get sometimes a very long time to wait until I get the response for a feed... Especially on thread feeds.

    Edit: Now I even got a timeout.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.