Aqua Data Studio offers a suite of SingleStore (MemSQL) DBA Tools for the monitoring, maintaining and tuning of the SingleStore (MemSQL) server. It includes an Instance Manager, Storage Manager, Security Manager, and Session Manager. These managers allow the monitoring and maintenance of Tablespaces, Database Objects, Sessions, Users and Permissions via GUI.
![Aqua Data Studio 23.1 > SingleStore MemSQL DBA Tools > SingleStore DBA Tools menu.png](/download/attachments/12710826397/SingleStore%20DBA%20Tools%20menu.png?version=1&modificationDate=1689023728943&api=v2)
![Aqua Data Studio 23.1 > SingleStore MemSQL DBA Tools > SingleStore DBA Tools.png](/download/attachments/12710826397/SingleStore%20DBA%20Tools.png?version=1&modificationDate=1689023728561&api=v2)
Aqua Data Studio SingleStore (MemSQL) Administration Tools
SingleStore (MemSQL) Instance Manager
Provides GUI view and search access for:
- Instance Summary (Server Component, Value, Group, Description, Extra Info, Context, Type, Source)
- Character Sets Parameters
- Collation
SingleStore (MemSQL) Session Manager
Provides GUI view and search access for:
- Session Details, Kill Session
- Session Statistics
- Session Locks
- Session Grouping (By Process ID, Auth ID, and more)
SingleStore (MemSQL) Storage Manager
Provides GUI view and search access for:
- Tree View for Tablespaces, Databases, Device Usage, Location
- Tablespace Properties and Details
- Properties of Databases, Device Usage, Default Tablespace, Location
- Table, Index Storage View
SingleStore (MemSQL) Security Manager
Provides GUI view and search access for:
- Tree View for Users, Groups
- Users View, Create, Alter, Drop
- Groups View, Create, Alter, Drop