To do this i wrote this quick function based on examples i found on Microsoft's blogs.
<cffunction name="getIndexStatsSnapshots" output="No" returntype="any" description="retrieves index statistics at N snapshots with given interval in seconds">
<cfargument name="DBName" default="NULL" type="any">
<cfargument name="DBObjName" default="NULL" type="any">
<cfargument name="indexName" default="" type="any">
<cfargument name="snapshotsNumb" default="2" type="any">
<cfargument name="snapshotsInterval" default="10" type="any">
<cfset var getIndexStatsSnapshots = ArrayNew(1)>
<cfset var getIndexStatsSnapshotsQ = "">
<cfset var i = 0>
<cfset var thread = "">
<cfset var sleepTime = snapshotsInterval*1000>
<cfloop index="i" from="1" to="#snapshotsNumb#">
<cfquery name="getIndexStatsSnapshotsQ" datasource="yourdsn" username="youruserName" password="yourpasswd">
declare @dbid int
select @dbid = db_id('#DBName#')
declare @objid int
select @objid = object_id('#DBObjName#')
select s.database_id, db_name(s.database_id) as dbName
,s.object_id, object_name(s.object_id) as objName
,s.index_id
,s.partition_number
,s.leaf_insert_count
,s.leaf_delete_count
,s.leaf_update_count
,s.leaf_ghost_count
,s.nonleaf_insert_count
,s.nonleaf_delete_count
,s.nonleaf_update_count
,s.leaf_allocation_count
,s.nonleaf_allocation_count
,s.leaf_page_merge_count
,s.nonleaf_page_merge_count
,s.range_scan_count
,s.singleton_lookup_count
,s.forwarded_fetch_count
,s.lob_fetch_in_pages
,s.lob_fetch_in_bytes
,s.lob_orphan_create_count
,s.lob_orphan_insert_count
,s.row_overflow_fetch_in_pages
,s.row_overflow_fetch_in_bytes
,s.column_value_push_off_row_count
,s.column_value_pull_in_row_count
,s.row_lock_count
,s.row_lock_wait_count
,s.row_lock_wait_in_ms
,s.page_lock_count
,s.page_lock_wait_count
,s.page_lock_wait_in_ms
,s.index_lock_promotion_attempt_count
,s.index_lock_promotion_count
,s.page_latch_wait_count
,s.page_latch_wait_in_ms
,s.page_io_latch_wait_count
,s.page_io_latch_wait_in_ms
,getdate() as timeStamp
,i.name as index_name
from sys.dm_db_index_operational_stats(@dbid, @objid, NULL, NULL) s, sys.indexes i, sys.objects o
Where i.index_id = s.index_id
and o.type = 'U'
and o.object_id = i.object_id
<cfif Len(Trim(indexName))>
and i.name = '#indexName#'
</cfif>
</cfquery>
<cfset getIndexStatsSnapshots[i] = getIndexStatsSnapshotsQ>
<cfif i lt snapshotsNumb>
<cfset thread = CreateObject("java", "java.lang.Thread")>
<cfset thread.sleep(Evaluate(sleepTime))>
</cfif>
</cfloop>
<cfreturn getIndexStatsSnapshots>
</cffunction>