SQL Server:SQL Statistics SQL Attention Number of attentions ~0 Rate/sec per second e.g. cancels and query timeouts per second. This number should be as low as possible. A high sustained number indicates frequent query timeout or cancellation of queries. SQL Server:SQL Statistics SQL Number of SQL < 10% of the Compilations/sec Number of number of times, per second, that SQL Transact-SQL objects Compilations/ attempted to be sec executed but had to be recompiled before completion. This number should be at or near zero, since recompiles can cause deadlocks and exclusive compile locks. This counter’s value should follow in proportion to “Batch Requests/sec” and “SQL Compilations/sec”. This needs to be 0 in your system as much as possible.
SQL Server:SQL Statistics SQL Attention Rate/sec Number of attentions per second e.g. cancels and query timeouts per second. This number should be as low as possible. A high sustained number indicates frequent query timeout or cancellation of queries. ~0 SQL Server:SQL Statistics SQL Number of SQL Number of times, per second, that Transact-SQL objects attempted to be executed but had to be recompiled before completion. This number should be at or near zero, since recompiles can cause deadlocks and exclusive compile locks. This counter’s value should follow in proportion to “Batch Requests/sec” and “SQL Compilations/sec”. This needs to be 0 in your system as much as possible. < 10% of the number of SQL Compilations/ sec Compilations/sec