Case Study: Western Furniture Ltd.


SCENARIO

ESSENCE OF THE CASE:

  • Western Furniture wants to increase business by adding more users and importing more furniture.

  • All imported furniture is recorded in the Products table in the central database. Each table in this database stores over 50,000 records.

  • Database users report slow response times when querying columns on the Products table after the recent upgrade.

Your company, named Western Furniture, imports furniture from different parts of the world, with twenty sales offices around the nation. This company is well known for the quality furniture it provides. Company officers want to increase their supply by increasing the amount of imported furniture by four times and creating four new sales offices in Washington, Chicago, Toronto, and New York. They also want to increase the number of users accessing their database from 50 to 150.

All imported furniture is recorded in the Products table in the central database. Each table in this database stores over 50,000 records. Sales and supply information is updated daily in the Sales table. The users of the database report slow response times when querying columns on the Products table after the recent upgrade. The workforce does not currently have employees specializing in database performance tuning but are planning to hire in the near future.

ANALYSIS

The best solution for this type of situation would be to index the Products table. This would provide faster access to data, especially when querying with the SELECT statement, because the number of rows is more then 50,000. But the hard decision would be which column or columns should be indexed. Your SQL Server administrators know very little about database performance. In this case, Index Tuning Wizard comes in. The Index Tuning Wizard chooses the best course of action for your index. It determines which column or columns need to be indexed and which type of index needs to be used. Also, the Index Tuning Wizard does not require anyone to know about index internals, which makes it a perfect solution for the SQL Administrators. Also consider whether there is a blocking problem.



MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 228

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net