MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

Objective 5.3: Scale Database Applications

• Practice 1 See if you can get access to multiple servers or workstations in your organization and perform the following steps:

  • Install SQL Server 2005 on these machines if it is not already available.

  • Reference the AdventureWorks database already available on one of the SQL Servers. Determine how you can partition the data in the Person.Contact table.

  • Select a partitioning column that was not already used in this chapter and move a portion of the data to at least one other server.

  • Create linked servers that point to the other SQL Servers.

  • Create a distributed partition view that joins the data from all servers into a single view using the UNION clause.

Objective 5.4: Resolve Performance Problems

• Practice 1 Refer to the lab in the second lesson. Use the Web application and script created with that exercise to perform another load test. This time, execute System Monitor and add performance counters listed in Table 8-4 to create a baseline. After the test completes, review the results and record them to a log file.