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


  • pakistani girls free porn videos
  • eat her own mothers pussy
  • amber forever big black tits
  • Sexy nude girls making out
  • how fuck wife ass
  • subtitles for asian movies
  • free amatuer oral sex homemade videos
  • free audition girl fuck
  • sexy hot little girls
  • ass kiss bet sex story
  • Extreme anal fuck
  • explicite asian sex world
  • candy girl video jasmine grey
  • female orgasm anal
  • free flash porn video
  • beautiful girls the movie
  • mature lesbian teen pics
  • anal boob suck pee
  • Nude lesbians licking pussy
  • senior erotic stocking pics
  • sick anal pictures
  • pictures throat cancer graphic
  • Amateur girls having sex
  • Madoona sex scene
  • teen big boob pics
  • russian schoolgirls free porn
  • hindi movie about sex
  • lesbian mature powered by phpbb
  • hot beautiful blue eyed girls naked
  • naked pictures of girls making out
  • amateur community porn
  • christie amateur allure videos
  • crazy mature videos
  • japanese reporter blowjob
  • Nurse lesbian videos
  • long play amateur porn
  • Nude aunty boobs
  • burnette teen shows pussy
  • watch cartoon girls show their boobs
  • Anal sex pleasure
  • little april friend pussy
  • ameture black pretty pussy
  • Lady tsunade nude
  • voyeur wife gang bang videos
  • star trek porn pics
  • porn pics for mature women
  • hot ebony girl
  • little pussy art
  • natural blonde phottos xxx
  • personalized little girl birthday party favors
  • adult anal videos
  • british blonde on black
  • kim vassey topless pics
  • she loves cum in her pussy
  • Nude chicks images
  • Percentage of teens having sex
  • free site for oral porn
  • cute older women with shaved pussy
  • magazins for teen girls
  • sex video csfb
  • hot thin black chicks nude
  • ebony porno pics
  • glamour girl pictures
  • school girls deep throat
  • mature stocking and suspenders sex
  • video of girls bras
  • fat omen sex videos
  • uncensored girls next door calendar pics
  • nude young ones pics
  • mini teen fuck small teen
  • does pornstar morgan leigh do hardcore
  • full length black pussy vids
  • porn movie talk about white chicks
  • black girls for old white cock
  • Man vs girl sex
  • free ebony teenies
  • Naked fuck sex
  • antient german sex videos
  • eating granny pussy pornhub
  • Bigger cum shots
  • beoncye naked sexy
  • asian teen movie thumbnails
  • deep throat teen galleries vid
  • interracial amuater sex
  • hardcore amateur pictures and
  • best free cumshot facial videos
  • young asslicking girls
  • free xxx couples pissing
  • his first sex galleries
  • softcore bbw galleries
  • girl with nice butt gives blowjob
  • wei pussy porn
  • mature sex tubes amateur
  • virgin anal galleries
  • hottie couples sex
  • rate picture couples
  • girl friends boobs
  • pornstar ange venus pictures
  • girls touching each others boobs
  • young young girls having sex
  • youg teen girls
  • milf amateur video galleries plus
  • sexy hot photos of japan women
  • amature sex fee vids
  • sexy foreplay oral
  • Teen ebony video
  • sexy girls getting naked videos
  • pics of women with shaved vaginas
  • free teen amatuer galleries
  • petite bassit giffin
  • maria bello sex naked
  • free black creampie videos
  • sex massage lick my clit
  • finger my wet pussy stories
  • schoolgirl topmodel fuck
  • free pussy lick tubes
  • upclose pussy photos
  • bouncing boobs private video
  • Nice ass panties
  • mile school pussy
  • free saggy mature tit movies
  • handjob explosions movie thumbs
  • hot sexy babes ass tits
  • topless workout video
  • asain schoolgirl sex
  • topless south african girls
  • free asian facial videos
  • british girl fucked sex video
  • amateur adult movie retailers
  • free download of teen fucking movies
  • naked college girls vide
  • dailymotion black boobs
  • hot pussy sex video
  • girl shower naked nude undress undressing
  • free pale girl pics
  • free grandma amateur sex tube
  • jana horova fuck video
  • girls kissing butt
  • Big sex fuck
  • pocket pussy red tube
  • male teen fuck
  • cute hairstyle pictures for teen girls
  • free porn of couples
  • pics of bald little pussy
  • montage hot bikini girl
  • moms having anal sex
  • sex afraid to orgasm
  • first anal sex tops
  • lesbian anal lick orgys
  • family nudism gallery
  • pics of girls makin out
  • teens girls movies mpg
  • petite princess boutique
  • free hairy pussy video
  • asian housewife mature
  • bald little young pussy
  • naked teen posts
  • porn mom vid list gallery
  • sex movies of old and young
  • Jennifer lopes sex scene
  • free chubby nude teen girls
  • mature younger lesbian foreign
  • three anal suck
  • babysittter young girls stories
  • girl on girl porn and free
  • fingering into the navel pictures
  • Tila tequila nude pussy pics
  • gaa player porn movie
  • black men and your wife
  • Lesbian strap on movies
  • free blonde shemale porn
  • gp hardcore xxx download
  • xxx old mature tube thumb
  • ass twysties girl
  • schoolgirls fuck and suck
  • pornhub veronica lane anal
  • naked lesbian sex slaves
  • mario lopez sex videos
  • naked girls gym
  • women pics mature
  • teenage girl milking
  • free full video asian nude
  • naked latina video
  • big ginger pussy faye valentino
  • wife sister threesome
  • hardcore bondage movie
  • Bizzare sex porn
  • black stockings lonely housewife
  • Sexy girl dawn
  • sex asian video free
  • Chubby sex videos
  • Irani sex girl
  • Lesbian beach girls
  • Hard core sex video
  • hampster lesbian porn
  • wet young milf pussy
  • photos of harajuku girls of japan
  • sexy mature women seduction videos
  • xxx sluts naked outside
  • beautiful couples movie
  • free gilf milf porn video
  • lolly badcock anal movies
  • instructions wife for black men
  • nice ass lesbian ya
  • free sex cunts mature
  • home sex video upload
  • pussy licking old young
  • my wifes asian ass
  • streaming mature videos hampster
  • teen fucked in the pussy
  • Lesbin hot sex
  • porn black light beauty
  • anal sex stimulation
  • jap teacher sex videos
  • vanessa hudgens contraversial naked pics
  • curious teens hardcore
  • sex girls blacks and blonds
  • interracial pregnancy creampie videos
  • porn actress blonde retired
  • bikini iranian girl houston
  • japanese public fuck tubes
  • free long young couples sex videos
  • free pica mature wives flashinf
  • asian free videos porn
  • jew girls sucking big black cocks
  • Hot nude chiks
  • Ass shake in thong
  • junior boobs pics
  • girl scout teens nude
  • leticia cline pussy nude
  • ols mwn young girls
  • round granny ass xxx
  • sexy teacher fuck
  • Leslie ann warren nude photos
  • red haired girl strips gallery
  • nude teenies anal
  • lesbian strap on hardcore anime
  • joanna garcia topless pics
  • christina aguilera young girl dont cry
  • large dicks young girls
  • asian lesbian strapon big time
  • asian grope videos
  • pastors wife naked
  • the sexiest black porn stars
  • thumbnail gallery of young teen girls
  • wholesome naked girls
  • threesome movie thumbs
  • Teens flash boobs
  • black dudes on white bitch
  • big lip pussy hi def
  • haley paige porn videos
  • slutload little girls pussy
  • skinny girl xxx
  • xxx amatuer porn photos
  • petite busty africans
  • young black hot porn girlz
  • erotic fiction for women sexy stories
  • school girl fuck stories
  • Teenagers sex video
  • denying wife sex advances
  • dirty erotic sex stories and pictures
  • redtube lesbian blonde
  • naked sexy arab photos
  • free nude legal ebony teens
  • extreme young bikini pics
  • free video girl fucked
  • Xxx sex big tits
  • amauer sex videos
  • jenna jameson video porn
  • naked women showing off goodies videos
  • spiderbabe hardcore goth free pics xxx
  • White teen pics
  • free drunk teen girl porn
  • Ass perfect teen tight
  • big juicy teen butts
  • hardcore psp porn
  • sex with threesome
  • men boy fuck videos
  • bathroom sex vids
  • daily porn galleries free
  • slut eating my pussy
  • Nude iranian girls
  • order porn videos
  • shemale teens live
  • publis sex teen pics
  • lesbian porn penis boe
  • horror movie babes dead
  • amateur young porn tube
  • japanese mom sons porn fuck
  • amateur stranger sex
  • girls round butts nudity
  • free pussy no sign up sites
  • old naked pussy
  • Iran sex girls
  • pics of mature fat women
  • horny mature video galleries
  • huge tits video riding bouncing free
  • drunk party girls for free
  • roxanne milana pussy
  • pussy hair cut styles
  • ass n feet galleries
  • pictures of throat cancer
  • Old fucking girl
  • Hot white pussy
  • Cum shot ass
  • videos de tiffany teen
  • flashing pussy in library
  • Pictures of small breasts
  • petite blue jeans
  • s fuck sons porn pics
  • shy girl naked audition slut load
  • latina teen bikini models
  • pussy ready to eat closeup
  • asiann girl with huge tits
  • beautiful girls ith beautiful tits
  • sexy butt movies
  • Anal big fuck
  • girl undressing free video
  • fucking pussy ass sex
  • blonde wives post
  • jenna jammeson handjob video galleries
  • my big wet pussy video
  • teen swimming party ideas
  • unblocked topless pictures
  • my sexy wife maria
  • free hot red heads pussy
  • Daily sex videos
  • fireside pussy avi
  • really petite girls nude
  • wife posts erotic
  • free petite yng bbs movies
  • blonde babes sex galleries
  • aka naked women pussy
  • free asian sex vidoes
  • xxx twink porn free
  • black woman giving blowjob
  • pic of black butts
  • nude women porn free pics
  • naked black guys with big dicks
  • Hot ass young
  • amateur twink porn
  • destroyed wife pussy creampie
  • hot girl party hardcore
  • lengthy sex xxx free
  • poast amateur free nudes of wife
  • amateur pussy free movies orgasm
  • pokegirl sex league
  • pale white girls sex
  • legs video boobs
  • Nude beauties video
  • first time anal pornhub
  • dipa sex movie tube
  • momma shaved my pussy slut load
  • indian sex lesbian
  • free babes porn movies
  • Sweet innocent teen
  • black dicks latins chicks
  • sex group xxx
  • czech chicks anal
  • asian japanese squirt black torrent
  • Thick white girl dancing
  • Hot sex teen in germany
  • lacey glamour girls gone bad
  • ass point video
  • young teens nude hairy
  • Paul donahoe nude photo
  • fingering girls in there sleep
  • ass shakin sex
  • big tit handjob free videos
  • sexy newspaper girls
  • friends pulling off girls bikini top
  • huge bottle pussy insertions
  • Hot girl shoes
  • Chris brown big ass dick
  • can males suck their own dick
  • older people having oral sex
  • streaming amateur free video
  • black beauty tomato seed
  • Xxx crossdresser teens
  • big tits round ass long videos
  • skinny bikini teen girls
  • sexy young kdz
  • nude naked new videos
  • free violent fuck videos forced sex
  • girl screams fuck me harder
  • naked dutch girls in wooden shoes
  • illigal xxx teen
  • very young model galleries
  • masturbation in very young girls
  • pornhub white bitch wants to fuck
  • free full japanese porn
  • long black dick fuck mother daughter
  • xxx threesome videos gtube
  • mature pics forum
  • hentai young pictures
  • utube cream pie pussy
  • young girls first blowjob sex videos
  • video laure manaudou naked
  • fuck movies t home
  • little young teen sex