Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Posts
    41

    Question Unanswered: Monitoring / Logging Suggestion

    Hi Everyone,

    I'm looking for some suggestions on how I can go about the following task. I have an application which connects to our SQL2000 servers. Ocasionally some of the db connections take a long time to run. What I'd like to do is enable some sort of logging which would provide me with the following pieces of information... where the request originated from, length of time servicing the request, some sort of info on the nature of the request (search, insert, update, sproc, etc...), time of the request.

    I'd then like to cross reference these logs with my application logs to isolate which requests are taking to long to service. Hopefully this will help us as we attempt to eliminate the issue.

    Thanks for any suggetions you might have!!!! much appreciated!

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    You can use the Profiler which is a standard tool that comes with SQL Server. Several templates are already defined to create a trace (such as for performance measuring) or you can create your own. See Books Online for more info about the parameters and settings.
    Johan

  3. #3
    Join Date
    Feb 2003
    Posts
    41
    Thanks for the suggestion Johan. Taking a look now!

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Try this

    I attached an MSAccess database which may or may not be helpful for you. It monitors SQL Server sessions. It's written in MSAccess XP.
    Attached Files Attached Files

Posting Permissions

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