Kleyn Trucks is one of the world’s largest independent dealers in used commercial vehicles. It operates in a sector where speed and reliability are crucial. With a large volume of transactions and a constant flow of vehicle data, a stable and optimised database infrastructure is essential.
Since April 2021, Kleyn Trucks has been working with SQLBrander.nl to optimise its SQL Server and database management. This collaboration has led to more efficient operation of IT systems and a significant improvement in performance.
The challenge: an efficient and high-performing SQL Server
The IT department at Kleyn Trucks, led by IT manager Devin Minnaard, faced the challenge of managing a rapidly growing database environment. The servers needed to be continuously monitored and optimised to minimise system delays. Without in-depth in-house expertise in this area, there was a high risk of inefficient indexing and delays.
“We noticed that our database wasn’t always performing optimally. Retrieving vehicle data could sometimes take 10 to 12 seconds. This wasn’t ideal for our staff, who rely on fast and accurate data.”
The solution: SQLBrander.nl takes over management
Thanks to the partnership with SQLBrander.nl, Kleyn Trucks was able to focus entirely on its core business, whilst the SQL servers were expertly managed. SQLBrander.nl, with database administrator Donne van Spankeren as one of the key figures, delivered a significant improvement in database performance. This meant:
- Continuous monitoring: Preventing downtime
and intervening quickly in the event of anomalies. - Index optimisation: Reducing
unnecessary waiting times when retrieving
vehicle data. - Updates and maintenance: Ensuring a stable
and up-to-date database environment.
“Since SQLBrander.nl took over management, we have seen huge performance improvements. Searches that used to take 10 seconds are now completed in just 4 seconds. That may seem small, but when you do this 200 times a day, it saves a huge amount of time,” says Devin Minnaard.
High-availability solution for Kleyn Trucks?
In 2022, Kleyn Trucks faced a new challenge: the implementation of an additional SQL server to support a new Carwise installation. This database was required for Kleyn’s leasing activities, and the implementation had to be carried out quickly and without a hitch. “We had little time to get this server up and running, but SQLBrander.nl ensured that everything was operational within a short time. Other providers sometimes make you
wait for weeks, but here it was sorted in no time,” notes Devin Minnaard.
In addition, further optimisation and security measures were discussed. SQLBrander.nl proposed implementing a high-availability solution, whereby a secondary server acts as a backup in the event of failures. This proposal is currently being discussed internally at Kleyn.
“With SQLBrander.nl, we’ve struck the perfect balance
between cost savings and top-quality management.”
– Devin Minnaard, Kleyn Trucks
Why Kleyn Trucks chose SQLBrander.nl
For Kleyn Trucks, outsourcing database management was a strategic decision. The expertise and speed of SQLBrander.nl proved indispensable, and the partnership is viewed very positively.
The partnership delivers:
- Time savings: The IT department can focus on
strategic tasks rather than routine maintenance. - Reliability: No worries about slowness or
unforeseen downtime. - Scalability: The ability to quickly implement new
servers and solutions.
“We don’t have the in-depth SQL knowledge that SQLBrander.nl possesses, and bringing this expertise in-house would be far too costly. With SQLBrander.nl, we have the perfect balance between cost savings and top-quality management,” explains Minnaard.
Future collaboration between Kleyn Trucks and SQLBrander.nl
The collaboration between Kleyn Trucks and SQLBrander.nl continues to develop. With the potential expansion to a high-availability database environment and further optimisations, both parties remain committed to achieving maximum efficiency and reliability.
“SQLBrander.nl has proven to be an indispensable partner for our IT infrastructure. Their expertise and rapid support make all the difference to us. We look forward to the next steps in this partnership,” concludes Minnaard.
About SQLBrander
SQLBrander.nl specialises in SQL Server management and database optimisation. Drawing on our expertise, we help companies such as Kleyn Trucks to
improve their database performance and ensure maximum uptime and efficiency.
