Capturing Stored Procedure, Table and View info with SQL Profiler

From: Sam (Sam_at_discussions.microsoft.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 12:55:05 -0700

I have just started using SQL 2000 SQL profiler to capture server information
on Stored Procedures. I need some help in understanding how to use this tool
to capture information on views and tables (how often they are used, which
ones are used and which ones are not used, etc).
I would appreciate any help that might be available. Thanks.

Sam

Relevant Pages

  • Truncating Parameters in VS.Net 2003
    ... I have some stored procedures that accept a text parameter ... Right Click on sproc in VS.Net Server Explorer. ... but SQL Profiler shows truncated parameter. ...
    (microsoft.public.vsnet.ide)
  • Re: **follow "login" activities**
    ... SQL Profiler can help you do this. ... You can also use some third party tools like Lumigent Explorer which let you ... read the contents of a transaction log from where you can get this ... > look in the Master dB at the stored procedures and extended procedures. ...
    (microsoft.public.sqlserver.security)
  • SQL profiler and index tuning wizard permissions
    ... index tuning wizard. ... however I recently read an article saying that sql profiler can be run by ... I can't find any reference to any kind of stored procedures used by index ...
    (microsoft.public.sqlserver.security)
  • Re: How does OWSSVR.dll call proc_FetchDocForHttpGet stored procedure?
    ... as the stored procedures could be called from other ... In any case, I appreciate your advice! ... So if you want to research the dll internal on how to reach the store procedure, I'd suggest you can use SQL profiler to monitor the SQL ...
    (microsoft.public.sharepoint.portalserver.development)