Tham khảo tài liệu 'mastering sql server 2000- p20', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 970 I CHAPTER 26 MONITORING AND OPTIMIZING SQL SERVER 2000 12. Click Next. 13. Under Select Tables to Tune click Select All Tables. Index Tuning Wizard - instructor Select Tables to Tune Choose the tables for the wizard to tune. This is a list of all the tables the wizard can analyze. This analysis is often time consuming. To reduce the duration select only the most critical tables. By changing number of projected table rows you can account for future database growth. Table Actual Rows Projecter 0 dbo . Categories 8 8 0 dbo . CustomerCustomerD emo 0 0 0 dbo . CustomerD emographics 0 0 0 dbo Customers 92 92 0 dbo Employees 10 J J Select all tables Unselect all tables Back Cancel 14. Click Next the Wizard will now start tuning your indexes. 15. You will be asked to accept the index recommendations click Next. TIPS AND TECHNIQUES 971 16. If there were recommendations you would be asked to schedule them for later or run them now but because there are no recommendations for this workload file you are taken directly to the final screen. Click Finish to complete the Wizard. 17. When you receive a message stating that the Wizard has completed click OK. 18. Exit Profiler. Tips and Techniques If you want the best results from SQL Server s monitoring tools you need to know and use the proper techniques. If you don t the end result will not be what you are hoping for or what you need. Setting a Measurement Baseline You will never know if your system is running slower than normal unless you know what normal is which is what a measurement baseline does It shows you the resources memory CPU etc. SQL Server consumes under normal circumstances. You create the measurement baseline before putting your system into production so that you have something to compare your readings to later on. PART VI Advanced Topics 972 CHAPTER 26 MONITORING AND OPTIMIZING SQL SERVER 2000 The first thing you need to create an accurate measurement baseline is a test network with just your SQL Server and .
