Re: SQL Monitor

From: Stephen Howe (stephenPOINThoweATtns-globalPOINTcom)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 18:16:10 -0000

> Is there a way to monitor and get all the querys that were sent via ADO?

SQL Profiler will do it if you have SQL Server installed.
It is more a case of seeing what monitoring tools come with your database
than from the ADO end.

Stephen Howe

Relevant Pages

  • Re: identiy_insert and data generators
    ... SQL Server is to use SQL Profiler to monitor the conversation. ... then add the identity columns back in? ...
    (microsoft.public.sqlserver.programming)
  • Re: .NET/SQL viewer
    ... I know Delphi has that kind of tool. ... SQL Server 2000 shipped with SQL Profiler, which I use to monitor the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Strange Performance Problem
    ... Use SQL Profiler to trace the actual execution plan that is used for the ... from both ADO and QA. ... Peter Yeoh ...
    (microsoft.public.sqlserver.server)
  • Monitoring Transaction Time
    ... How do I monitor how long a transaction/SQL Statement ... takes in SQL Profiler ??. ... Duration? ...
    (microsoft.public.sqlserver.server)
  • How to monitor a particular SP alone in Profiler
    ... I want to monitor a particular SP in Sql profiler. ... What are the parameters I should give in the trace? ...
    (microsoft.public.sqlserver.tools)