Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    8

    Angry Unanswered: SQL profiler error : SELECT N'Testing Connection...'

    Hi,
    our SQL server is frequently blocked for a while.
    After monitoring with SQL Profiler I found these messages in trace :

    SELECT N'Testing Connection...'
    EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

    What this could be. Wich connection is in test. This message run frequently.

    Thanks for any help
    Valentino

  2. #2
    Join Date
    Sep 2003
    Posts
    212
    try running the command u got from profiler in QA and see what u get

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    This command is really just the SQL Agent checking to make sure that the SQL Server is available. It should not cause any performance drain.

Posting Permissions

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