Microsoft KB Archive/325297

= Support WebCast: How to Effectively Use SQL Server Profiler =

Article ID: 325297

Article Last Modified on 8/9/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q325297



Session Summary
This session will talk about what the Profiler is, and then when, why, and how you should use. We will go into the details of various Profiler components and discuss their applicability to specific troubleshooting scenarios (with examples). We will also discuss the underlying extended stored procedures and how to use them outside of the GUI. In addition, we will look into the way Profiler works with other tools such as the Index Tuning Wizard. Finally, we will discuss common issues surrounding Profiler, and provide some simple tricks and shortcuts.

This is a Level 200 session that was recorded May 18, 2000, and is presented by Sri Kasam and Ajay Manchepalli.

Sri Kasam joined Microsoft in February 1999 as a SQL Server Support Professional and has about three years of database development and administration experience. He has a Masters in Computer Science and is an MCSE. Sri Kasam currently works for Product Support Services primarily focusing on SQL Server 7.0.

Ajay Manchepalli has been with Microsoft SQL Support for two years and is currently in the role of Technical Lead. He has a Masters degree in Computer Science and is an MCSE. He was with Compaq Computer Corporation for two years as a Database Performance Engineer, and was involved in publishing TPC benchmarks. His background and specialization are in the areas of performance and tuning.

Viewing the Presentation
To view, please click on the link: [javascript:fnViewMMC('http://support.microsoft.com/servicedesks/webcasts/seminar/shared/asp/view.asp?url=/servicedesks/webcasts/en/WC051800/manifest.xml'); View this Support Webcast] (Length: 1 hour 18 minutes)



This Windows Streaming Media archive requires an Internet connection of 28.8 Kbps or faster, and is best viewed with a minimum screen resolution of 800 X 600.

Offline viewing download - If you wish to view this broadcast offline, you may download a copy of the self-extracting .exe file to your hard drive.

Additional Resources
Download presentation WC051800.ppt. This is a 198-KB Microsoft PowerPoint (.ppt) file.

If you do not have PowerPoint and you want a copy of the slides, use the PowerPoint Viewer (2,752 KB).

Read the transcript from this Support WebCast

[mailto:?subject=Support%20WebCast:%20How%20to%20Effectively%20Use%20SQL%20Server%20Profiler&body=Take%20a%20look%20at%20this%20Microsoft%20Support%20WebCast%20about%20How%20to%20Effectively%20Use%20SQL%20Server%20Profiler%20(May%2018,%202000).%20More%20information%20about%20this%20WebCast%20is%20available%20at%20http://support.microsoft.com/WebCasts. Tell a friend about this Support WebCast]


 * SQL Server 7.0 Books Online - &quot;Monitoring with SQL Server Profiler&quot;
 * Inside SQL Server 7.0 by Ron Soukup and Kalen Delaney

Provide Feedback on this Broadcast

Support WebCasts Home

Keywords: kbinfo kbdownload kbtshoot kbwebcastsupport KB325297

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.