Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SSIS Training Videos
·
SQL Programming Tutorials
Create a free account
·
Sign In
SQL Server DBA Videos in Series
Home
Subscriber Videos
Using Profiler in SQL Server 2005 (Video Series)
Video Category:
Monitoring and Performance Tuning SQL Server
Skill Level:
200 (Beginner - Intermediate)
Versions/Editions Covered:
SQL Server 2005
This series is more than an introduction; you'll get in-depth knowledge of many of the most common screens within Profiler for SQL 2005 as well as Best Practices for using Profiler and creating SQL traces. This should be considered mandatory viewing by anyone wanting to become a DBA or who wants to be a serious developer.
Videos in this Series:
Title
Skill
Length
Download
Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens
300
12 mins.
Download
Pt. 2 - Determining Which Events and Data Columns to Use in Your Trace
300
12 mins.
Download
Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working wit...
400
8 mins.
Download
Pt. 4 - Managing, Viewing and Interpreting SQL Server Traces
400
16 mins.
Download
Pt. 5 - Templates and Working Within the Profiler UI
400
7 mins.
Download
Miscellaneous Bits & Pieces:
SQL Server 2000 Resource Kit - More Helpful Tools: Simple Log Shipper is an ultra-simple set of log-shipping scripts. Very useful
osql.exe is a command-line tool that you can use to run your SQL scripts and queries; think of it as the DOS-version of Query Analyzer
Performance Tip: Try to keep your transactions as short as possible. This reduces wait time and locks held which increases concurrency
About Us
·
Corporate Philosophy
·
Advertise With Us
·
Become an Author
·
Contact Us
Video Playback
·
System Requirements
·
TSCC Codec
(to play videos)
·
Troubleshooting/Problems
Subscriptions
·
Pricing/Buy Now
·
Testimonials
·
Privacy
·
Terms of Service
More Video Training
·
SSIS Training Videos
·
SQL Programming Tutorials
·
All of Our Websites
More
·
FAQs
·
Search for videos
·
Site Map
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.
9/7/2008 9:15:51 PM