Post reply

Monitoring Tables

  • November 4, 2015 at 11:02 am

    #399277

    Hello,

    Im developing a process to monitors a table in a high transaction database. The process will count the number of lines in the table to verify if it has changed or it is stuck. Due to the fact that the database has a lot of transaction I dont want to execute a query on th database too often.l Is there anothe suitable way to accomplish this goal ?

    Thanks!

  • November 4, 2015 at 11:13 am

    #1837756

    Consider querying the system tables - sys.partitions or sys.dm_db_partition_stats.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 4, 2015 at 11:53 am

    #1837767

    Thanks for the suggestion I will try!!!!

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

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