ak

• Nov 29th, 2005

 

It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuning wizard to improve performance.Go to http://microsoft.msdn.com and search for SQL profiler for more detailed information on how to use it and what features are available with ample examples provided.

jannani

 Profile Answers by jannani 

• May 12th, 2009

 

SQL profiler is a graphical tool that allows system administrator to monitor in an instance of the SQL Server.

Use of SQL Profiler:

• Monitor the performance of an instance of SQL Server.
  
  
• Debug Transact-SQL statements and stored procedures.
  
  
• Identify slow-executing queries.
  
  
• Test SQL statements and stored procedures in the development phase of a project by single-stepping through statements to confirm that the code works as expected.
  
  
• Troubleshoot problems in SQL Server by capturing events on a production system and replaying them on a test system. This is useful for testing or debugging purposes and allows users to continue using the production system without interference.
  
  
• Audit and review activity that occurred on an instance of SQL Server. This allows a security administrator to review any of the auditing events, including the success and failure of a login attempt and the success and failure of permissions in accessing statements and objects.