Capturing Row Counts using Profiler

It's a small option, one not often noticed, but you can use it find the queries that are returning a LOT of rows. Maybe they need to return a lot, but maybe they don't! It's an interesting way to look at a system in a different way than reads and duration, trying to find the places where more work is being done than needs to be done. While we're doing this we show you how to use Profiler, the essential tool for the DBA.

Duration:	3 mins 15 secs
Skill Level:	100
Rating:	4.27 out of 5
Publish Date:	October 05, 2010

You must be logged in to view this video.

12345
1=Poor, 3=Good, 5=Excellent

About the Author

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

References

Demo Script

Comments

JohnG on 10/5/2010

Verying interesting. Thank you.

Deepak on 10/5/2010

Very interesting. Thank you.

Dana on 10/5/2010

very applicable

Charlie Bruno on 10/5/2010

The last few weeks the videos have not been playing correctly. Either they do not load and play; or they play and break up a number of times. This particular lesson will not load and play... I will try again later...

1F05990EE7 on 10/5/2010

Thanks a lot for sharing the cool stuff.

Ameena on 10/5/2010

Never thought about it. Thanks for pointing it out.

Jamshid Nouri on 10/5/2010

excellent demos!!

Mohamed Irshad on 10/5/2010

something new learned. thank you. very well done.

Charlie Bruno on 10/6/2010

Interesting, information and educational. Keep up the great work at educating and mentoring us. I appreciate it.

Patrice Rasche on 10/6/2010

Any time I get a demonstration of Profiler, it's a really good thing.