An Improved GUI Results in Better SQL Server Tuning

by Dec 17, 2019

Categories

Tags

Administration agent-based monitoring Agentless Monitoring alert responses alert thresholds alerting Alerts Amazon Aurora Amazon EC2 Amazon RDS Amazon RDS / Aurora Amazon RDS for SQL Server Amazon Redshift Amazon S3 Amazon Web Services (AWS) Analytics application monitoring Aqua Data Studio automation availability Azure Azure SQL Database azure sql managed instance Azure VM backup Backup and recovery backup and restore backup compression backup status Backup Strategy backups big data Blocking bug fixes business architecture business data objects business intelligence business process modeling business process models capacity planning change management cloud cloud database cloud database monitoring cloud infrastructure cloud migration cloud providers Cloud Readiness Cloud Services cloud storage cloud virtual machine cloud VM clusters code completion collaboration compliance compliance audit compliance audits compliance manager compliance reporting conference configuration connect to database cpu Cross Platform custom counters Custom Views customer survey customer testimonials Dark Theme dashboards data analysis Data Analytics data architect data architecture data breaches Data Collector data governance data lakes data lineage data management data model data modeler data modeling data models data privacy data protection data security data security measures data sources data visualization data warehouse database database administration database administrator database automation database backup database backups database capacity database changes database community database connection database design database developer database developers database development database diversity Database Engine Tuning Advisor database fragmentation database GUI database IDE database indexes database inventory management database locks database management database migration database monitoring database navigation database optimization database performance Database Permissions database platforms database profiling database queries database recovery database replication database restore database schema database security database support database synchronization database tools database transactions database tuning database-as-a-service databases DB Change Manager DB Optimizer DB PowerStudio DB2 DBA DBaaS DBArtisan dBase DBMS DDL Debugging defragmentation Demo diagnostic manager diagnostics dimensional modeling disaster recovery Download drills embedded database Encryption End-user Experience entity-relationship model ER/Studio ER/Studio Data Architect ER/Studio Enterprise Team Edition events execution plans free tools galera cluster GDPR Getting Started Git GitHub Google Cloud Hadoop Healthcare high availability HIPAA Hive hybrid clouds Hyper-V IDERA IDERA ACE Index Analyzer index optimization infrastructure as a service (IaaS) infrastructure monitoring installation Integrated Development Environment interbase Inventory Manager IT infrastructure Java JD Edwards JSON licensing load test load testing logical data model macOS macros managed cloud database managed cloud databases MariaDB memory memorystorage memoryusage metadata metric baselines metric thresholds Microsoft Azure Microsoft Azure SQL Database Microsoft PowerShell Microsoft SQL Server Microsoft Windows MongoDB monitoring Monitoring Tools Monyog multiple platforms MySQL news newsletter NoSQL Notifications odbc optimization Oracle PeopleSoft performance Performance Dashboards performance metrics performance monitoring performance schema performance tuning personally identifiable information physical data model Platform platform as a service (PaaS) PostgreSQL Precise Precise for Databases Precise for Oracle Precise for SQL Server Precise Management Database (PMDB) product updates Project Migration public clouds Query Analyzer query builder query monitor query optimization query performance Query Store query tool query tuning query-level waits Rapid SQL rdbms real time monitoring Real User Monitoring recovery regulations relational databases Releases Reporting Reports repository Restore reverse engineering Roadmap sample SAP Scalability Security Policy Security Practices server monitoring Server performance server-level waits Service Level Agreement SkySQL slow query SNMP snowflake source control SQL SQL Admin Toolset SQL CM SQL code SQL coding SQL Compliance Manager SQL Defrag Manager sql development SQL Diagnostic Manager SQL Diagnostic Manager for MySQL SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager Pro SQL DM SQL Doctor SQL Enterprise Job Manager SQl IM SQL Inventory Manager SQL Management Suite SQL Monitoring SQL Performance SQL Quality SQL query SQL Query Tuner SQL Safe Backup SQL script SQL Secure SQL Security Suite SQL Server sql server alert SQL Server Migration SQL Server Performance SQL Server Recommendations SQL Server Security SQL statement history SQL tuning SQL Virtual Database sqlmemory sqlserver SQLyog Storage Storage Performance structured data Subversion Support tempdb tempdb data temporal data Tips and Tricks troubleshooting universal data models universal mapping unstructured data Uptime Infrastructure Monitor user experience user permissions Virtual Machine (VM) web services webinar What-if analysis WindowsPowerShell

Database transactions are at the heart of many mission-critical applications throughout the business world. Monitoring these transactions to tune them to maintain or increase their level of performance is an important task for a database team. DBAs employ a variety of tools to keep their databases operating at peak efficiency.

IDERA’s Precise for Databases is a trusted tool that has been used for years by many SQL Server DBAs. It offers many features designed to help your database team get the most out of your SQL Server environment. Here are some examples of its impressive set of features.

  • A fully customizable monitoring platform allows details of database transactions to be collected continuously to identify trends and problems with the system. Data can be sampled with a granularity of less than a second for real-time monitoring. Correlations can be defined between transactions and the objects they access to add context to the monitoring process.

  • The tool provides the ability to drill down into monitored transactions to quickly isolate issues. Performance details and application context furnish the full infrastructure path the transaction traverses. Locks and latches can be identified in real-time or from a historical perspective to allow fast problem resolution.

  • Precise furnishes a number of features specifically aimed at tuning database performance. The application provides expert tuning advice to tune SQL statements, objects, and indexes. Simulate the effects of prospective changes on other SQL statements. Performance data is regularly analyzed by the tool’s SmarTune process to alert you of system degradation.

A New Interface for SQL Server DBAs

Precise’s GUI has recently been given an overhaul that improves its functionality and enables users to obtain even more value from the app. Here’s an overview of the changes that SQL Server DBAs will appreciate.

  • Precise 10.0 extends the usability of the tool by enabling it to be run on the Chrome and Firefox web browsers in addition to the previously supported Internet Explorer. Almost everyone has a favorite browser and being able to use it when accessing important tools while on the job just makes the day a little more pleasant. It might make you a little more productive too as you don’t need to navigate between different interfaces. There is a slight difference in how you specify the URL to connect to your precise instance. Chrome requires /Precise to be appended after the port number.

  • The Precise dashboard maintains the look and feel of previous versions of the application. It displays your database transactions graphically and presents color-coded findings to help identify areas of concern. All applications, tiers, and monitored instances are made available for further investigation.

  • Clicking on the Activity tab brings up a comprehensive view of the databases in the SQL Server environment. A new feature in version 10.0 lets you add or remove columns and export data. Clicking on a database provides a list of statements in order of execution time. Continuing to dive deeper displays findings and recommendations that may improve the statement’s performance.

  • Pre and Next buttons are used to navigate back and forth through windows in Precise 10.0. You can dive down into any aspect of your databases and identify the findings that the tool has found. In each case, the application furnishes recommendations to help tune the database. It allows you to get as fine-grained as you want when searching for ways to boost the performance of your database transactions.

An IDERA educational video that demonstrates the features of the new GUI visually is available for your viewing pleasure. It demonstrates the highlights for new users and those experienced with previous versions of the tool. Take a look to see how Precise can help you keep your databases running smoothly and your users happy.