Tesco cuts backup times by two thirds

Grocery retailer manages to shave SQL Server backup times by over 60 per cent with LiteSpeed compression tool.

Tesco has managed to cut down backup times of its online shopping databases by two-thirds. The supermarket giant did so by deploying database compression software from Quest Software.

The information required for the Tesco.com site to operate is held in a cluster of SQL Server databases. This includes information about all of the available products, billing and delivery information for the customers as well as any 'favourites' that they have saved. The company needed to cut down on the amount of time backing up these data as it was taking nearly five hours to complete and if any problems occurred with this backup, there was only just enough time in the company's eight hour back up window to re-run this.

The company turned to Quest Software and used its LiteSpeed for SQL Server product to shorten backup times. The supermarket implemented this on six of its SQL Servers and saw some "significant results".

"For instance, our 120GB SQL Server previously took 59 minutes to backup, and with LiteSpeed now takes 18 minutes," said Chris Howell, IT Manager of Operations and Infrastructure of Tesco.com. "This improvement means that we have ample time to deal with any backup problems, to ensure Tesco.com is always open."

He said that the risk of losing customers through backup hiccups had now been removed.

The online supermarket has also achieved storage capacity savings of around 62 percent through its use of the software.

"The 120GB SQL Server previously generated a 73GB native backup," noted Howell. "The backup has fallen to 28GB, and our other databases are experiencing similar reductions."

Tesco is now in the process of rolling out the software to 300 of its larger stores from where home deliveries dispatched and use SQL Server to process online orders.

Featured Resources

The challenge of securing the remote working employee

The IT Pro Guide to Sase and successful digital transformation

Free Download

VMware Cloud workload migration tools

Cloud migration types, phases, and strategies

Free download

Practices for maximising the business value of digital infrastructure Consumption-as- a-Service subscriptions

IDC PeerScape

Free Download

Container network security guide for dummies

Enforcing Kubernetes best practices

Free download

Most Popular

How to move Microsoft's Windows 11 from a hard drive to an SSD
Microsoft Windows

How to move Microsoft's Windows 11 from a hard drive to an SSD

4 Jan 2022
Microsoft Exchange servers break thanks to 'Y2K22' bug
email delivery

Microsoft Exchange servers break thanks to 'Y2K22' bug

4 Jan 2022
Solving cyber security's diversity problem
Careers & training

Solving cyber security's diversity problem

5 Jan 2022