NaviSite Interview Questions, Process, and Tips

Answering questions related to PostgreSQL performance parameters, vacuum strategies, MVCC, and master-slave configuration.

• Performance parameters in PostgreSQL include shared_buffers, work_mem, and effective_cache_size.

• Vacuum strategies include manual vacuuming, auto vacuuming, and vacuum freeze.

• MVCC (Multi-Version Concurrency Control) allows multiple transactions to access the same data simultaneously.

• Master-slave conf...read more

Zabbix proxy server is a component that collects data from monitored devices and sends it to the Zabbix server.

• Zabbix proxy server reduces network traffic by collecting data from remote locations and sending it to the Zabbix server.

• It can also cache data to ensure that the Zabbix server receives the most recent data.

• Zabbix proxy server can be used to monitor devices in remote locations with limited bandwidth.

• It can als...read more

To monitor Ms sql on zabbix, you need to install Zabbix agent on the server and configure it to collect data from the SQL server.

• Install Zabbix agent on the server hosting the SQL server

• Configure the Zabbix agent to collect data from the SQL server

• Create items in Zabbix to monitor SQL server performance metrics such as CPU usage, memory usage, disk usage, and query performance

• Set up triggers in Zabbix to alert you when...read more

Macros in Zabbix are used to dynamically replace values in item keys, trigger expressions, and other places.

• Macros are denoted by curly braces {}

• They can be used to replace static values with dynamic ones

• Examples include {HOST.NAME}, {ITEM.VALUE}, and {TRIGGER.VALUE}

• Macros can also be defined at the host or global level

Active agents initiate actions while passive agents respond to actions.

• Active agents are proactive while passive agents are reactive.

• Active agents initiate change while passive agents undergo change.

• Examples of active agents include enzymes, hormones, and neurotransmitters while examples of passive agents include water, air, and salt.

• Active agents are often associated with living organisms while passive agents are asso