Skip to content

Microsoft Exam 70-433 (part 7)

2010 July 7
by Shannon Lowder

I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433.  Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008.  I’m going to list the topics covered in several posts, each one will include links to details to those topics.  If you have any questions, let me know!

Gathering Performance Information (11 percent)

  • Capture execution plans.
    This objective may include but is not limited to: graphical execution plans; SHOWPLAN
  • Gather trace information by using the SQL Server Profiler.
  • Collect output from the Database Engine Tuning Advisor.
    This objective may include but is not limited to: prepare a workload
  • Collect information from system metadata.
    This objective may include but is not limited to: Dynamic Management Views (DMVs), catalog views
One Response leave one →
  1. b bragesh permalink
    December 12, 2010

    toyboxcreations.net is a pretty good site so far.

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS