Case Study: SQL Diagnostic Manager for SQL Server

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


To better manage its SQL Server infrastructure, LC Waikiki started looking for software solutions that offered database error detection's and diagnostics, provided database configuration recommendations, traced SQL Server jobs steps, and provided recommendations on SQL Server optimization.

“We discussed our requirements with several vendors in the market and we requested a demo or proof of concept,” said Türkalp Ulucutsoy, database administrator at LC Waikiki. After considering the various options, LC Waikiki chose IDERA products, which produced immediate and strong results.


Today, LC Waikiki uses IDERA SQL Diagnostic Manager and SQL Doctor, which have helped the organization save significant man-hours by quickly identifying deadlocks. “IDERA has solved most of our problems,” added Türkalp.

The organization also credits IDERA with its Microsoft SCOM integration and its strong mobile compatibility. “MS Platform Support is very important to us,” said Türkalp. “The more you use the SQL Diagnostic Manager product, the more you realize how detailed and flexible it is. We’ve seen tremendous results from using IDERA, and we’re hoping that our other stores worldwide adopt SQL Diagnostic Manager as well.”

Download This Case Study Start a FREE Trial of SQL Diagnostic Manager
Share This
Contact IDERA:
+1 (713) 523-4433