Performance Tuning Using Extended Events: Part 3

Question

Performance Tuning Using Extended Events: Part 3

bdavey

Default port

Points: 1469
More actions
May 4, 2017 at 12:00 am

#330021

Comments posted to this topic are about the item Performance Tuning Using Extended Events: Part 3

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Alan Burstein SSC Guru Points: 61141 More actions · Answer 1

I love this series Brian, its very informative. Well done, 5 stars!

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

bdavey Default port Points: 1469 More actions · Answer 2

Alan.B - Thursday, May 4, 2017 6:34 AM
I love this series Brian, its very informative. Well done, 5 stars!

Thank you Alan!
I haven't gotten many comments on it so I was getting concerned it might not be clicking with everyone.

Thanks again.

m.kagan SSC Rookie Points: 35 More actions · Answer 3

Thanks Brian for this informative series!

P.S. you might want to edit your db-name in the two population parts for #BLK_RPT and #GT25_RPT (exec event_GetEventData)

Best regards,
Michael

bdavey Default port Points: 1469 More actions · Answer 4

m.kagan - Friday, May 5, 2017 8:15 AM
Thanks Brian for this informative series!
P.S. you might want to edit your db-name in the two population parts for #BLK_RPT and #GT25_RPT (exec event_GetEventData)
Best regards,
Michael

Thanks Michael! I totally missed those!
I've gone in and fixed them now. I'm just waiting for the update to get pushed out.

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 5

Brain, it's a very good and informative series. I have enjoyed reading your articles.

Gethyn Elliswww.gethynellis.com

bdavey Default port Points: 1469 More actions · Answer 6

GRE (Gethyn Ellis) - Tuesday, May 9, 2017 8:29 AM
Brain, it's a very good and informative series. I have enjoyed reading your articles.

Thanks Gethyn! I hope you find good use for it.

josewrodgers Grasshopper Points: 12 More actions · Answer 7

Hi Brain,

First of all, thank you so much for this. It's incredible.

I just have a bug to report... on the Store Procedure [event_GetEventData] you use a scalar funcion related to Error Session. We don't have that function, could you provide us?

(Line 607, "SELECT Id FROM Engagement20.dbo.fn_GetIntTableFromList(@errorNumberIN,',')")

Thanks in advance

This reply was modified 5 years, 11 months ago by josewrodgers.

Performance Tuning Using Extended Events: Part 3

Cookies on SQLServerCentral