Professional Web Applications Themes

Trace statements executed by ASPs - Microsoft SQL / MS SQL Server

Hi, I have a website that has about 200 ASPs, a lot of these ASPs send SQL statements to a SQL 2000 sever for execution, is there a way to trace which ASP is issuing which statements? I would like to know if it's possible to trace from SQL server side. Of course I can modify all ASPs to insert SQL statements executed into a table, but that's not the answer I am looking for. Thanks in advance...

  1. #1

    Default Trace statements executed by ASPs

    Hi,

    I have a website that has about 200 ASPs, a lot of these ASPs send SQL
    statements to a SQL 2000 sever for execution, is there a way to trace which
    ASP is issuing which statements?

    I would like to know if it's possible to trace from SQL server side. Of
    course I can modify all ASPs to insert SQL statements executed into a table,
    but that's not the answer I am looking for.

    Thanks in advance


    Raymond Du Guest

  2. #2

    Default Re: Trace statements executed by ASPs

    You can run profiler and filter by the hostname or machine name.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Raymond Du" <rdrd> wrote in message
    news:Op5IKu$QDHA.2408TK2MSFTNGP10.phx.gbl...
    > Hi,
    >
    > I have a website that has about 200 ASPs, a lot of these ASPs send SQL
    > statements to a SQL 2000 sever for execution, is there a way to trace
    which
    > ASP is issuing which statements?
    >
    > I would like to know if it's possible to trace from SQL server side. Of
    > course I can modify all ASPs to insert SQL statements executed into a
    table,
    > but that's not the answer I am looking for.
    >
    > Thanks in advance
    >
    >

    Andrew J. Kelly Guest

  3. #3

    Default Re: Trace statements executed by ASPs

    Raymond Du (rdrd) writes:
    > I have a website that has about 200 ASPs, a lot of these ASPs send SQL
    > statements to a SQL 2000 sever for execution, is there a way to trace
    > which ASP is issuing which statements?
    >
    > I would like to know if it's possible to trace from SQL server side. Of
    > course I can modify all ASPs to insert SQL statements executed into a
    > table, but that's not the answer I am looking for.
    You will need some means to identify the ASP pages on server level. I don't
    know much about ASP, but I would assume that you have to set the application
    name in the connection string of the ASP. Once you have done that you can
    filter on application name in your trace.


    --
    Erland Sommarskog, SQL Server MVP, [email]sommaralgonet.se[/email]

    Books Online for SQL Server SP3 at
    [url]http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/url]
    Erland Sommarskog Guest

  4. #4

    Default Re: Trace statements executed by ASPs

    Hi

    I would also add that it would probably be benificial to move to stored
    procedures and take the code out of the page.

    John

    "John Bell" <jbellnewspostshotmail.com> wrote in message
    news:3f088ad1$0$13005$afc38c87news.easynet.co.uk. ..
    > Hi
    >
    > Look at "Monitoring with SQL Profiler" in Books online (under the
    > Administering SQL Server/Monitoring Server Performance and Activity
    section)
    >
    > Another alternative would be the log explorer from Lumigent, but this may
    be
    > an overkill for your requirements [url]http://www.lumigent.com/Products/[/url]
    >
    > John
    >
    > "Raymond Du" <rdrd> wrote in message
    > news:Op5IKu$QDHA.2408TK2MSFTNGP10.phx.gbl...
    > > Hi,
    > >
    > > I have a website that has about 200 ASPs, a lot of these ASPs send SQL
    > > statements to a SQL 2000 sever for execution, is there a way to trace
    > which
    > > ASP is issuing which statements?
    > >
    > > I would like to know if it's possible to trace from SQL server side. Of
    > > course I can modify all ASPs to insert SQL statements executed into a
    > table,
    > > but that's not the answer I am looking for.
    > >
    > > Thanks in advance
    > >
    > >
    >
    >

    John Bell Guest

Similar Threads

  1. Omitting Trace Statements
    By Jaxim in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: October 1st, 02:49 PM
  2. Internationalizing ASPs containing Javascript?
    By dr.strangedub in forum ASP Components
    Replies: 4
    Last Post: September 26th, 07:32 AM
  3. how to run asps on windows xp
    By Lakshmi Jagarlapudi in forum ASP.NET Web Services
    Replies: 0
    Last Post: December 5th, 06:15 AM
  4. Using Safe Arrays in ASPs
    By Bob.Brandt@galileo.ie in forum ASP
    Replies: 4
    Last Post: September 19th, 10:58 AM
  5. How can I test ASPs?
    By Rob Rutherford in forum ASP
    Replies: 3
    Last Post: August 24th, 02:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139