SQL Monitoring

  • Hi All,

    I have SQL 2012 instance on a vm server  which I am testing with Red Gate Monitoring Tool installed on my machine and my machine machine is set a base monitor for testing purpose. Problem I am facing is that  it only monitor while I am logged on to the machine. If  I lock or log out  it stop recording the events and nothing logged for that period despite machine still on .  I am using domain logins and don't see anywhere in the configuration that one can change the settings to keep the monitoring active disregard user logged in or logged off.

    Any help or suggestion would be much appreciated.

     

    Regards

    Imi

     

  • we have a little app server and use a service account for monitoring - that should fix your issue

    MVDBA

  • For the Monitor to stop monitoring you have to be stopping the service. That shouldn't be dependent on you logging in. Are you sure that things are actually running? You might want to contact support on this.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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