Solved

Tool similar to SQL Profiler

Posted on 2006-11-08
6
559 Views
Last Modified: 2010-08-05
Hi Guys. Is there any freeware offers similar functionality to MS SQL Server Profiler? Thank you very much
0
Comment
Question by:NguyenHuy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 11

Accepted Solution

by:
regbes earned 25 total points
ID: 17904401
Hi NguyenHuy,

Profiler is free.

HTH

R.
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 25 total points
ID: 17904417
why don't you want to use the sql profiler itself?

note that all it uses to "profile" are some system stored procedure you can call yourself:
http://msdn2.microsoft.com/en-US/library/ms187346.aspx
0
 
LVL 42

Expert Comment

by:Eugene Z
ID: 17905533
Buy SQL Server 2005 Developer Edition and get free SQL Server Profiler ..

also you may use sp_who3 (there is one of many variants)

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1109

to collect data in table and analyze it ...
0
 
LVL 1

Author Comment

by:NguyenHuy
ID: 21707545
Thanks guys for your answers and my apologies for not clearing it up. Your answers are very helpful. Cheers.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question