Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2004
    Posts
    76

    Unanswered: Application goes slow or not responding after few transaction

    Dear all viewer ,

    Thanks to everyone.

    We are using -
    MSSQL Server 2000 on windows 2000 advanced server.
    PB 7.0 for client server front end tools.

    Prior to few days our application works fine, rightnow it get slow or not responding after few (4/5) transaction. We don't know wht it is, If anyone has same experience so that is helpfull for us.

    Thanks

    R.Mall

  2. #2
    Join Date
    Dec 2004
    Location
    CA, USA
    Posts
    63

    profiler

    Monitor your activity with SQL Profiler.

  3. #3
    Join Date
    Sep 2004
    Posts
    76
    Thanks for reply

    How I can do it? Can you give me step by step methods?

    R.Mall

  4. #4
    Join Date
    Dec 2004
    Location
    California, USA
    Posts
    93
    SELECT Profiler
    FROM BooksOnline

    or

    SELECT Consultant
    FROM YellowPages
    Whoever imagines himself a favorite with God holds others in contempt. - Robert Green Ingersoll, lawyer and orator (1833-1899)

  5. #5
    Join Date
    Sep 2004
    Posts
    76
    Thanks for right suggession, I will do it.

    Thanks

  6. #6
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    I wonder if he actually did that?

    You can also find information about running Profiler from:

    www.sql-server-performance.com
    www.sqlteam.com
    SQL Server 2000 Performance Tuning Technical Manual (Microsoft Press)
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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