CODEWITHSUNDEEP
asp.netsql-server-2008profiler
Eslam Soliman
Eslam Soliman

Reputation: 1296

Sql Server Profiler Free Tool

I need A free Sql 2008 R2 Profiler As I Can not Use Sql Server Included Sql Profiler for some reasons. If there are any free profiling tools or something like this - it will be good

Upvotes: 2

Views: 4499

Answers (5)

akiller
akiller

Reputation: 2472

Why can't you use the included one, does it error? I never found anything which came close to the included one apart from AnjLab Profiler. The only annoyance with it is you can't export traces for tuning.

Upvotes: 1

Dennis Traub
Dennis Traub

Reputation: 51684

There is an open source SQL Profiler by AnjLab which I'm using regularly:

  • [AnjLab SQLProfiler][1]

Upvotes: 0

saille
saille

Reputation: 9191

Anjlab Sql Profiler was great, and still is if you can get your hands on the old free version.

Now there is Datawizard SQL Performance Profiler which has a free trial, but is commercial.

Upvotes: 0

gbn
gbn

Reputation: 432657

To run traces like SQL Server Profiler, even with AnjLab's replacement, you still need server-side permissions to run it.

In SQL Server 2000, you had to be a member of the sysadmin

In SQL Server 2005, you can GRANT ALTER TRACE to allow non-sysadmins to run either profiling tool

Upvotes: 3

Oleg Dok
Oleg Dok

Reputation: 21776

Learn about profiling background, Events, traces and Extended events and in your case you will not need a profiler, since you'll be able to do all there tricks by proper querying the sql server itself.

Take a look also on Dynamic Management Views and Functions

And finally there is one free tool available sqlexpressprofiler and also here is one more from Google code named AnjLab

Some solutions provided by Idera

Upvotes: 2

Related Questions