Product articles Redgate Monitor

SQL Monitor’s new Current Activity page

We recently released a minor version of SQL Monitor, v12.1, that includes Tagging and a new ‘Current Activity’ page. This blog post will outline the latter feature. What is the new Current Activity page? SQL Monitor provides a lot of information on individual servers collected through our samplers which run periodically. That information is useful Read more

Is Tempdb Causing a Bottleneck?

One of your SQL Server instance shows a major dip in performance or throughput, affecting all the user databases. You notice that the slow interludes coincide, as if orchestrated. On investigation, it appears that several transactions running over that period were using a lot of space in tempdb. However, which of them, if any, are causing the tempdb bottleneck, and why? Read more