Page 1 of 2 12 LastLast
Results 1 to 15 of 25

Thread: Can't start performance log counter

Hybrid View

  1. #1
    Join Date
    Jul 2005
    Posts
    32

    Can't start performance log counter

    I'm a local admin on a SQL Server with dba permissions. I can view that SQL Server in System Monitor and I can create a performance log counter. When I try to start the counter, I get an error: ---------------------------
    Performance Logs and Alerts
    ---------------------------
    The SQLSever log or alert has not started. Refresh the log or alert list to view current status, or see the application event log for any errors. Some logs and alerts might require a few minutes to start, especially if they include many counters.
    ---------------------------
    OK
    ---------------------------

    Does anyone have ideas why this isn't working?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Check if Performance Log and Alerts service is running (from control panel - services)

  3. #3
    Join Date
    Jul 2005
    Posts
    32

    Can't see Performance Log counters

    I got into Services and tried to start the Performance Log service. I tried both automatic and manual and they appear to start and then immediately stop.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Is it running with local system account?

    Do you see any error in event log for the service?

    Try running it from command line useing NET START command, this way you can see the error.

  5. #5
    Join Date
    Jul 2005
    Posts
    32

    Can't see Performance Log counters

    It is running as the local system account.

    I don't see any errors in the event log.

    I'm unfamiliar with Net Start. For the Net start command do you just type:
    net start Performance Logs and Alerts

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Should be

    net start "Performance Logs and Alerts"

    May get same sresult since you can't run it in services applet. Should have message in windows system event log.

  7. #7
    Join Date
    Jul 2005
    Posts
    32

    Can't see Performance Log counters

    Thanks very much for your ideas. The weird thing is that the service starts and then immediately stops. So it's not a permissions problem. I used the net start command and looked at the window and it said the service was started, but then when I hit refresh in the computer management screen the status is blank instead of "Started". Ugh.

  8. #8
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Do you get any error in system event logs?. If you see any performance counter related messages, you may have to re-load the counters.

  9. #9
    Join Date
    Jul 2005
    Posts
    32
    There were no errors either in the system log or the application log but the service didn't remain started.

    How would I re-load the counters?

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    Tried start the service with other account? Do you have any group policy to prevent you to start that service?

  11. #11
    Join Date
    Jul 2005
    Posts
    32
    Our network admin tried it, since he has all permissions and he at least got an error "Internal Windows 2000 error occurred" with error # 2140.

    We have no group policies.

  12. #12
    Join Date
    Sep 2002
    Posts
    5,938
    Any other error message in windows event log? Which win2k sp the server has?

  13. #13
    Join Date
    Jul 2005
    Posts
    32
    It's running Windows 2000 5.00.2195 SP 4. I've never gotten any errors in the system log or the application log, which seems very odd.

    The only other thing I can think of is that I'm VNC'ing into the machine, and don't know if I need any remote monitoring services set up as well.

  14. #14
    Join Date
    Jul 2005
    Posts
    32
    I just found something odd. When I look at the computer running SQL Server, it says it's Windows 2000 5.0. But looking at the properties of SQL Server it says the operating system is MS Windows NT (2195) 8.00.760 SP3. I don't see how it can have 2 different versions of the operating systems.

  15. #15
    Join Date
    Sep 2002
    Posts
    5,938
    No, 8.00.760 SP3 is sql version number. Anyone tried start the service on the server directly?

Posting Permissions

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