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

  • free tyny asian xxx
  • Teen masterbating movies
  • shemale on girl jpg
  • whiteboy vids
  • hardcore crying sex
  • how towank fake pussy
  • dy daughter anal fuck
  • girls home pics
  • mature fight pictures
  • flashing truckers videos
  • all girl ass
  • raped wife videos
  • free amateur nterracial movie sies
  • amateur girls pissing in bath
  • adorable asian teen
  • black teen girl movie
  • Gigantic tit movies
  • free interrracial sex pics
  • girls orgasm virgin video
  • full movie of men
  • hot young teen free videos
  • Sibel kekilli sex scene
  • free movies high heel
  • stories wife bikini
  • women shoving dildos in there pussy
  • young mom fuck her soon
  • xxx wife swapping videos
  • free candid girl video
  • Girls playing with their boobs
  • lifetime movie beach girls
  • Cheap cam sex
  • picture of boobs shirt off
  • hose the pussy
  • free amateur swinger movies
  • ass free video streamimg
  • asian teenie vids
  • sexyest girl alive
  • pretty girls topless
  • sex ed for anal
  • young girls who fuck older guys
  • sexy young small petit
  • girls gymnastics picture
  • gaming girls playboy pics
  • dick ass fuck
  • free videos forced sex
  • older man young teen
  • free ass licking galleries
  • free young tiny teen sex movies
  • wild young pussy and tight cunts
  • black suck cum out dick tube
  • Oral sex in action
  • black women with massive tits videps
  • nude car wash babes pictures
  • hardcore site
  • Amateur anal movies
  • barely legal teen hard fuck
  • Sex in disney movie
  • mature milfs taking black cock
  • granny big tits movies
  • girls suck off guys
  • advantages of anal sex
  • wife upskirt xxx
  • girls show nude ass
  • interracial tollroad video
  • big dicks video
  • naked booty dance video
  • korean girls an american perspective
  • young lesbians anal
  • fuck women dick
  • long dicks little pussy
  • sexy young girl and boy
  • voyeur teen anal creampies
  • old pussy and assholes
  • interracial cumshots movies
  • movies mature nylons
  • free sex video rooms
  • sexy hot women and mature
  • entertainment adult video xxx missionary sex
  • young girls teens naked
  • teen girls national topless day
  • chinese girls amateur
  • teen anal stars
  • buffy gallery
  • prostitute video handjob
  • black cocks teens
  • asian schoolgirl trannys
  • watch black naked women fuck blondes
  • anal sex luke ford
  • carly banks videos from riot girls
  • asian foursome anal
  • spring break fuck girls gone wild
  • lesbiain tits picaf
  • Sex movie photo
  • suck on your boobs blackmail
  • Teenagers with huge tits
  • african teen girl
  • sexy shemale whore
  • small breasts teen asian
  • ukrainian girls free movies sex
  • megan reece anal
  • boy scouts fuck a girl
  • young chuby
  • blonde lesbian bikini
  • black dicks sweet dicks
  • drunk japanese girls photos
  • upskirt legs video sex
  • topless trucker pics
  • young russian beauties non nude
  • Husband and wife sex pictures
  • free black tit
  • teen celebs sex story
  • hot moms ass pics
  • hq hardcore teens
  • petite girl sex pics
  • asain girl sex with
  • Full home sex
  • baek ji young sex radio download
  • philipino beauties sex
  • teenage girls eating disorders self esteem
  • swinger wife xxx
  • Interracial relationship statistics
  • lil kim ass pictures
  • Sharon stone nude photo
  • Totally spies sex videos
  • my sisters pussy xxx
  • emma louise videos
  • oral auto andando video sex
  • fotos amateur
  • girl on gil xxx
  • blonde swedish teen hand job
  • sexy young girsl
  • romance movie sex scenes
  • tiny pussy free fucking videos
  • nice pecky pretty nude pussy babes
  • youngest teenie pussy
  • hmong girls with big tits
  • big black hard dick fuck
  • disney picture
  • suck a big fat tranny dick
  • girls bravo galleries
  • erotic black sex
  • japanese swallow
  • lesbia tits lick
  • young girls fuck old men
  • naked nerd ex girlfriends
  • young girls message board
  • two pussy xxx
  • ass in black pants
  • Sleeper cell sex scene
  • Little sisters tits
  • hot asian teen gives blowjob
  • Olga kurylenko le serpent sex scene
  • nude lady with big pussy
  • sexy japan free
  • asian and black deepthroat
  • mature lesbian pussy on pussy
  • black young skinny boy big cock
  • hairy and fat pussy
  • wife fucks first black guy
  • young girls old fucking
  • personal wife gallery
  • the hills girls pics nude
  • best home sex video pov
  • sex videos elko nevada
  • college girl writes about sex
  • free teen handjob videos
  • sexy butts on teens
  • great gran fucks teen girl video
  • black babe naked
  • lesbion foot fuck tubes
  • hot volleyball ass video
  • Hot naked girls on cars
  • naked girl locker room video
  • Sex scene in tamil movies
  • sticking things in a pussy
  • fuck yeah naked girls
  • hot girl bush pics
  • party mpegs
  • hien sex cam young teen
  • eat cum from wifes pussy
  • naked chubby girl
  • hot latin teen girls fucking pics
  • sons force fuck mom homemade
  • anal buttplug movie galleris
  • sexy brazil phat ass fuck slutload
  • andrea rincon naked video
  • free young bald pussy
  • worlds sexiest blowjob
  • free swingers xxx galleries
  • women petite slacks
  • free bi teen mmf
  • massive dildio pussy
  • free young amateur thin video
  • babe hardcore gallery
  • asian models nude pics
  • hot sexy moms fuck
  • blck sex shemale
  • long free softcore videos
  • sexy office babes at work
  • naked teenagers boys