Post reply

Perf Counters gone after using domain account

  • June 6, 2005 at 5:06 pm

    #88646

    As crazy as it sounds, it was fine before I changed the Server account from local to a domain account. This is the 4th server it has happened to me on. When I go to setup alerts there is no SQL server performance condition alerts. Something wiped the sysperfinfo table on me. All the SQL servers are 2000 SP3 they run on either W2K or W3K.

    Barring a resolution to this problem, is there a way to the counters back? Would service packing it work?

    Thanks

    Frank

  • June 7, 2005 at 12:54 am

    #563399

    This happens if SQL Server is restarted while System Monitor is open. You probably also have an error message in the error log that says something about failing to access shared memory or similar. Close sysmon and then restart the server.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • June 7, 2005 at 8:54 am

    #563566

    Chris,

    I did find that error. I will try that, thanks

     

    Frank

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply