SQL Monitoring

  • SQLEYES

    Old Hand

    Points: 312

    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

     

  • MVDBA (Mike Vessey)

    SSC-Insane

    Points: 21757

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

    MVDBA

  • Grant Fritchey

    SSC Guru

    Points: 396692

    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

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

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

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