SQL Server Profiler Notes

Some random notes on running traces:


SQL Express 2005 does not include a profiler-type tool (neither did MSDE). 

Someone created this free tool, SQLExpressProfiler.  I haven't tried it yet, but I've seen a few references to it on the web.
http://code.google.com/p/sqlexpressprofiler/

Update: AnjLab's SQL Express Profiler seems to work well - whoops, SQL 2005 only, no support for MSDE.  The only problem so far, is selecting the right event classes to trace.

Here's the full list of IDs:

http://publib.boulder.ibm.com/infocenter/tivihelp/v2r1/index.jsp?topic=/com.ibm.itcim.doc/tcim85_install407.html

If you're just trying to snoop SQL statements, try IDs

40,41,12,13.,
42,43 - stored procedures

 (SQLStatementStarting...)


This page lists several tools for SQL server:
http://weblogs.sqlteam.com/mladenp/archive/2007/11/20/Free-SQL-Server-tools-that-might-make-your-life-a.aspx

Do a trace from OSQL - this might be the easiest option for MSDE:
http://oaklandsoftware.com/papers/sqltrace.html




tags: trace, sqlserver, profiler,
Related Scribbles:
  • SQL Server
    		•

    ID: 876
    Author:
    leonard
    Date Updated:
    2009-01-10 00:39:46
    Date Created:
    2007-10-17 12:48:42

    Edit
    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> SQL Server Profiler Notes
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.