Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL DTS Training Videos · SQL Programming Videos
     
SQL Server 2000 Training Videos             * SQL DTS Training Videos
* SQL Programming Videos
* More Videobooks...
Email
Password
Register
LearnSqlServer2000.com Subscriber Videos
SQL Server 2000 Videos By Category Home  Subscriber Videos  
Performance Tuning SQL Server - Profiler, Tracing and Performance Monitoring - Video Category (all video categories)
Video Image This SQL Server video tutorial category is all about performance tuning your SQL Server. The more you know about how SQL Server does what it does, the better prepared you are to make smart design decisions. Watch these videos for a solid foundation of the "how and why" things work the way they do in SQL Server.

This set of videos teaches you about: 
  • Using SQL Profiler
  • Tracing your SQL Server for Performance
  • Using Performance Monitor
and much more.

Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (4 videos) - Using Profiler in SQL Server 2000   300 (Click for Videos) 41 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
Adding in the WITH ENCRYPTION option to your stored proc, trigger, function and view definitions will ensure that the object's source code will not be decrypted. Careful - this isn't 100% foolproof (there are certain workarounds) and, if you lose your original, you may never get to your source code again
SQL Server 2000 Resource Kit - More Helpful Tools: "Database Hammer" is a customizable tool for testing your database server with various loads
Performance Tip: The more hard drives you spread your database across the better performance you will experience. RAID 10 offers the ultimate in performance but, for small databases, is likely to be too costly. RAID 5 for your smaller database's data files and RAID 1 for their log files will help maximize your SQL Server's performance
Video search
Company News
SQL Server 2005 Training
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© 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.
7/3/2008 6:26:47 PM