SQL Server Performance

How to analyze SQL statements/Stored Procedures within a database

Discussion in 'SQL Server 2008 General DBA Questions' started by Sinora, Jun 20, 2011.

  1. Sinora New Member

    Hey Guys,

    How do I figure out with SQL what fields/tables are being accessed without having to manually look through the generated tables? For example, there are 5 stored procedures in my database. How do I locate them, and how do I figure out what tables they are accessing?
  2. Luis Martin Moderator

    You can use some 3rd party tools like Red Gate. Sql Doc or SQL Dependency give you what you want.
  3. peterpatrickgo New Member

    Actually I am currently using Red Gate, it could help me easily manage the SQL;)
  4. satya Moderator

Share This Page