Search
Related topics are listed below.
FDL – Farm Data Language
Advance Topics » FDL – Farm Data Language
Introduction to Farm Data Language Farm Data Language or FDL for short is the query language used in dbWatch to find information about objects. FDL is formerly known as DBWQL. This topic should be considered as the advanced part of dbWatch. It is also the central…
Modifying dbWatch
Configuration » Modifying dbWatch
Adding custom spring beans to the dbWatch server dbWatch provides some javabased hooks for customizing the behaviour of the dbwatch server. These hooks are injected into the server by the spring framework. Follow these steps to install custom classes into dbWatch…
dbWatch Monitor Setup
dbWatch Monitor Setup
This section contains information regarding the setup and usage of the dbWatch monitor. Below are the sub-topics for adding a specific database instance into your Control Center: Microsoft SQL Oracle
Backup of dbWatch
Troubleshooting Guide » Backup of dbWatch
When we think about backup of dbWatch, this involves several different parts of the software and installation: dbWatch Server and configuration files dbWatch Server is installed in a directory which is normally /usr/local/dbWatch/[version] on Unix/Linux and…
Devops with dbWatch
Devops with dbWatch
Database operations and devops Traditionally database operations has been a highly specialized field within it-operations. So much so that many organizations operate with platform specific dba teams. Because of the amount of platform specific know-how needed to…
dbWatch Control Center Navigation
dbWatch Control Center Navigation
In this chapter, we’ll be looking activities and operations to do in Control Center. ← Groups Configuration / Tree navigation →
About dbWatch Control Center
About dbWatch Control Center
dbWatch is a highly scalable software solution helping enterprises monitor and manage large numbers of database servers efficiently, providing total control over all aspects of operation, performance and resource usage. dbWatch will give you the total overview you need…
dbWatch monitoring and Reporting
dbWatch monitoring and Reporting
In this section, we’ll be discussing how to modify your monitoring dashboard and generating a report.. ← Category line chart / Monitoring →
Protecting the communication
Configuration » Protecting the communication
This page describes the communication between the dbWatch Monitor and the Server. The default setup To ensure the privacy of the user sessions, dbWatch wraps all communication between the monitors and the servers in ssl. During installation the installer generates…
The FString format
Advance Topics » The FString format
The FString format. FString is a format created to extract data from complex data structures in order to create well-formed files or strings. The basic FString - Any string is considered an FString. - Any parts of the string starting with ‘{$’ and…
The property file format
Advance Topics » Property System » The property file format
Any queriable node in the dbwatch server can have properties. These can be statically set values or dynamically created. This document describes the format used to define dynamic properties. The file header Oracle…
Setting up the default web dashboard
Best Practice for Data Operations » Dashboards and Overview Screens » Setting up the default web dashboard
The web dashboard is the standard monitoring dashboard. Firstly, you will be directed to the first tab which is Instance Status. The Instance Status tab shows an overview of statistics and issues during monitoring. Instances status displayed as visual…
Definition Mapping
Troubleshooting Guide » Definition Mapping
dbWatch 12 dbWatch Control Center Definition Changes Tasks and Alerts Jobs Tasks provide statistics and growth rates for your database, which allows for better planning and performance analysis of how your system is behaving.…
Modify Monitoring View
dbWatch monitoring and Reporting » Monitoring » Modify Monitoring View
On the right side in the Monitoring tab, there are two different views. An instance view and a task view. Wich one depends on the selection in the navigation tree on the left side. Both these views can be modified by right clicking on the header, and selecting…
Control Center Jobs (previously known as Tasks and Alerts)
dbWatch Control Center Navigation » Control Center Jobs (previously known as Tasks and Alerts)
Jobs(older dbWatch versions Tasks and alerts) are the cornerstone of the dbWatch Monitoring module. Jobs perform the actual monitoring of the database instance. There are two types of Monitoring in dbWatch. The Basic and Standard monitoring. Basic Monitoring Basic…
Integrating with Active Directory
Configuration » Integrating with Active Directory
Setting up Active Directory authentication By default dbWatch authenticates users using it’s own internal username/password database. This section describes how to add Active Directory as a second user authentication provider. Connect to the server with the…
Tree navigation
dbWatch Control Center Navigation » Tree navigation
On the left side of the dbWatch monitor, you will see a tree structure. There are 2 component that lets your group and filter instances. Top level of the tree, there is a “Grouping” panel. Below it is a quick text based filter. Grouping This is always…
Advance Topics
Advance Topics
For this section, we’ll be focusing on Farm Data Language and other topics you may find interesting. ← Special setup in NAT environments / FDL – Farm Data Language →
Dynamic properties
Advance Topics » Property System » Dynamic properties
Dynamic properties are defined in xml files located in the [dbWatch Server]/server/resources/properties/ catalog. You cannot add files to this catalogue manually, but import them by placing them in the [dbWatch Server]/server/resources/import_area catalog. Examples…
Configuration
Configuration
Server Configuration The Server Configuration can be accessed through the Server->Server Configuration->Server configuration menu. The configuration values control the following: session-timeout: How long (in seconds) a session (SQL Worksheet) can be inactive…
Edit Jobs
dbWatch Control Center Navigation » Edit Jobs
How to get here Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new To create a new Task or Alert from scratch, go to the Manage tasks and alerts…
SQL Worksheet
dbWatch Control Center Navigation » SQL Worksheet
One of the truly unique features of dbWatch is its integrated SQL Worksheet, which, although simple in operation has some sophisticated applications, including cross-database queries. The SQL Worksheet is not developed from a developer-centric perspective and therefore…
Startup configuration
Configuration » Startup configuration
There are two files that supply the startup configuration for dbWatch, both can be found in the root of the dbWatch installation catalog. monitor.conf Startup configuration for the dbWatch Monitor server.conf Startup configuration for the dbWatch…
Running several Monitors in parallel
Advance Topics » Running several Monitors in parallel
In order to run more than one dbWatch Monitor on a machine you have to tell them to use seperate paths for their files. Before making any changes to the files, make sure the the dbWatch Monitor is stopped. The dbWatch Monitor reads a file called monitor.conf on…
Architecture
Best Practice for Data Operations » Architecture
Architecture components The dbWatch installation consists of three components: dbWatch Monitor/Client serves as the front end GUI dbWatch Server is the core business logic and central hub of the system dbWatch Framework contains stored objects in the registered…
Importing resources
dbWatch Control Center Navigation » Importing resources
Much of the functionallity in dbWatch is defined in xml files, including report specifications, task specifictions and management specifications. That means that functionallity can be modified by supplying new xml files to dbWatch. There are two ways of doing…
FAQ
FAQ
In this section – you will find the frequently asked questions regarding the dbWatch. Do you offer an evaluation copy of your product? - Yes, we do offer a 30-day trial for a maximum of 25 database instances of any database platforms supported. We can also…
Installing on Multihomed Systems
Getting Started with Control Center » Installing on Multihomed Systems
Multihomed describes a computer host that has multiple IP addresses connected to networks. When the dbWatch Server runs on a multihomed computer, you have to specify which IP the Server should bind to. On windows Create/change the environment variable called…
Running several Servers in parallel
Advance Topics » Running several Servers in parallel
In order to run more than one dbWatch Server on a machine there are two things you need to do. Make them listen to different ports, and use seperate paths for their files. Before making any changes to the files, make sure the the dbWatch Server is stopped. Change…
Multiserver web dashboards
Best Practice for Data Operations » Dashboards and Overview Screens » Multiserver web dashboards
If you have multiple dbWatch Servers, it is possible to create a dashboard that merges the data from different dbWatch Servers in one view. This can be usefull for large scale dbWatch implementations, Service Providers or customers with database servers in different…
Issues and troubleshooting
Troubleshooting Guide » Issues and troubleshooting
High CPU usage on database Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application. For example, a SQL statement that has the highest value of spent CPU time. In most…
Special setup in NAT environments
Configuration » Special setup in NAT environments
dbWatch 11 and 12 uses JAVA RMI with SSL for network communication, and the JAVA RMI Registry functionality will create a problem when connecting from the monitor client to the server, when the IP address of the actual dbWatch server host is different from the IP…
Licensing terms
Licensing terms
dbWatch End User License Agreement 1. PARTIES This License and Services Agreement (“Agreement”) is between dbWatch AS, organization number 991 500 456 (“dbWatch”) and the Customer which is the entity or person whose name and contact details as it appears on…
Installing on Windows
Getting Started with Control Center » Installing on Windows
dbWatch Server Prerequisites Windows Server (VMWare virtual server supported) 8 GB RAM 4 CPU cores 1 GB HD Space (for dbWatch) dbWatch Engine Prerequisites 100 Mb free space in each database instance. Engine – Server communication determined by each…
Adding a SQL Express Instance
dbWatch Monitor Setup » Adding an SQLServer Instance » Adding a SQL Express Instance
How to get here There are two methods in opening the prompt. First Method: To add a SQLServer instance, click on the “Plus (+)” sign on the bottom left of the dbWatch dashboard. This will bring up the “Add Instance” wizard, which will…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center RC 2.0 RC 2.0 is an improvement from RC 1.0 in terms of UI stability and dbWatch server connection. New Features Can support up to 100 databases for now; will keep on expanding to accommodate more Bulk Instance Installation Supports up to…
Fault Finding Guide
Troubleshooting Guide » Fault Finding Guide
Errors before starting the installer The first step is to download the software. Once downloaded, errors may occur when the installer unpacks. The install executable or zip file might have been damaged during download, and if this is indicated, try first downloading…
File Structure
Best Practice for Data Operations » File Structure
Files stored in the users home directory The monitor stores most of it’s configurations in the .dbwatch/monitor/ in the users home directory. This directory contains the following files: monitor.xml Stores various settings and preferences for the…
Restore configuration backup
Troubleshooting Guide » Restore configuration backup
The configuration files in dbWatch are continously backed up using git. Reverting to an old backup Step one If you don’t have git tools installed, you can download them here Step two After stopping the dbWatch Server, use a command prompt (that understands…
Adding an SQLServer Instance
dbWatch Monitor Setup » Adding an SQLServer Instance
How to get here PROMPT SCREEN FOR ADDING INSTANCE There are two methods in opening the prompt. First Method: To add a SQLServer instance, click on the “Plus (+)” sign on the bottom left of the dbWatch dashboard. This will bring up the “Add…
Discovering Database Instances
dbWatch Monitor Setup » Discovering Database Instances
The dbWatch Autodiscover feature scans your network and locates database instances that are available. You will find the Autodiscover feature under the “Autodiscover” tab on the left-most side of the dbWatch Monitor. In the Autodiscover view you have 3…
Monitoring
dbWatch monitoring and Reporting » Monitoring
In this section, we’ll be discussing how to modify your dbWatch dashboard. ← dbWatch monitoring and Reporting / Modify Monitoring View →
Adding an Oracle Instance
dbWatch Monitor Setup » Adding an Oracle Instance
Oracle Prerequisites !1. Oracle databases need to have a listener process running and also allow for an external login with sysdba user or user with enough privileges. 2. You need a privileged user, such as sys as sysdba, another user with sysdba privileges or…
Operator Configuration
dbWatch Monitor Setup » Operator Configuration
Access to dbWatch is controlled through operators. Operators have a password and a set of privileges on dbWatch. How to get here The operator configuration view can be accessed by clicking on Server > Server Configuration > Manage Users and Roles on the main…
Instance Configuration
dbWatch Monitor Setup » Instance Configuration
How to get here Instance Configuration can be accessed by going to Server —> Server Configuration —-> Instance Configuration. Main view The instance configuration view consists of several parts. On the left side you see a tree are the list of your…
Troubleshooting Guide
Troubleshooting Guide
In this section, we’ll discuss about: dbWatch Backup Restoring Configuration Backup Fault Finding Guide Issues and Troubleshooting Definition Mapping ← Integration for Brent Ozar’s First Responder Kit / Backup of dbWatch…
Property System
Advance Topics » Property System
There are several types of properties in dbWatch. Predefined properties Predefined are always present. For example, instances have properties called name and host. Metadata properties Metadata properties are manually assigned to particular objects in dbWatch (like…
Edit Management
dbWatch Control Center Navigation » Edit Management
Currently there is no graphical interface for editing the managment interface. However, everything is defined in xml files that can be edited directly. Documentation of the syntax is not complete, and you have to rely on the existing code for examples. The following…
Logging
Configuration » Logging
Default setup [Users home]/monitor.log: The monitor will log events to this log. [install dir]/server.log : The server will log events to this log file. Eventlog: On windows systems the server will log login events, failed login events and disconnects to the…
Monitor dashboards and overview screens
Best Practice for Data Operations » Monitor dashboards and overview screens
Being effective in database operations are one of the key focus areas for the dbWatch database operations team. This chapter will focus on the dashboards or overview screens used by our internal database operations team, what information they show, how they are used…
Adding a MySQL Instance
dbWatch Monitor Setup » Adding a MySQL Instance
How to get here To add a MySQL instance, click on the “Add” icon on the main toolbar. This will bring up the “Add Database Instance” wizard, which will guide you through the following steps. Select Installation Type The first step of the…
Bulk installing instances
dbWatch Monitor Setup » Bulk installing instances
Instances can be added in bulk by importing a csv file through the ‘Server’->‘Upload resource’ menu. The CSV file should have the following…
Credential Storage Policy
Configuration » Credential Storage Policy
You can specify the amount of information about logins that the dbWatch Monitor is allowed to store, by adjusting the Server Configuration Setting called monitor-credential-storage-policy. The legal settings are: ALLOW_ALL The Monitor can store the username and…
Defining Autodiscover Ports
dbWatch Monitor Setup » Discovering Database Instances » Defining Autodiscover Ports
By default autodiscover scans the following ports: MS SQL Server: 1433 Oracle: 1520, 1521, 1522, 1523, 1524, 1526, 1527 Sybase: 4998, 4999, 5000, 5001, 5002 MySQL: 3304, 3305, 3306, 3307, 3308 PostgreSQL: 5429, 5430, 5431, 5432, 5433, 5434 You can override the…
Item active
Advance Topics » Item active
You can hide or disable elements (typically nodes or menu items) by using the item-active tag You can specify multiple item-active tags, and all of them have to resolve to “active” in order for the element to be classified as active. The item-active tag…
Notes
dbWatch Control Center Navigation » Notes
dbWatch allows you to attach notes to tasks, instances and servers. You can access the notes dialog by right clicking on a instance/task/server, and selecting “Notes” on the menu. The notes dialog has two tabs, one for public notes (visible to all…
Category line chart
dbWatch Control Center Navigation » Edit Management » Result types » Graphical » Category line chart
A category line chart example The specification for this chart SELECT rtrim(ltrim(instance_name)) "Type", cntr_value "Value" FROM sys.dm_os_performance_counters where counter_name like 'Lock Requests/sec%' and instance_name in ( select top 6…
Formatting table results
dbWatch Control Center Navigation » Edit Management » Formatting table results
When you are displaying a table result based on an SQL query, you have the same render hints that are offered as part of dbwql. To use these hints, add a “result-table-format” tag to the result. select a, b, c from sometable TABLE …
Stacked area chart
dbWatch Control Center Navigation » Edit Management » Result types » Graphical » Stacked area chart
Here is an example of a stacked area chart showing the relationship between active and inactive sessions over time. The specification for this chart: select number_of_processes_active as "Active", number_of_processes_total - number_of_processes_active as…
Integration for Brent Ozar’s First Responder Kit
Advance Topics » Integration for Brent Ozar’s First Responder Kit
In this page you will learn how Control Center integrates Brent Ozar’s First Responder Kit solution, to fine-tune problems within your SQLServer databases. Note: For you to be able to integrate Brent Ozar First Responder Kit, you must have a separate license for…
Groups Configuration
dbWatch Monitor Setup » Groups Configuration
How to get here You can access the group configurations going to Server —> Server Configuration —> Group Configuration. Overview The Group Configuration view consists of two main parts. On the left side you can see a tree structure showing the groups,…
Service groups
dbWatch Control Center Navigation » Service groups
In dbWatch you can organize instances in servicegroups Instances placed in the same servicegroup should provide a common service of some sort. For example this can be instances belonging to the same cluster. Servicegroups may also be placed inside other…
Javascript property
Advance Topics » Javascript property
From dbWatch 12.2.1, one of the engines available in properties is javascript. Example that sums each column from an sql result: scripttest instance[databasetype='sqlserver'] select 1, 2, 3 5s In the javascript code there are…
For SQLServer
dbWatch Control Center Navigation » Control Center Jobs (previously known as Tasks and Alerts) » For SQLServer
Tasks and Alerts Description SQLServer Database alwayson backup Analyzes the backup statistics (type D and I) from the msdb.dbo.backupset table (excluding the system databases: master, model and msdb). Database alwayson…
Database operations philosophy
Best Practice for Data Operations » Database operations philosophy
The reasons for database operations The value of database operations comes from the value of the systems the databases supports. . In a typical operation the value of the managed systems is much greater than the resources used on the operations side. Running a…
Generate Reports
dbWatch monitoring and Reporting » Reporting » Generate Reports
When you click on Report Module, the report wizard will be started. In the first step you will be asked to select the database instance you wish to generate a report for. The instance that does not have a user/login set for generating the report content, will be shown…
JDBC Properties
dbWatch Monitor Setup » Instance Configuration » JDBC Properties
It is possible to set properties for the JDBC driver on specific instances. You can find this under “Advanced Driver Setup” when adding SQL instances or under “Edit parameters” in the JDBC panel in the Configure Instance dialog. The driver…
Graphical
dbWatch Control Center Navigation » Edit Management » Result types » Graphical
The graphical type When specifying the graphical type there must also be a graphical tag inside the result. select ... graphical ... This graphical tag then again contains the various chart specifications. The currently supported charts…
groupby function
Advance Topics » FDL – Farm Data Language » Functions » groupby function
Description Groups a set on some value(s). Used in combination with aggregate function(s). Example Group the instances by database type, and count the number of instances in each…
Result types
dbWatch Control Center Navigation » Edit Management » Result types
You can specift the result type with a “result-type” tag inside the result. select ... table The currently available result types are table / dbwqltable Will display the result as a table. This is the default type. code Will display the…
orderby function
Advance Topics » FDL – Farm Data Language » Functions » orderby function
Description Orders the rows in a set, with an optional limit on the number of rows to return Example Find the 10 instances with the highest number of sessions instance->i{}/total_session_count/orderby('desc', 10) Order the instances based on…
abs function
Advance Topics » FDL – Farm Data Language » Functions » abs function
Description Returns the absolute value of a number Example Find the absolute value for -3 abs(-3) Syntax abs(number) Parameters Type Description Number The number to find the absolute value for
union function
Advance Topics » FDL – Farm Data Language » Functions » union function
The union function finds the union of two sets Description The union function finds the union of two sets Example Find the disk space task from all test instances and disk capacity task from all production instances, and their version union( instance[name like…
Reporting
dbWatch monitoring and Reporting » Reporting
Control Center comes bundled with a series of report templates that you can use to generate standard reports on various aspects of your database environment. It also allows you to edit the templates or create your own for fully customizable reporting which will be…
until function
Advance Topics » FDL – Farm Data Language » Functions » until function
Description Return all numbers from a base number until an end number Example Return the numbers in the range 1 to 5. 1/until(5) Syntax until(number) Parameters Type Description Number The endpoint for the range…
avg function
Advance Topics » FDL – Farm Data Language » Functions » avg function
Description Calculates the average of a set of numbers Example Find the average number of sessions for all your oracle instances avg(instance[databasetype = 'oracle']/total_session_count) avg(instance[databasetype = 'oracle']/total_session_count,…
For Oracle
dbWatch Control Center Navigation » Control Center Jobs (previously known as Tasks and Alerts) » For Oracle
Tasks and Alerts Description Oracle Alert log check This check reads and looks for errors in the database alert log. Uses embedded java to read files. Alert log check 11g This check reads and looks for errors in…
intersect function
Advance Topics » FDL – Farm Data Language » Functions » intersect function
The intersect function finds the values that are in both set A and set B Description Finds the intersection of two sets Example Find tasks from the ‘sla_higs_tasks’ list that are installed on instances tagged with sla=low intersect( …
Functions
Advance Topics » FDL – Farm Data Language » Functions
Functions in dbwql Numeric functions Function name Description add Adds a number to a base value sub Substracts a number from a base value div Diveds a number mult Multiplies a number…
sub function
Advance Topics » FDL – Farm Data Language » Functions » sub function
Description Substracts a number from a base value. Example Find the port number below the current port number for an instance instance[name = 'A']/port/sub(1) Syntax sub(number) Parameters Type Description Number The number…
min function
Advance Topics » FDL – Farm Data Language » Functions » min function
Description Finds the minvalue from a set, or from a number of values. Example Find the minnumber of sessions for all your oracle instances min(instance[databasetype = 'oracle']/total_session_count) Returns the smallest of the arguments (average…
add function
Advance Topics » FDL – Farm Data Language » Functions » add function
Description Adds a number to a base value. Example Find the port number above the current port number for an instance instance[name = 'A']/port/add(1) Syntax add(number) Parameters Type Description Number The number to add…
max function
Advance Topics » FDL – Farm Data Language » Functions » max function
Description Finds the max value from a set, or from a number of values. Example Find the max number of sessions for all your oracle instances max(instance[databasetype = 'oracle']/total_session_count) Returns the largest of the arguments (average…
round function
Advance Topics » FDL – Farm Data Language » Functions » round function
The round function rounds a number to a specified precision Description Rounds a number Example Find tasks from the ‘sla_higs_tasks’ list that are installed on instances tagged with sla=low instance/disk_space/round(2) round(instance/disk_space,…
Line chart
dbWatch Control Center Navigation » Edit Management » Result types » Graphical » Line chart
A line chart example The specification for this chart: select (SELECT cntr_value FROM sys.dm_os_performance_counters where counter_name = 'Index Searches/sec') as "Index Scans", (SELECT cntr_value FROM sys.dm_os_performance_counters where…
sum function
Advance Topics » FDL – Farm Data Language » Functions » sum function
Description Sums the numbers in a set Example Find the total number of sessions for all your oracle instances sum(instance[databasetype = 'oracle']/total_session_count) Syntax sum(expression) Parameters Type Description Expresssion…
count function
Advance Topics » FDL – Farm Data Language » Functions » count function
Description Counts the number of rows in a set Example Find the number of instances with status warning. count(instance[status='WARNING']) Syntax count(expression) Parameters Type Description Expression An expression that…
mkstring function
Advance Topics » FDL – Farm Data Language » Functions » mkstring function
The mkstring function makes a string from a set of values Description Creates a string from a set of values Example Make a comma separated string of all instance names mkstring(instance/displayname, ", ") Syntax mkstring(expression) mkstring(expression,…
distinct function
Advance Topics » FDL – Farm Data Language » Functions » distinct function
Description Removes duplicates from a set of values Example Get the set of versions for all instances distinct(instance/version) instance/distinct(version)
Getting Started with Control Center
Getting Started with Control Center
Proceed to the next page to install Control Center in Windows. ← Multiserver web dashboards / Installing on Windows →
concat function
Advance Topics » FDL – Farm Data Language » Functions » concat function
Description Concats a number of strings Example Get all hosts and append the domain “.dbwatch.com” instance/concat(host, '.dbwatch.com') Syntax concat(string1, string2, …)
Best Practice for Data Operations
Best Practice for Data Operations
In this Chapter we will be looking at the following: Architecture File Structure Database Operations Philosophy Monitor Dashboards and Overview Screens Dashboards and Overview Screens ← Release notes / Architecture →
Dashboards and Overview Screens
Best Practice for Data Operations » Dashboards and Overview Screens
In this section, we will be focusing on how to set-up your dashboard and setting it up with multiple servers. ← Monitor dashboards and overview screens / Setting up the default web dashboard →
div function
Advance Topics » FDL – Farm Data Language » Functions » div function
Description Diveds a number Example Divide the number of instances by 7 count(instance)/div(7) div(count(instance), 7) Syntax expression1/div(expression2) div(expression1, expression2) Parameters Type Description Expression1 …
mult function
Advance Topics » FDL – Farm Data Language » Functions » mult function
Description Multiples a number Example Multiply the number of instances by 2 count(instance)/mult(2) mult(count(instance), 2) Syntax expression1/mult(expression2) mult(expression1, expression2) Parameters Type Description Expression1 …
trim function
Advance Topics » FDL – Farm Data Language » Functions » trim function
Description Strips empty spaces from the beginning and end of a string Example Get all hosts without leading or trailing spaces instance/host/trim() instance/trim(host) Syntax trim(expression) value/trim() Parameters Type Description …
Pie chart
dbWatch Control Center Navigation » Edit Management » Result types » Graphical » Pie chart
Pie chart example The specification for this chart select top 10 'type' = replace(A.type, 'MEMOBJ_', ''), 'value' = A.value from ( SELECT type, SUM (cast((pages_in_bytes/1024) as int) )/1024 as "value" from…
Category chart
dbWatch Control Center Navigation » Edit Management » Result types » Graphical » Category chart
A catagory chart example The specification for this chart GRAPHICAL SELECT top 10 case when len(DB.name) > 30 then substring(DB.name,1,30)+'_DBID_' +cast(DB.database_id as varchar(4)) +' (alias)' else DB.name end AS "Database…