Search
Home
Articles
Backup
Books
Certification
FAQ
Products
Replication
Scripts
Seminars
Training
TSQL

MSDN Fourms
Fort Worth SSUG
Oklahoma City SSDG

Resume

Champion Valley Pens

SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12

Profiler has been directly integrated into the SPDW.  If you look closely on the SPDW toolbar, the eighth button is depressed.  This enables Profiling when you execute the script.  If you don't want to Profile it, simply toggle it off.   When you turn on Profiling, the Result tab will contain extra items.  By selecting the Profile List radio button, you will see a listing of the actions that occurred.

sql-programmerix-21.gif (23820 bytes)

Selecting Profile Tree displays the same information in a tree that you can drill into.   This view is similar to that used by SQL Profiler.

sql-programmerix-22.gif (22709 bytes)

SQL-Programmer IX SP2 with TSQL Debugger 1 2 3 4 5 6 7 8 9 10 11 12

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.