An e-commerce solutions provider
Predicting and preventing issues across a large and busy estate
An effortless way to manage SQL Server estate health and identify performance improvements
Improved problem diagnosis, resolution, and organizational planning
Monsoon Commerce is an e-commerce solutions company whose products help media sellers, marketplace merchants, and multi-channel merchants to power their businesses online.
Used by thousands of merchants to reach customers across more than 30 marketplaces, including Amazon, eBay, and Buy.com. Monsoon Commerce products help merchants to manage inventory, create and automate pricing strategies, manage customer communication, and simplify order fulfillment.
Monsoon Commerce also runs Alibris.com, a huge marketplace for new and used books, movies, and music with over 150 million items in the inventory at all times.
150mitems25daily database changes3DBAs
Managing Alibris.com’s data is no small matter – 10 to 15 percent of its 150 million item inventory changes each day which results in millions of updates to the inventory systems.
Monsoon Commerce is dealing with a gigantic volume of data stored in multi-terabyte databases. With so many users, system performance is critical. The Database Manager leads a team of two other DBAs who are responsible for keeping Alibris.com up and running, ensuring the content is current despite the huge volume of changes pushed to and from the service.
He wanted to proactively manage his servers. When he joined Monsoon Commerce, the company was running a highly customized Nagios installation, looking at thousands of different counters including job status, index health, and disk size; however, these alerts only enabled the team to react to issues rather than taking steps to prevent such problems occurring.
In previous roles, the Database Manager has gone so far as to build his own dashboards and reports using SQL Server Reporting. None of these monitoring solutions produced the results he was looking for to predict and prevent SQL Server issues.
“It's very powerful in terms of data returned, especially once you compare this to the cost”
Redgate Monitor appealed primarily because it was the most easy to install and maintain solution. The Database Manager describes it as the easiest installation of a third party tool he has ever implemented.
“It is very powerful in terms of the data returned, especially once you compare this to the cost and the minimal time allocated for the tool’s maintenance.”
When he tried Redgate Monitor, he found it effortless to get an overall picture of server health, identify poorly performing queries, and conduct research in order to better manage his environment.
Redgate Monitor’s ‘Back-in-Time’ feature makes it easy to solve the team’s biggest challenge, the eternal “hey, at 10am the database went dead slow” problem. ‘Back-in-Time’ makes it quick and easy to rewind the clock and look at the situation leading up to and during a past event, removing a lot of DBA pain. Long running and expensive queries that cause problems on the system used to take a long time to check.
“We can use the tool to help with capacity planning and to work across the whole organization.”
With Redgate Monitor the team can now expose these issues very quickly and no longer has to spend his time looking for the source of these problems.
Redgate Monitor has been invaluable for accurate capacity planning, allowing the DBA team to look at SAN performance, disk performance, and I/O to see how best to grow Monsoon Commerce’s infrastructure as the company grows and the current servers come under more pressure.
The data is presented in a clear format, allowing them to easily share information about queries with the development team and show them where code improvements can be made.
“Redgate Monitor also allows me to easily present information to the database operations team, as well as the engineering group. This means we can use the tool to help with capacity planning and to work across the whole organization to make proactive changes to the system.”
Currently they use Redgate Monitor on 20 SQL Servers in the production environment. This includes active-passive clusters that are in place to ensure high availability.
The company has an equal number of test and development servers, and plans to roll out Redgate Monitor across the development and staging environments in the future. The engineering team is eager to do this as they have seen the value gained by the production environment monitoring.
whitepaper
In this guide, we take you through the ways a robust SQL Server monitoring solution has a positive impact across your organization, from the development teams to IT management, and from finance to the C-suite.
ROI guide
See how much you and your company could save by monitoring your servers with SQL Monitor – it only takes a few minutes.
Find out how Monsoon Commerce use Redgate Monitor to track the databases that power alibris.com, an online marketplace of more than 150 million items.
An e-commerce solutions provider
Predicting and preventing issues across a large and busy estate
An effortless way to manage SQL Server estate health and identify performance improvements
Improved problem diagnosis, resolution, and organizational planning
Monsoon Commerce is an e-commerce solutions company whose products help media sellers, marketplace merchants, and multi-channel merchants to power their businesses online.
Used by thousands of merchants to reach customers across more than 30 marketplaces, including Amazon, eBay, and Buy.com. Monsoon Commerce products help merchants to manage inventory, create and automate pricing strategies, manage customer communication, and simplify order fulfillment.
Monsoon Commerce also runs Alibris.com, a huge marketplace for new and used books, movies, and music with over 150 million items in the inventory at all times.
“It's very powerful in terms of data returned, especially once you compare this to the cost”
Managing Alibris.com’s data is no small matter – 10 to 15 percent of its 150 million item inventory changes each day which results in millions of updates to the inventory systems.
Monsoon Commerce is dealing with a gigantic volume of data stored in multi-terabyte databases. With so many users, system performance is critical. The Database Manager leads a team of two other DBAs who are responsible for keeping Alibris.com up and running, ensuring the content is current despite the huge volume of changes pushed to and from the service.
He wanted to proactively manage his servers. When he joined Monsoon Commerce, the company was running a highly customized Nagios installation, looking at thousands of different counters including job status, index health, and disk size; however, these alerts only enabled the team to react to issues rather than taking steps to prevent such problems occurring.
In previous roles, the Database Manager has gone so far as to build his own dashboards and reports using SQL Server Reporting. None of these monitoring solutions produced the results he was looking for to predict and prevent SQL Server issues.
“We can use the tool to help with capacity planning and to work across the whole organization.”
Redgate Monitor appealed primarily because it was the most easy to install and maintain solution. The Database Manager describes it as the easiest installation of a third party tool he has ever implemented.
“It is very powerful in terms of the data returned, especially once you compare this to the cost and the minimal time allocated for the tool’s maintenance.”
When he tried Redgate Monitor, he found it effortless to get an overall picture of server health, identify poorly performing queries, and conduct research in order to better manage his environment.
Redgate Monitor’s ‘Back-in-Time’ feature makes it easy to solve the team’s biggest challenge, the eternal “hey, at 10am the database went dead slow” problem. ‘Back-in-Time’ makes it quick and easy to rewind the clock and look at the situation leading up to and during a past event, removing a lot of DBA pain. Long running and expensive queries that cause problems on the system used to take a long time to check.
With Redgate Monitor the team can now expose these issues very quickly and no longer has to spend his time looking for the source of these problems.
Redgate Monitor has been invaluable for accurate capacity planning, allowing the DBA team to look at SAN performance, disk performance, and I/O to see how best to grow Monsoon Commerce’s infrastructure as the company grows and the current servers come under more pressure.
The data is presented in a clear format, allowing them to easily share information about queries with the development team and show them where code improvements can be made.
“Redgate Monitor also allows me to easily present information to the database operations team, as well as the engineering group. This means we can use the tool to help with capacity planning and to work across the whole organization to make proactive changes to the system.”
Currently they use Redgate Monitor on 20 SQL Servers in the production environment. This includes active-passive clusters that are in place to ensure high availability.
The company has an equal number of test and development servers, and plans to roll out Redgate Monitor across the development and staging environments in the future. The engineering team is eager to do this as they have seen the value gained by the production environment monitoring.
