Case Study: SQL Diagnostic Manager for SQL Server plus SQL Doctor

IDERA Helps LC Waikiki Optimize Its SQL Server Databases


Worldwide textile and ready-made clothing company LC Waikiki was founded in France in 1985 and then acquired by Taha Group, a Turkish manufacturing company, in 1997. Today LC Waikiki trades in 568 stores in 27 countries, with the company’s philosophy that “Everyone Deserves to Dress Well” enabling people to enjoy accessible fashion through quality products at affordable prices.

LC Waikiki employs approximately 24,000 employees and its systems infrastructure includes 550 SQL Server databases being managed by five full time database administrators (DBAs). The role of the DBA team is to provide best practices for SQL Server administration and to build, maintain and troubleshoot database related problems.


With more than 550 SQL Server databases in its environment, the LC Waikiki DBA team needed a database management tool that could consolidate all of their administrative tasks and help them manage their complex SQL Server environment in a simple and effective way. The organization sought a SQL Server management solution that was affordable and kept up with demand while streamlining operations and ultimately increasing efficiency

Topics : Database Diagnostics,Database Monitoring,Database Performance,SQL Query Performance,

Products : SQL Diagnostic Manager for SQL Server,SQL Doctor,