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


  • people having sex outside videos
  • movie about two jewish teens
  • free sex fast videos
  • Britney spears sex tape pictures
  • girls with dicks free porn
  • Melissa ford naked pics
  • pussy from gymnastik
  • amatuer sex video threesome
  • gorgeous shaved girl toying with sybian
  • big round nice ass pics
  • pornotube amature blowjob deepthroat
  • shemale young porn
  • wife pictures shared
  • my ex girl frieng orgy videos
  • sex japan muslims marriages
  • sexy girl with tattoos
  • videos of older adult sex
  • hardcore free video big asses boobs
  • girl fucked on city bus videos
  • Kiss hot girls
  • college girls sex amateurs new
  • female young model porn
  • The tribe sex scene
  • amateur girls fucking on video
  • free online lesbian porn videos
  • free girl sex pic
  • sexy ebony solo youporn
  • Teen hard pics
  • anal sex on sybian
  • xxx hardcore couples
  • young shaved camel toe
  • buffalo mature women sex
  • naturism female beauty pic galleries
  • free ebony gaggers porn tubes
  • erotic french movies reviews
  • closeup pictures of boobs
  • anime girl porn pictures
  • naked final fantasy girls
  • flash video sex free teens
  • Mallu big boobs
  • palestine girl strips pornhub
  • red tube senior sex group
  • pirated sex videos
  • august porn videos
  • great tits xxx free
  • mexico amateur porns
  • panty young teen stories sex
  • big round black tits
  • top black and white movies
  • teen girls self videos
  • barbi model teen free pics
  • japanese teens in swimsuits
  • sexy blonde showing some underboob
  • pictures of tara reid naked
  • hot girlfriend gives blowjob
  • softball team fuck sex
  • xxx free porn hot guys
  • Nudes on video
  • cunt closeup vids
  • japanese girls small
  • Old pics sex
  • sexy girls outdoors
  • agent kate to school girl video
  • shemale babes porn
  • fuck little girl
  • Black sex teens
  • bent over teen young
  • young mistress oral slave stories
  • movies for mature audiance
  • Housewife sex picture
  • black out party winstonsalem
  • real women home sex videos
  • titans girls video
  • vintage old and young sex videos
  • anal lube used by pornstars
  • fingering techniques with pictures
  • free xxx transexual hardcore thumbnail videos
  • free cartoon having sex video
  • movies porn farce
  • amateur girlfriends wife
  • thick black shemale
  • naked pics of vannesa ann hudgens
  • black dick oral
  • teen porn pussy videos
  • xxx chubby bigtits anal free porn
  • teen girls jewelry box
  • banger bros asian sex
  • movie star with big tits
  • amature girl webcam
  • beach breasts video
  • Pony girl sex
  • best black lesbian porn movies
  • teen girl ncie ass
  • mature andboy sex
  • teen sex hardcore shower
  • free videos girls kissing
  • free thumbs really young teens
  • White boy black girl sex
  • lesbian sex and porn
  • topless cheerleader pictures
  • japan country analysis political stability
  • greg oden naked picture
  • latin porn daisy interracial
  • tiny sexy nipples
  • girls one guy big tits
  • Girls first time having sex video
  • Lesbians naked pussy
  • free hot teen sex videos
  • interracial cum on black girls
  • amateur guys with pornstars
  • very young videos poppers
  • black male and asian female xxx
  • sophia lares pussy shots
  • mature sexy women plus pictures
  • free japan pussy
  • teens girls brests
  • bikini pictures of hillary swank
  • ny wife sucking young cocks
  • sexy brunette gets ass drilled
  • sex for hire teen
  • Naked muscle videos
  • younger babes adult pics
  • fingering young girl
  • jennifer love hewitt butt picture
  • Xxx sexy lesbian
  • girls describe first blowjob
  • porn girls and boys
  • homemade family fuck videos
  • drunk sorority girls fucking pictures
  • ideal breasts pictures
  • white cheating wife home vids
  • katie price naked videos
  • Anna paquin nude photos
  • funny sex moments videos
  • young girls naked nudists
  • daily hardcore fetish porn
  • black pretty pussy videos
  • free xxx hot porn
  • Paris hilton xxx sex tape
  • lesbian ebony footfetish
  • big sex machine video
  • wife swapping swinger video
  • girl having sex with parents
  • Hot ass latina girls
  • free anal sex moives
  • denise richards topless video
  • free porn videos asian fat school
  • Big blonde pussy
  • greco escort sexo anal
  • platinium blonde teen fucked
  • porn videos dvds
  • black bull white wifes stories
  • girl in madisons videos
  • thumbnails black pussy
  • snake up a pussy pic
  • free blowjob through nylon movies
  • barbarian shemale fuck girl
  • korean laing porn tube
  • sexy girls solo masturbation video
  • free teen facial porn videos
  • interracial cuckold amateur video s
  • cheating wives erotic stories archive
  • lesbian threesome strapon movies
  • amateur video free adult
  • anal asian lilianne
  • free hardcore porn wmail
  • pics of ashley tisdales butt
  • insatiable fuck videos
  • young blonde girl with lesbian
  • nude glamour model gallery
  • anime girl japanese picture
  • video of housewives having sex
  • teen trannys videos free
  • Teacher lesbian sex
  • young teen driving
  • carmen electra bikini gallery
  • blonde pornstars and their toys
  • drunken girl pics
  • Black hardcore sex movies
  • xxx foreign teenage girls galleries
  • Sexy young breasts
  • babysitter blowjob free video
  • porn tube amateur allure
  • chubby bushy pussy
  • girls take guys ass torrent
  • all that sex movies download torrent
  • porn i want a newgirlfriend
  • video of girls giving bj
  • black stars and celebs nude pics
  • black lesbian orgy thumbnails
  • big round asian tits and pussy
  • naked pics of venessa ann hudgens
  • sexy red with black shoe
  • young girls christina aguilera
  • free mature erotic video
  • cutie teenie girls
  • live nude blonde cam girls
  • blonde girl wearing sunglasses
  • women having sex with women naked
  • Sexy girls sexy cars
  • drug induced sex xxx
  • nylon wife gallery
  • rafaella blouses size petite
  • college girl webcam sarah
  • hot sexy teenage girl strips
  • pussy shaving long
  • male masturbation anal insertion video
  • Busty girl nude
  • wifeslut for black
  • anal sex in bus
  • petite female body building
  • hot girls with fake tits stripping
  • peeping tom sex video
  • old young forced sex
  • black ebony shemale
  • sistersister lesbian sex videos
  • sexy black lesbians eating pussy pornhub
  • free videos black girls getting fucked
  • Black vs white lesbians
  • young teen doing girl
  • white petite jogging pants
  • nude girls teen pussy
  • oral disease pictures
  • free toys and orgasm videos
  • outdoor handjob free video
  • milf babes lingerie free movies
  • flashing video public
  • little black boy insurance video
  • japanese with huge tits
  • bangladeshi private sex videos
  • Sexy black girls kiss
  • for young girls doll dress up
  • asia girl cunt picture
  • hot group sex
  • tight pussy fucked mac videos
  • chris barber petite fleur
  • totally free x rated sex videos
  • wife flashing husbands friends
  • white on black gangbang tube movies
  • posted sex vids
  • ass to pussy fucking
  • how to shave ebony pussy
  • mexican ass photos videos
  • phat black lesbian booty
  • young blonde teen gets fucked
  • videos of girls getting completly naked
  • Hot sexy girls images
  • Trisha bathroom sex video
  • free xxxpower sex
  • thick dick shemale escort in london
  • naughty naked teenagers
  • high school girls sex movie
  • porn pictures of girls on myspace
  • drunk girls videos and nude
  • anal brother sister sex stories
  • free big black booty movies gallerys
  • world erotic art pararam talespin gallery
  • florida porn star blacks on blondes
  • wives fuck for cash
  • ebony erotic nude pics
  • xxx ffm eat pussy
  • asian idols gallery
  • movies xxx free ass booty
  • big tits in glasses pics
  • free fat pussy free
  • sex parties group
  • naked girls in sheridan
  • little girl porn s
  • girls gone wild video download
  • coeds first porn video
  • chubby blonde sex video
  • nicole eggert fuck movies free
  • Is swallowing cum good
  • Porn girls girls
  • black momma porn videos
  • japanese ass virgin
  • sex women bdsm videos
  • Ass in public video
  • film girlfriend fuck stranger
  • anal amateur teenie
  • misses petite dark brown pants
  • india free images sex girls fuck
  • glamour pin upgirls
  • sexy naked black man
  • sexy big boobs babes models
  • hardest fuck videos
  • christmas nude girls video
  • celebrity nipples movies
  • bathing suit coverups with bikini picture
  • hot wet pussy lesson
  • teen sex romm
  • free female orgasm video
  • momdaughter sex vids
  • shemale trannies free thumbs pics
  • shit videos porn
  • shared wife cumshot facial compilation
  • drunk teeny bitch porn
  • photos of naked amature houswifes
  • naked young teenie girls
  • topless celebrity tube movies
  • Horny lesbians licking pussy
  • monster breasts gallery
  • videos of jessica alba having sex
  • Naked news pic
  • natural boobs asian porn
  • Polish girl sex video
  • women bikini videos
  • Sex home repair
  • spying on woman shaving pussy
  • asian fucking girls
  • girls in the nude free video
  • free sodomy sex pics
  • young teen free video sexy
  • tight girls pussy young
  • sexy chicks hot tub
  • free sexy teens gettin drilled
  • suck dick blond
  • vedios of teens having sex online
  • free black ass fucking mpg
  • fantasti cc anal videos
  • bruce springsteens american girl
  • amateur live sex video
  • ass comes out during anal
  • couples covered in olive oil pics
  • Big tit italian
  • girls getting triple penetration sex
  • pussy slut tits tranny
  • codename kids next door naked pics
  • Girls geting ass fucked
  • free dark black girl movies
  • cute teen facial galleries
  • japanese idol porn
  • ebony thick ass free gallerys
  • marla ashley darcy pussy literotica
  • video wife fucks blacks
  • Bad ass girls
  • free nice ass and tits galleries
  • xxx teen titans torrent
  • hot girl black ass
  • mature nudist girls
  • fat pussy cum tube
  • taking pussy temp
  • asian porn masterbation
  • sex seduce boy xxx porn videos
  • naked pictures blonde gorgeous women
  • college girls flashing their tits
  • sexy girls outside
  • sex videos with very young girls
  • Thick legs girls
  • teen orgasm trailers
  • erotic teen virgin sex stories
  • videoes of teen girls having sex
  • free porn adult amateur wife videos
  • introducing men to heterosexual anal sex
  • girl on top sex chair
  • s french cut bikini pics
  • punishment teenage girls
  • black jesus gallery
  • free amateur classic porn
  • Hot milf big boobs
  • finger my wet pussy
  • amateur girls sports
  • teen girls sleepover porn
  • skinny girls ass in panties
  • sexy videos amateur ass asian
  • venus interracial anal
  • Switzerland sexy girls
  • naked sexy nude chicks
  • sweet asian pussy cumm
  • Big black boob movies
  • free porn old on young
  • free teen ass sex videos
  • amateur dirty old man porn
  • handjob long movies
  • free naked pics of older men
  • free sexy nude austrilian girls
  • Latin pussy pictures
  • Big cocks in the ass
  • lesbian cuties in ffm threesome
  • asian sex chair ceiling
  • esl mouth throat picture
  • Indian sexy naked girls
  • real amateur young porn
  • cuckolding breeding pregnant wife bbc videos
  • free porn movies hentai
  • soft porn videos for girls
  • topless new york central park pics
  • petite flat chest teens
  • lindsey brigham young tube porn video
  • ok fuck my wife
  • form oral movie review
  • shemale ange movies
  • fuck that tight asian pussy
  • Adult pussy pictures
  • fuck with shopkeeper videos
  • petite petite reviews
  • movie of naked guys
  • Jordan capri sex video
  • naked girls iin public video
  • naked black girls showing their ass