none
sql query analyser

    Question

  • hi

      I am searching for an automated tools which analyse stored procedure, tables and views in Sql. Please help me to find out the tools available in it.

    Thanks in advance

    Friday, June 08, 2012 6:17 AM

Answers

All replies

  • an automated tools which analyse stored procedure, tables and views in Sql

    Hello,

    First, this is a forum for SSAS, not for the relational database engine.

    What do you exactly mean with analyse tables etc? Analyse for what?


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing

    Friday, June 08, 2012 6:31 AM
  • Hi Arun Thangavel,

    Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services. You can capture and save data about each event to a file or table to analyze later. For example, you can monitor a production environment to see which stored procedures are affecting performance by executing too slowly. For more information about it, please see: http://msdn.microsoft.com/en-us/library/ms181091.aspx

    And here is an article about SQL Server Profiler Step by Step: http://www.codeproject.com/Articles/21371/SQL-Server-Profiler-Step-by-Step

    Please feel free to let me know if my understanding is wrong.

    Thanks,
    Eileen

    • Marked as answer by Eileen Zhao Wednesday, June 20, 2012 2:41 AM
    Thursday, June 14, 2012 11:34 AM