Redgate upgrades SQL Monitor’s query tuning capability to help development teams act faster and smarter


As part of its ongoing program to continuously release improvements for its SQL Server performance monitoring tool, Redgate Software today announced a new feature to alleviate tuning issues DBAs and developers are experiencing. and query optimization. SQL Monitor’s advanced query tuning and tracking capability will now allow DBAs and developers to identify long and expensive queries, get recommendations and tips on how to optimize them, and track them for comparison their performance over time.

The upgrade was prompted by the fact that monitoring query performance is a complex and time-consuming task for database administrators and developers, and that there is a lack of knowledge and, increasingly more, a lack of time. Whether it’s identifying why applications are running slowly, reducing the cost of cloud services which is often correlated to CPU and memory usage, or freeing up server resources, optimizing database queries improves the performance of databases and the applications that use them.

However, query tuning itself is a difficult problem, as poorly executed queries can have many reasons, ranging from poorly designed database schema to poor indexing, and from misconfigured servers to problems with the query text itself. As a result, many DBAs and developers don’t know how to approach it, often hiring consultants to help them diagnose SQL Server performance, which, in turn, delays development work.

To overcome this issue, SQL Monitor now allows users to find problematic queries faster, view the metrics and information they need to analyze them in an easily accessible graphical interface, access troubleshooting tips , and then track ongoing performance over time. It does this by measuring requests based on factors such as CPU consumption, physical reads, or logical writes, and then ranks them based on their overall impact on server performance. This allows database administrators to identify queries that need the most attention and focus their scarce resources where it matters most.

Importantly, SQL Monitor also steps in at this point to help with query optimization by providing recommendations that highlight the problem and can be further expanded to show a full description with more information and suggested fixes. .

This allows developers as well as DBAs to troubleshoot issues on their own, speed up development, and maintain peak application performance. They can also closely monitor the issue, as the tracking ability allows them to see how a query is performing once it has been optimized. Teamwork is further encouraged with the ability to share queries so that developers and database administrators can work together to optimize performance.

The team behind SQL Monitor is currently investigating how query tuning can be fine-tuned to improve workflows in development and production environments and further improve collaboration.

To find out how Redgate SQL Monitor can help DBAs and development teams improve query tuning, organizations can download a fully functional 14-day free trial of the database monitor tool or view a live demo. online at www.red-gate.com/sql-monitor.

About Redgate Software
Redgate makes ingeniously simple software used by more than 800,000 IT professionals worldwide and is the leading provider of Database DevOps solutions. Redgate’s philosophy is to design highly usable and reliable tools that elegantly solve the problems that developers and DBAs face every day and help teams get the most out of any database, on any number. growing platforms, everywhere. In addition to streamlining database development and preventing the database from being a bottleneck, it helps organizations introduce data protection by design and by default. As a result, more than 200,000 companies use Redgate tools, including 91% of those in the Fortune 100.

contacts
Meghana Shendrikar
Allison+Redgate Software Partners
[email protected]

Previous Brinker International changes its management structure to align with its new strategy
Next Africa's economic transformation hinges on high-level skills