April 10, 2023 in Releases by David Wiseman2 minutes
Identity column threshold configuration & more
You can now configure identity column thresholds in the GUI. For example, you might want to adjust the thresholds for a table that has hit the warning/critical thresholds but is no longer growing.
The scroll position is now maintained when extending the date range or navigating back from viewing a specific snapshot. The snapshot you have just viewed will also be highlighted when navigating back.
This makes it easy to see at a high level if RCSI (Read Committed Snapshot Isolation) is been used. Blocking is significantly reduced with this isolation level as readers and writers are able to run concurrently without blocking. RCSI is generally the best option for most use cases, though there are some tradeoffs to consider and testing needs to be done for existing applications.
Query timeouts have been extended and query timeout errors have been excluded from the retry policy. A query will often succeed on retry if it experiences a timeout for various reasons, but often it will be better to extend the query timeout instead of executing the query again from scratch. For more frequently executed queries, we can just wait for the next collection to run.
Some extra performance counters are available:
These are not currently enabled by default though. Create a new file called “PerformanceCountersCustom.xml” based on “PerformanceCounters.xml” and add this line:
Note: It’s already there ready to comment out.
See here for more info on customizing performance counters.
See here for a full list of fixes.