THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Explaining Activity Monitor

This blog has moved! You can find this content at the following new location:

http://sqlblog.karaszi.com/explaining-activity-monitor

Published Thursday, February 16, 2017 7:08 PM by TiborKaraszi
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

RichB said:

I've stayed away from the AM for years, ever since I noticed that the servers would back up and fall over if people had it open.

Any idea if the resource usage on this has changed?

February 16, 2017 7:54 PM
 

TiborKaraszi said:

No, I can't comment on that. It happens that I open it, but only for a brief time period. I haven't traces any older version of SSMS so I don't know whether the SQL has changed. However, judging by the few wait types in the wait types table, I wouldn't be surprised of the SQL submitted by AM is pretty much the same since 2008 (which is when we got this new AM, as I recall) and that was the wait types we had back then...

February 18, 2017 2:03 PM
 

ManeeshMalhotra said:

Thank you Tibor for insight view of AM.

May 20, 2017 2:05 AM
 

Harry Grafdon said:

Does anyone have an idea what the 5th empty graph is for in the overview?

This is really bugging me and my team.

June 8, 2017 4:18 AM
 

Harry Grafdon said:

Just in case anyone else was wondering, I managed to find the answer to my own question. It's a bug and has been removed from later releases.

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms

"Removed empty chart (5th chart) in Overview section"

June 8, 2017 4:34 AM
 

zzyytt said:

http://www.adidas-crazyexplosive.us.com

http://www.longchamp-bags.us.org

http://www.patriotsjersey.us.com

http://www.linksoflondon.us.com

http://www.adidassuperstar.org.uk

http://www.adidasstansmith.us.com

http://www.adidasnmd.uk

http://www.michaelkors-outletonlines.us.com

http://www.jordan4.us.com

http://www.cheap-airjordans.us.com

http://www.bape-hoodie.us.com

http://www.nike-hyperdunk.us.com

http://www.truereligionjeans-outlets.us.com

http://www.curry5.us

http://www.pandorabracelet.in.net

http://www.cheapoakley-sunglasses.us.org

http://www.chromeshearts.us.com

http://www.nikexoffwhite.com

http://www.birkinbag.us.com

http://www.tomford-sunglasses.us.com

http://www.michael-kors-handbags.org.uk

http://www.adidasyeezys.us.com">http://www.adidasyeezys.us.com

http://www.lebron14.us.com

http://www.retro-jordans.us.com

http://www.goldengoose-outlet.us.com

http://www.curry5.us.com

http://www.offwhitehoodie.us.com

http://www.longchamphandbagsoutlets.com

http://www.cheapnbajerseys.us.org

http://www.yeezyboost.com.co

http://www.bapehoodie.us

http://www.nikeairhuaraches.com

http://www.louboutinshoes.uk

http://www.jordan6.us.com

http://www.diorsunglasses.in.net

http://www.ferragamobelt.us

http://www.paulgeorgeshoes.us.com">http://www.paulgeorgeshoes.us.com

http://www.kd-10.us

http://www.fitflops-saleclearance.us.com

http://www.redbottoms.us

http://www.toryburchshoes.org.uk

http://www.nike-airhuarache.us.com

http://www.kobe-shoes.us.com

http://www.adidasstansmith.uk

http://www.caterpillarboots.us.com

http://www.chromehearts.net.co

http://www.yeezysshoes.us.com

http://www.basketball-shoes.us.com

http://www.lebron-soldier10.us.com

http://www.nikeairforce1.us.com

http://www.longchamphandbagsonlines.com

http://www.lebronjames-shoes.us.com

http://www.kevindurant-shoes.us.com

http://www.vancleefandarpels.us.com

http://www.supremeclothing.us

http://www.jordan13.us.com

http://www.oakleysunglassesformen.us

http://www.adidassuperstar.us.com

http://www.balenciagassneakers.com

http://www.nikexoffwhite.com

http://www.converseoutlet.us.com

http://www.air-max.us.com

http://www.yeezyboost350v2.org.uk

http://www.offwhitexjordan1.com

http://www.hermes-birkin.us.com

http://www.nikehuaracheshoes.us.com

http://www.nike-airmax2017.us.com

http://www.yeezyboost350v2shoes.us.com

http://www.fentypuma.us.com

http://www.asics-shoes.us.org

http://www.jordan11retro.us.com

http://www.nikeairmax2018.us.com

http://www.yeezy-boost350.us.com

http://www.rayban-sunglassesonline.us.com

http://www.yeezy-boost.us.com

http://www.pradasunglasses.us.org

http://www.outletonline-michaelkors.us.org

http://www.converse-shoes.us.com

http://www.nikeflyknit.us.com

http://www.michaelkors-outletfactory.us.org

http://www.jordan-retro.us.com

http://www.supremehoodie.us.com

http://www.paulgeorgeshoes.us

http://www.nikeoutletstoreonlineshopping.us.com

http://www.rbsonlinestore.com

http://www.adidaseqts.com

http://www.michaelkors-outletstore.com

http://www.kobeshoes.uk

http://www.ultraboost.us.com

http://www.nfljerseysstoreonline.com

http://www.vibramfivefingers.us.com

http://www.christian-louboutin.eu.com

http://www.boostyeezy.us.com

http://www.nikeshoesformen.us.com

http://www.vans-shoes.us.org

http://www.yeezy-shoes.us.org

http://www.yeezyshoesuk.com

http://www.kyrie4shoes.us.com

http://www.airjordanretro.uk

