# xSQL Server Instrumentation

> xSQL is a highly configurable database server. To start xSQL as a server it is simply necessary to specify a port number for remote clients to connect to. For example, the following command (run in directory `samples\xsql\scripts`) starts xSQL as a server for an in-memory database of `100Mb`, listening on port `5000` and using configuration file `xsql.cfg`:

>         ..\..\..\target\bin\xsql.exe -size 100m -p 5000 -c xsql.cfg

> There are a number of command line options and alternatively a configuration file can be used to specify a rich variety of xSQL startup and runtime parameters.

> Please use the links in the following table to view the specified server instrumentation capabilities:

> Storage | Examine database storage usage
> Security | Security Parameters
> Logging | Logging runtime statistics and session activity
> AIO | Asynchronous file I/O for Persistent Databases
> Automatic Restart | Automatic restart of the xSQL server after it has been terminated abruptly
> Recover | Recovering shared memory databases
> xtop | Using the Unix-Linux `xtop` utility to display xSQL runtime statistics