Management and monitoring

Although you can use and program the SQL Server 2019 big data clusters with standard T-SQL commands, there are quite a few components in addition to a single database server in the system. You'll need to employ some new tools to monitor the system, as well as to manage it.

In general, you'll use your regular SQL Server monitoring tools for database-specific operations, Kubernetes commands for the infrastructure, and visualization and logging tools for a complete overview of the system.

SQL Server components and operations

Since you are dealing with SQL Server in big data clusters, from the master instance to the computer pool, storage pool, and data pool, you can use the full range of tools for monitoring and management that work with any (Linux-based) SQL Server instance. You'll use the standard Dynamic Management Views (DMVs), T-SQL management and monitoring statements, graphical tools in SQL Server Management Studio and Azure Data...