Note: Documentation for Pivotal SQLFire 1.1.x is now available at Please reference the site for the latest and most up-to-date documentation on SQLFire. The vFabric SQLFire documentation site will no longer be updated.

vFabric SQLFire MBeans

SQLFire uses MBeans associated with the vFabric Gemfire component to monitor the distributed system and its contents. The JMX MBeans are ModelMBeans that manage instances of the Admin API objects housed in the JMX Agent’s MBeanServer. The JMX Agent hosts an MBeanServer, instances of all MBeans registered for managing a distributed system, and server connectors for various types of clients.

This table shows the Gemfire JMX MBeans that are of interest when monitoring a SQLFire system, highlighting each MBean’s key attributes and operations.

ObjectName(s) Description
GemFire:type=Agent Represents the configuration of a SQLFire JMX Agent member. Agent attributes include the name of the Agent properties and log files (propertyFile and logFile attributes), limits for log file size and disk usage, locators, bind address information, and SSL information. For details, see Basic JMX Agent Properties and Distributed System Properties for JMX Agent. Agent operations include adding and removing SSL vendor properties, managing the log file, saving configuration settings to the properties file, and connecting to the distributed system.

After the GemFireAgent MBean connects to a distributed system, you can still invoke the operation connectToSystem to return the ObjectName for the AdminDistributedSystem MBean.

GemFire:type=AdminDistributedSystem Represents the SQLFire distributed system, which is defined by three attributes: mcastAddress, mcastPort, and locators. AdminDistributedSystem operations include starting and stopping locators, creating DistributionLocator MBeans, managing locators and applications, monitoring SQLFire health, and displaying merged logs, licensing information, and system alerts.

The AdminDistributedSystem MBean provides several predefined JMX Notifications that you can use to monitor your distributed system. In addition to these Notifications, you can use the JMX Monitor Service to monitor any attribute of any MBean.

GemFire:type=DistributionLocator Represents a locator within a distributed system. Each locator is identified by its host, port, and bind address attributes. DistributionLocator operations include starting, stopping, and removing locators, as well as retrieving locator log files.
GemFire.CacheVM:type=CacheVM Represents a SQLFire server or locator in the SQLFire distributed system.
GemFire.Member:type=Application Represents a peer client in the SQLFire distributed system.


Provides statistics for query and DML operations on SQLFire tables.
GemFire.Statistic:type=ConnectionStats,name=EmbeddedConnectionStats Provides statistics about embedded connections in the distributed system.
GemFire.Statistic:type=DiskDirStatistics,name=disk_store Shows the number of bytes currently used by the disk store, as well as the maximum size of the disk store and other configuration attributes.
GemFire.Statistic:type=DiskRegionStatistics Shows the per-table breakdown of disk store statistics.
GemFire.Statistic:type=DiskStoreStatistics,name=disk_store Shows the number of compactions, reads and read bytes (for tables configured with eviction), writes, recovery stastics, and queue sizes for a disk store.
GemFire.Statistic:type=DistributionStats,name=distributionStats Shows the current number of nodes in the distributed system (nodes attribute). The receivedBytes and sentBytes attributes provide a measure of network traffic to the distributed system.
GemFire.Statistic:type=ResourceManagerStats,name=ResourceManagerStats Use these statistics when tables are configured for eviction. Attributes such as evictionStartEvents and evictionStopEvents indicate the number of times eviction actions are performed (evictionThreshold also shows the configured threshold for eviction). Attributes such as heapCriticalEvents, and heapSafeEvents show how heap size contributed to table eviction events.

Provides statistics about statement execution. This is created by invoking the manageStats operation of the GemFire.CacheVM or GemFire.Member MBeans, if statement statistics capture is enabled. See Evaluating Query Plans and Query Statistics.



Use the collections and collectionTime attributes to measure JVM garbage collection performance. If you monitor these attributes, also enable GC logging at the JVM level to record additional information.
GemFire.Statistic:type=VMMemoryPoolStats,name=CMS Old Gen-Heap memory

GemFire.Statistic:type=VMMemoryPoolStats,name=Par Eden Space-Heap memory

GemFire.Statistic:type=VMMemoryPoolStats,name=Par Survivor Space-Heap memory

Monitor the currentUsedMemory and currentMaxMemory attributes to measure the memory used in these pools.
GemFire.Statistic:type=VMMemoryUsageStats,name=vmHeapMemoryStats Monitor the usedMemory and maxMemory attributes to measure the memory used in this area.