Alternative to SQL Profiler – IdealSqlTracer is Simple, Free, and Open Source

Pluralsight courses
LinkedIn Premium uses PayScale to estimate job salaries

Premium (Not Free) Video Tutorials

Free Video Tutorials & Free Tools

IdealSqlTracer is a simple, free, open source alternative to SQL Profiler. The advantage of IdealSqlTracer is that it takes all of the sql generated behind the scenes in a desktop application or web page, and it formats it to make it easily readable. IdealSqlTracer takes this beautifully formatted sql, and puts it into notepad. This allows you to easily cut-n-paste the sql in notepad, and run it directly in Sql Server Management Studio (SSMS). The advantage of doing this is that it makes it possible for you to see exactly what is going on in your application or website. IdealSqlTracer utilizes sp_trace_create, sp_trace_filter, sp_trace_setstatus sql procs to create these custom traces for you.


IdealSqlTracer Overview Video


Steps to use:
1. Download source for IdealSqlTracer at https://github.com/harvey007y/IdealSqlTracer
2. Build and Run IdealSqlTracer
3. A series of dialog boxes will appear that allow you to specify the server, database, username, password, and so on. Here are screenshots of the dialog boxes:
Windows Domain Name for Active Directory

Select Server that sql server runs on

Select Server that sql server runs on

Select Server that sql server runs on

4. Once the basic info is entered, a green dialog box is displayed telling you the trace has started. That dialog tells you that you need to perform the action on the website that you want to trace. After the action on the website is done, click the okay button in the green dialog box to end the trace and have the formatted sql appear in notepad. The next screenshot shows the green dialog box that pops up when I am trying to trace what is going on behind a desktop app called IdealAutomate. After the green box appears, I hit save in the IdealAutomate application to cause some sql to be generated.

GreenBox

After the save completes in IdealAutomate, I hit okay in the green dialog box, to see the following formatted sql in notepad that was used in the save:
Notepad

I can cut-n-paste this sql from notepad into SSMS to run it in realtime so that I can identify where any problems might be.

Related posts:

  1. Free DVD Burning Software and How to Burn A DVD in 3 Simple Steps for Free Shows how to burn Microsoft Webcasts to DVD so that...
  2. SQL Server School (17 Hours): Sql Server Connection, Sql Server Stored Procedure, Sql Server Profiler, Trusted Sql Server, Sql Query Analyzer, and More I have found these 17 hours of video tutorials from...
  3. Tip #12 – Use Paint.NET as a Free Alternative to Photoshop Paint.NET is free, and it works very similar to Photoshop....
  4. SQL Server 2005:(10 Hours) Backup SQL Server 2005, SQL Server Insert, SQL Server Training, SQL Server Profiler, Download SQL Server 2005, SQL Server Script, SQL Server Tutorial 10 Free One-Hour Videos From Microsoft Expert, Bryan Von Axelson....
  5. Open Example JavaScript (JS): HTML DOM Objects – Document Object Methods – Open Example JavaScript (JS) Open Example JavaScript (JS): HTML DOM Objects - Document Object...

Related posts brought to you by Yet Another Related Posts Plugin.

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

Powered by WP Hashcash

This blog uses the cross-linker plugin developed by Web-Developers.Net