Well, the guess-days might be just about over for SQL Server DBA’s. People who revolutionized Oracle performance tuning several years ago, are now working at SQL Server revolution.

Look what Anjo Kolk had to say about at the interview during Miracle SQL Server Open World 2008:

And here is Cary Millsap from the same event:

If you find a bit unusual how those interviews were done, check Cary Millsap’s blog (keyword - SlowTV).

If you look at the agenda of the Miracle SQL Server Open World 2008. You can see that Mario Broodbakker was one of the instructors of the “Stop Guessing” performance workshop. You might also know that about a year ago, Mario published couple very interesting articles.

Unfortunately, based on what I can conclude from Mario’s articles, SQL Server 2005 wait interface is implemented only on global database level and session level collection can only be achieved by a hack. I’m a bit disappointed that www.sqlinternals.com doesn’t seem to reflect an original content anymore (though it’s useful if you live in Old While Hill Stuarts Draft, VA). I would think that it could also be implemented with some debuggers but it probably not for production use either.

Anyway, it’s a good start and it seems that it’s only the beginning. Keep an eye on those guys!

Find more about  , , , ,

3 Responses to “SQL Server Performance Diagnostic — Still Guessing?”  

  1. 1 Gints Plivna

    Two comments:
    1. Some old content can be found in web archive here http://web.archive.org/web/*/www.sqlinternals.com
    2. How about new SQL Server 2008? It can be downloaded as something like beta from MS site. It is interesting are there any improvements there regarding this subject?

  2. 2 mario broodbakker

    Hmmm, it looks like my website is hijacked..
    Need to do some work here.

    I upgrade the sql2005 stuff until a very recent release, something SP2′ish.
    For, eh, legal/corporate(employer/business guest at MSFT) and so reasons I stopped this hacking work.

    In SQLServer 2008 there is still no dmv (v$ for Oracleites) view per session or so.
    But there is something really new and interesting that can present wait events: XEvents.
    With XEvents you can trace every wait ( and a lot of other events) and get extra context information when they happen.
    I presented on this subject on Miracle’s SQLServer Open World. An abstract for PASS2008
    was rejected last week :-( Probably everybody in the SQLServer world already knows
    so much about XEvents and Wait event based profiling..

    There is a simple-talk.com paper in the making…

  3. 3 mario broodbakker

    My site is back..

Leave a Reply


  • group sex parties in dallas tx
  • virgin babbysitter pussy cock
  • panama hardcore xxx encounters
  • jessica alba bikini photo gallery
  • Japane girl sex
  • girls in panties free pics
  • shy young anal
  • pictures of rob wife
  • lesbians massage licking kissing ass
  • asian nudes vids
  • blonde tits video
  • hardcore nude videos
  • homemade video blowjob
  • barely legal girls naked pics
  • mature women nude vids
  • barefoot girl teens blonde cum
  • girls young shaved
  • ebony bukkake movies
  • Pamela anderson lesbian videos
  • nude male erotic photography galleries
  • mature suck movies
  • young girl with black guys
  • abu dahbi young girls
  • gallery tits and heels
  • tigh little pussy
  • big wet butts laura lion iki
  • teen asian model photos
  • free pics of naked centerfold babes
  • home teen creampie sex videos
  • erotic asian
  • sex man pics
  • z sexy body builder fuck
  • Sexy teen video free
  • pink black weing pictures
  • janet mason star anal
  • high definitio long video blowjob
  • sexy wife doing prostate massage
  • Hot girls tattoo
  • black lesbian bay area california
  • free streaming asian slut
  • alfani petite dress
  • best position for male anal sex
  • shawna lenee anal pictures
  • naked young teen models bj videos
  • daily blooper vids
  • Australian girls xxx
  • handjob video daily cfm
  • video maried sex
  • erotic video story
  • latina pussy getting banged
  • you tube babes having stockings sex
  • straight girlfriends fuck each other
  • erotic vulva tantric massage video
  • cheating wives that fuck their son
  • very horny young girls
  • black girl from
  • pro wrestling sex video
  • young sex serch
  • Teen showing tits
  • video methods for orgasm
  • Sexy asian girl dancing in bikini
  • hot jigglely ass fucking videos
  • girl flashing streaming
  • teen bj pictures
  • black soldiers wife
  • lesbians and tits
  • sex church x movie
  • free naked farm girls
  • Anal fingering galleries
  • priva interracial blackzilla pics
  • hairy bear movies solo cumshots
  • Free nude teen suck movie
  • couple seduce young teen sex vids
  • teen naked asian
  • free girl next door
  • dreadlocks hippie video
  • pantyhose mature slut videos
  • japanese american girls
  • wife sex party pics
  • fabulous free lesbian
  • asian babe video gallery
  • hardcore fisting video
  • asian japanese lesbian love
  • pics pussy ass and tits
  • black men with big bubble butts
  • mom and daughter pussy pics
  • common interracial vids
  • exposed pussy shorts bikini
  • young grils tits
  • orgy sex video
  • two lesbians forced to fuck
  • ffm threesome sex photo
  • teen girl masterbatin wit a toothbrush
  • ben galleries gwen sex
  • wives fucking young boys
  • latin hardcore sex pics
  • large pussy black women
  • naked pamela anderson sex tape
  • free webcam sex illegal
  • sex xxx rss feed
  • japanimation drawing of women and girls
  • orbita young model galleries
  • hot sexy twins naked
  • petite anal lesbian
  • Watch teen video
  • teen faces misdemeanor for sexting
  • mature orgasm pics
  • girls asian inspired bedroom
  • nude women with petite waists
  • Sex interracial videos
  • Oral sex with genital herpes
  • girlfriend keeps flashing
  • black girl on rock of love
  • best sex ever video series
  • mature sexy womem
  • naked girls video torrent
  • Indian girls boobs photos
  • Pornstar sex xxx
  • ava rose pussy
  • pics of asian schoolgirls
  • modest clothes christian young girls
  • big blacke tits
  • asian yellow movies
  • naked young nn girls
  • orgasm women videos
  • free black big tits
  • free sex lick dick suck
  • girls sucking cock cum videos
  • sex machines pictures
  • asian contortionist sex video
  • sweet petite brunette
  • why i started giving oral sex
  • oops video naked
  • girl fucked till pussy bleeds
  • russian model pussy fuck
  • korean bondage hardcore
  • collegegirls black malestripper
  • Emo lesbians having sex
  • lesbian chicks free demo
  • full length teen xxx videos
  • english translations of le petite prince
  • erotic stories girl dong
  • mature fuck young teen boy
  • mature stockings galleries
  • La salle sex scandal video
  • close look at pussy ass
  • black female ass
  • sexy small asian girl
  • mature japanese men videos
  • mexican girls sex movies
  • retro butts pics
  • gallery free sex ass
  • houston sex movies
  • free ass fuck
  • d fuck movies
  • two black men white woman anal
  • trannies fuck women videos
  • tera patrick threesome lesbian
  • bees black sex page
  • nnormal couples having sex
  • free xxx vids shemale
  • pussy cum shot thumbs
  • free movies japan av
  • ebony black trube
  • Fuck girls vedio
  • blow up wife video
  • movies sweet young pussy
  • videos casting
  • free download asian dvd rip
  • naked girls that are having sex
  • putting heels in pussy tube
  • oral sex during ovulation
  • amatuer video two girls showering
  • videos of wild girls
  • wives ws anal sex video
  • faces of orgasm pics
  • Nude wives pic
  • pretty nude girl movies
  • freeschool girl
  • tiger woods girlfriend naked
  • erotic sex illustrated threesome story
  • Hot nude hunks
  • young straight boys sex videos
  • hot teen tits sexy
  • teen girls butt fuck
  • watch free adult ebony xxx online
  • a sex movie tube
  • japan swimsuit babes
  • sex positions for women to orgasm
  • orihime naked pics
  • blowjob patient video
  • ian sex videos
  • black saks video
  • fuck asses sex
  • lesbian sex older young teacher
  • free sexy young party pictures
  • ass creampie eating girls
  • video of a handjob
  • funny oral topics
  • teens fuk vids
  • ebony latina nude pics
  • obese big black girls
  • boobs pussy free
  • small tits sybian teens movies list
  • voyer video
  • teen dares xxx
  • young cz girls
  • Lesbian strippers videos
  • pain during oral sex
  • outdoor sex with my wife
  • asian street meat free pictures
  • Naked ladies on beach
  • free wife thumbnail galleries
  • free thai girl sex videos
  • sexy ebony with huge
  • blowjob hippie
  • star movies on tiava
  • free sex video rubbing cocks
  • house party
  • teacher having sex with student video
  • swingers dvd sex moviers
  • hifh school sex party video
  • Shania twain nude video
  • pictures of nipples with infection
  • couple argue about anal sex
  • amateur wife cum facial
  • free big breast teen movies
  • skinny shaved pussy on beach video
  • pics of young boys
  • gianna micheals first anal sex
  • aged pussy in houston texas
  • free solo teen play videos
  • asian anal escorts
  • black tusk reality
  • sex ametaure videos
  • kim rell naked videos
  • mom big dick two girls
  • streaming black sex
  • spread pussy big tits
  • free xxx ebony shemale sex videos
  • young nude teens in pantys
  • free hardcore pictures of seka
  • asian girls groped
  • free ass and nylons pics
  • hot asian girls free pics
  • Naked model pics
  • chubby young teen pussy movie
  • how does anal sex videos
  • Porn hub interracial
  • britney spears paris hilton shows pussy
  • videos of girls makingout and touching
  • naked girl pics trailers
  • pussy lick teen movie
  • granny mature galleries
  • teenie boppers sex movies
  • mature japanese women shit eaters
  • watch free videos sex
  • my asain wife naked
  • my butt sweats during sex
  • thailand princes naked girlfirend
  • free milf seduces teen video
  • Gigantic ebony tits
  • flat chested anal teens
  • mature women group handjob
  • cow butt pictures
  • Light skinned girls nude
  • married interracial secret sex