How to trace incoming SQL statements to SQL Server Database (using SQL Server Profiler)

by Jagadish Pulakhandam on 9/23/2011 10:18:49 AM
Rated 0 from 0 votes
Brief: Demonstrates tracing of all incoming SQL statements (which are going to be executed at SQL Server Database) using SQL Server Profiler.
Posted to: Microsoft SQL Server - Quick Learn ("How to"s for Developers)
Add to DiggAdd to del.icio.usAdd to FURLAdd to RedditAdd to YahooAdd to BlinklistAdd to GoogleAdd to ma.gnoliaAdd to ShadowsAdd to Technorati

Attached video demonstrates on the following:
  • A sample ASP.NET application communicating to SQL Server database (Northwind)
  • Opening SQL Server Profiler
  • Selecting various events to trace (this depends on necessity)
  • Tracing all incoming SQL statements (to SQL Server database) using SQL Server Profiler
  • Monitoring the trace
  • Clearing, Stopping and Starting SQL Server trace.


Join the .NET Code Central Community and join the discussion!
Signing-up is FREE and quick. Do it now, we want to hear your opinion
0

Rated 0 from 0 votes ( login  to rate)
DotnetKicks DotnetKicksDe DotNetShoutout


Video/Screen Recording (may not have audio narration/annotations)
You need to Login or Join for FREE to download the following