Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Tool similar to SQL Profiler

Posted on 2006-11-08
6
Medium Priority
?
568 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
6 Comments
 
LVL 11

Accepted Solution

by:
regbes earned 100 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 100 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 43

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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

916 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