http://www.adidas-nmds.us.com

http://www.kobesneakers.com

http://www.yeezy-shoes.org.uk">http://www.yeezy-shoes.org.uk

http://www.hermesbelts.co.uk

http://www.adidasultraboost.us.org

http://www.vapormaxshoes.us

http://www.raybansunglassesoutlets.us

http://www.shoesjordan.us.com

http://www.goyard.us.com

http://www.yeezy-500.us.com

http://www.hermes-belt.us.com

http://www.raybansunglasseswholesale.us.org

http://www.nikerunningshoes.us.com

http://www.yeezyboost-350.uk

http://www.oakleysunglassesonline.us.org

http://www.nike-freerun.us.com

http://www.adidasyeezy.co.uk

http://www.adidasultra.us.com

http://www.nikecortez.us.com

http://www.nike-roshe.us.com

http://www.michael-kors-handbags.com.co

http://www.cheaprealjordans.us.com

http://www.yeezy500.us

http://www.ferragamobelt.us.org

http://www.nikehyperdunk2017.us.com

http://www.jewelrypandora.in.net

http://www.long-champ.us.com

http://www.calvinkleinoutlet.us.com

http://www.nikezoom.me.uk

http://www.yslhandbags.net

http://www.raybanonlinestore.us.com

http://www.michael--korsoutlet.us.org

http://www.monclerjacketsale.us

http://www.adidas-zxflux.us.com

http://www.adidas-eqt.us.com

http://www.katespadehandbags-outlet.us.com

http://www.derrickroseshoes.us.com

http://www.adidas-tubular.us.com

http://www.yeezyboost-350.com.co

http://www.hardenshoes.us.com

http://www.nikeairmax270.org

http://www.lebron15shoes.us.com

http://www.outlettimberland.us.org

http://www.adidasnmdshoes.co.uk

http://www.yeezy-shoes.ca

http://www.jordan12.us.com

http://www.toryburchshoes.us

http://www.yeezy700.us.com

http://www.adidasstore.us.com

http://www.oakleysunglassessale.us

http://www.adidasnmd-runner.us.com

http://www.damianlillardshoes.us.com

http://www.curry4.us.com

http://www.lebron-soldier11.us.com

http://www.outletlacoste.us.com

http://www.adidastubular.co.uk

http://www.kyrie3.us.com

http://www.asicsgelkayano.us.com

http://www.michaeljordanshoes.us.com

http://www.mlbjerseyscheap.us

http://www.nikesneakers.us.com

http://www.truereligion-outlets.us.com

http://www.adidasiniki.us

http://www.hoganoutletonline.us.com

http://www.michaelkorshandbag.us.org

http://www.lebron15.net

http://www.burberryoutlet-store.us.com

http://www.adidasyeezys.us

http://www.nikepolo.us

http://www.lebron13.us.com

http://www.nikemercurial.us.com

http://www.kobebasketballshoes.net

http://www.kyrie4.org

http://www.authenticjordanscheap.us.com

http://www.jordansforcheap.us.com

http://www.nikebasketballshoes.us.com

http://www.adidas-pureboost.us.com

http://www.linksoflondonus.com

http://www.chromehearts.com.co

http://www.adidasnmds.com

http://www.vans-outlet.us.com

http://www.nike-airpresto.us.com

http://www.adidasgazelle.us.com

http://www.raybanaviatorsunglasses.org

http://www.offwhitexjordan1.com

http://www.goyard-handbags.us.com

http://www.airmax90.us.org

http://www.monclerjacketsoutlets.us.com

http://www.yeezyboost.in.net

http://www.monclerjackets.us

http://www.goldengoose.us.com

http://www.nikedunks.us.org

http://www.adidasoutletonline.com

http://www.yeezysuk.com

http://www.russellwestbrookshoes.us

http://www.johnwall-shoes.us.com

http://www.monclersoutlet.us.com

http://www.yeezy-shoes.org

http://www.adidasyeezys.net

http://www.nfljerseys.us.org

http://www.nike-airforce1.us.com

http://www.russellwestbrookshoes.us.com

http://www.offwhiteclothing.us.com

http://www.nikeair-max.us.com

http://www.longchamp-bag.us.com

http://www.reebokoutlet.us.org

http://www.nike-huarache.com

http://www.guccibelt.us.com

http://www.long-champhandbags.org.uk

http://www.yeezyboost-350v2.us.com

http://www.jordanshoes.uk

http://www.balenciaga.us.com

http://www.goyardhandbags.us.com

http://www.michaelkorsoutletstoresonline.com

http://www.nikezoom.us.com

http://www.balenciagashoes.us.com

http://www.nikeflyknitracer.us.com

http://www.oakleysunglassesonlinestore.us.com

http://www.hermesbelts.com

http://www.kyrieirving-shoes.us.com

http://www.lacosteonlineshop.us.com

http://www.cheapoakleys.name

http://www.monclerjacket.net

http://www.nhljerseys.us.org

http://www.charmspandora.in.net

http://www.goldengoose-sneakers.com

http://www.kobebasketballshoes.us.com

http://www.nikefoamposite.us.com

http://www.tomfordsunglasses.us.org

http://www.curry4shoes.us.com

http://www.nike-airmax90.us.com

http://www.airmax270.us.com

http://www.hermes-handbags.us.com

http://www.asics-shoes.us.org

June 8, 2018 7:32 PM

Leave a Comment

(required) 
(required) 
Submit
Privacy Statement