by Thomas Maul
As the number of users and data size grow, disk speed is becoming increasingly important, as it is the main performance bottleneck for database systems. In virtualized environments, for example, a poorly configured storage system could slow down a database server drastically. In many cases, it’s difficult or even impossible to convince the storage system administrator that their system is not up to speed.
This session will give you the tools you need to benchmark and verify disk access requirements, and hopefully convince the IT department to upgrade their hard drives or SSDs! To increase acceptance from enterprise IT departments, this session will focus on a (free) tool from Microsoft – SQLIO – which is used to test storage systems on MS SQL Server and MS Exchange. We’ll explain how to use SQLIO and analyze the reports it produces, allowing IT admins to verify and optimize the storage system using Microsoft tools and Microsoft best practice documents.
Furthermore, we’ll provide a 4D component to make usage even easier with a graphical interface that creates human readable reports, including charts. This component can be integrated into your system, letting you run benchmarks regularly, i.e. on weekends, or run separately. It also helps prepare DOS batch files to run on customer machines that often only have Microsoft tools installed.
by Thomas Maul
Large IT departments use monitoring software such as Nagios or Icinga to monitor IT infrastructure and alert administrators about issues. There are automated alerts (email/SMS/pager) for server breakdowns, switch/router disconnection, printer ink or database server problems. But how can we integrate these with 4D?
This session will give you the basic background you need to install and use such a system – and integrate 4D Server to monitor their status, including availability, backup and memory.
For the IT administrator, this can be fully integrated into existing systems, allowing enterprise IT departments to monitor your application without learning new tools or techniques. 4D Server’s status can be embedded into administrators’ normal monitoring screen (and further made available in the browser, iPhone, Android, etc.), and the system can furthermore display historical data, such as 4D Server’s cache usage. If you have any large deployments, you cannot miss this session!
27th November 2012