Click here to Skip to main content
15,940,246 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

what is SQL Profiler? what is the advantages of this? Is there anything substitute of this?

Bye
Posted

Read this description : http://msdn.microsoft.com/en-us/library/ms181091.aspx[^]

SQL Profiler helps you see your performance problems and gives you advise on indexes which will boost performance.

SQL Profiler is tightly integrated into the SQL Server platform so substitutions will be lacking (and it is supplied with your SQL license anyway).
 
Share this answer
 
Comments
RaisKazi 5-Nov-11 2:15am    
Nice link and to the point description. :) 5ed
Mehdi Gholam 5-Nov-11 2:19am    
Cheers
Uday P.Singh 5-Nov-11 2:20am    
my 5+ too :)
Mehdi Gholam 5-Nov-11 2:41am    
Thanks
Mehdi Gholam 5-Nov-11 2:41am    
Thanks
Google is your friend.

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services.

For more information read these:

http://msdn.microsoft.com/en-us/library/ms181091.aspx[^]

http://www.careerride.com/SQL-server-SQL-Profiler-purpose.aspx[^]

SQL Server Profiler Step by Step[^]

hope it helps :)
 
Share this answer
 
Comments
Mehdi Gholam 5-Nov-11 2:11am    
5'ed
Uday P.Singh 5-Nov-11 2:19am    
thanks Mehdi :)
RaisKazi 5-Nov-11 2:14am    
Nice Links. :) 5ed
Uday P.Singh 5-Nov-11 2:19am    
thanks RaisKazi :) how are you doing?
RaisKazi 5-Nov-11 3:05am    
Doing good :) Thanks Man.
SQL Profiler allows you to monitor and capture events on an instance of SQL Server. You can configure it to capture all events or just a subset that you need to monitor
Reference Link :- Advantages of SQL Profiler[^]
for further reference Using SQL Profiler [^]
and This Link-[Sql Server Profiler][^] refering two substitute.
From Reference
The express edition of Microsoft SQL Server 2005/2008 is free. But it doesnt provide professional tools for profiling sql queries. SQL Server Express Edition Profiler provides the most of functionality standard profiler .
AnjLab SQLProfiler[^]
Query profiling tool for the MySQL database server, helps you spot performance bottlenecks, heavy sql queries and most accessed db tables.
Jet Profiler for MySQL[^]
 
Share this answer
 
Comments
RaisKazi 5-Nov-11 3:08am    
My 5! And "+" for the last statement. Really "SQL Profiler" is a very helful tool when sometimes SQL Performace tunning becomes a Nightmear. :)
RaviRanjanKr 5-Nov-11 3:38am    
Thanks :)
Mehdi Gholam 5-Nov-11 3:10am    
5'ed
RaviRanjanKr 5-Nov-11 3:38am    
Thanks Mehdi
Uday P.Singh 5-Nov-11 3:16am    
5+

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900