(SQL) Tip of the Day: New Near Real Time Resource DMV
Today’s (SQL) Tip…
With the GA of Editions, this new DMV exposes near real-time resource usage metrics within a database on a 15 second interval (as opposed to sys.resource_stats at a 5 minute interval), which may be useful to allow customers to determine appropriate resource sizing for their database, as described in the blog post.