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?
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. :confused:
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
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.