Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    Unanswered: SQL Perf Counters Log keeps stopping

    Initially I had created a Perf Counter Log job that would save it to a text (csv) file. Recently I decided to start saving the information to SQL tables and since then SQL Perf Counters Log keeps stopping at random hours; I set up the Stop log After Option to 300 day Units and the When a log file closes to Start a new log file.

    I have had to start the Log file manually everytime; is there anything I can do about it or should I go back to saving it to csv files?


  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    It's always a bad idea to send either traces or BLG logs directly to SQL. Both logs can be very easily loaded after the collection have been completed.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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