0
votes
1answer
38 views

Is it possible that a same INSERT operation performance will suddenly degrade?

I am working on a code performance test project. Let me first describe the enviorment: MsSql Server, Ria Service The automation test runs a big set of Test cases in midnight where have minimum ...
3
votes
1answer
259 views

How to track overhead of Change Tracking in SQL Server

We're going to implement a solution based on Change Tracking feature from SQL Server. Before going in production (even after), we'd like to keep track of the overhead the CT will introduce. Once in ...