I'm working on a tool that I use to evaluate the performance of SQL Server queries in a development environment. I use, and highly recommend, tools like SentryOne's Plan Explorer, but my tool reports on queries submitted by application code. So I use Extended Events.
One of the things I've found is that the resolution of CPU times reported for the
sql_statement_completed events is poor. Even though the
cpu_time units is microseconds, the numbers reported are multiples of 15 milliseconds. That's much larger than the values I'm trying to measure, for a certain class of queries I work with. (Duration values are fine.)
Does anyone know a way to get higher-resolution CPU times? Maybe a server setting or a different field or event?