Post reply

How to count ALL INSERTS for database for a period of time?

  • September 6, 2013 at 4:20 am

    #277822

    Hi,

    Is a simple way to count all inserts for a given database for a period of time without using Data Collection?

    Thx in advance

  • September 6, 2013 at 4:37 am

    #1648003

    Depends a bit on how long a period you like to look at. You can use the sys.dm_db_index_operational_stats function and look at the leaf_insert_count column. But since it's a DMV it's cummulative and it will be cleared when the SQL server gets restart.

    You could setup a job to collect the the values daily into a table, and then calculate the deltas.

    [font="Verdana"]Markus Bohse[/font]

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

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