A great resource for the community to share. As a small contribution CXPACKET stands for class (as in C++ class) exchange packet and not context extension packet as mentioned at 20:11.
very good video. Learned a lot about queries. I know where I work, cursors are used. The majority of the time, I think that they are being used properly, but from my testing, I find that storing stuff in temp tables is faster than a cursor. With SSIS though, sometimes that isn't a good or valid option. Definitely going to be grabbing the tools you mentioned. The timing couldn't be better. We have recently had a few queries eating up a lot of CPU and/or high number of waiting tasks and high number of batch requests per second (IIRC, it got up to 250 today). Watching the activity monitor, it got filled with cursors. So I'd like to run your tool against one of our test DB's and see what it tells me.
Interview with Greg Gonzalez, President and CEO of SQL Sentry: www.superbcrew.com/sql-sentry-helps-companies-improve-the-performance-of-ms-sql-server-environments/
There is not a specific database, aside from the normal AdventureWorks database available on Github, for the general demos. The code that you're looking for are available in matching blog posts on sqlperformance.com for each of the techniques described in the video. The full scripts are available there.
A great resource for the community to share. As a small contribution CXPACKET stands for class (as in C++ class) exchange packet and not context extension packet as mentioned at 20:11.
Thanks Shane for the kind words and thanks for the catch!
very good video. Learned a lot about queries. I know where I work, cursors are used. The majority of the time, I think that they are being used properly, but from my testing, I find that storing stuff in temp tables is faster than a cursor. With SSIS though, sometimes that isn't a good or valid option.
Definitely going to be grabbing the tools you mentioned. The timing couldn't be better. We have recently had a few queries eating up a lot of CPU and/or high number of waiting tasks and high number of batch requests per second (IIRC, it got up to 250 today). Watching the activity monitor, it got filled with cursors.
So I'd like to run your tool against one of our test DB's and see what it tells me.
You, Guys are just awesome. This is so useful. Thank you so much to share this video! .
Great video, thanks
good stuff and thanks for the upload
thanks for the demo...
@SQLSentry is there a link to where I can find the queries used in the first 30 minutes of the presentation?
Check out my new video about sql query tuning in 15 mins.
sorry, but I cannot find that video. could you link it? thanks
There are matching blog posts on sqlperformance.com for each of the techniques described in the video. The full scripts are available there.
Interview with Greg Gonzalez, President and CEO of SQL Sentry: www.superbcrew.com/sql-sentry-helps-companies-improve-the-performance-of-ms-sql-server-environments/
Thanks kevin and aaron may i know where can i get sqlsentry sample database pls help me
There is not a specific database, aside from the normal AdventureWorks database available on Github, for the general demos. The code that you're looking for are available in matching blog posts on sqlperformance.com for each of the techniques described in the video. The full scripts are available there.
So we can use Wait stats in Production?
Yes, absolutely, for troubleshooting and performance tuning.
last ports are goood
very usefull
first 7 min 15 sec - empty bla- bla- bla
TANSTAAFL, as they say. The real content starts afterwards.
clearly not done by someone who knows how to keep the watcher hooked. so much talk omg
Lots of talking less learning
very very BAD analysis