MS SQL Server Profiler Basics – 1



Subscribe to our channel here for notifications on new video trainings. For more videos on technology, visit our website at http://www.techytube.com.
By jayanth.kurup@techytube, for more from this author visit:
http://www.techytube.com/author/jayanth.kurup

This video discusses what MS SQL Server profiler is and how to set it up and use it. Profiler is a tool that has been around for some time and yet remains one of the most powerful features available in SQL Server for the DBA. It is used frequently to investigate issues and identify bottlenecks in the database operations. This introduction serves as a starting point to working with SQL server profiler and how to configure a trace file and monitor events that happen on a specific database using column filters and additional events. Every DBA is expected to know how to configure and use MS SQL Server profiler and what scenarios to use it in so video is meant to serve as a starting point to understanding profiler. We explore how to start profiler, setup a basic trace using the built in template and then customize the template to capture additional information and then filter the criteria for what is being captured.
This video is the first of a series on how to work with MS SQL Server Profiler.

Comments are closed.