mjswart-d2l / CollectWaitStats

Collect wait statistics from SQL Server's system views.
12 stars 5 forks source link

Optimize for Deletes #4

Open mjswart-d2l opened 3 years ago

mjswart-d2l commented 3 years ago

Deletes happen every minute, Reporting happens infrequently and can get by by scanning the table

Reverse the existing order of columns of the PK from (wait_type, collected_date) to (collected_date, wait_type)