The Virtual Group feature provides a mechanism for logical grouping of the Navigation Pane's database objects by category, so that all objects are more effectively organized. It can be applied to many different object types, including:
All of Navicat's database management and design products, i.e. Navicat MySQL, MariaDB, SQL Server, SQLite, Oracle, PostgreSQL, and Premium, include a Navigation Pane. It provides more than a means to navigate between your connections, schemas, databases and database objects. In Non-Essentials Editions, it also features Virtual Grouping, which is a logical grouping of objects by categories. In today's tip, we'll be going over how to manage your connections within the Navigation Pane. In part 2 we'll learn how to utilize Virtual Grouping.
In What to Monitor on SQL Server (Part 1), we reviewed two of the four main categories of performance metrics to monitor in order to gauge SQL Server efficacy, namely Disk Activity and Processor Utilization. Today's blog will cover Memory and Server operations.
Microsoft SQL Server is more than 30 years old now, and remains one of the most popular commercial relational databases in use today. It runs very efficiently with only minimal tweaking, but can also be tuned for optimal performance. Before fine tuning your SQL Server database, you first have to monitor its performance over a broad spectrum of conditions and workloads. In today’s tip, we’ll review a few of the most instructive metrics to monitor in order to gauge server performance.
One of the numerous significant changes to MySQL Server for version 8 includes a new component-based infrastructure. That will make the architecture more modular while allowing users to extend server capabilities through the addition of individual components.
Each component provides services that are available to the server as well as to other components. In fact, the server itself is now considered to be a component, equal to other components. Components interact with each other only through the services they provide.
- 2024 (1)
- 2023 (1)
- 2022 (1)
- 2021 (1)
- 2020 (1)
- 2019 (1)
- 2018 (1)
- 2017 (1)
