Database Reference
In-Depth Information
Figure 11.98
Validating the database build.
The command will return the number of rows affected; in our configuration, the value
returned was 200,000. It is alright to exit PowerShell at this time.
One of the first tasks we are going to run is to update the database statistics to improve
database performance. To do this, in the Microsoft SQL Server Management Studio
interface, expand
Management
. Then right-click
Maintenance Plans
and select
Maintenance Plan Wizard
. On the first page of the
Maintenance Plan Wizard
, click
Next
. On the
Select Plan Properties
page, provide a name for the plan (DS2 MP), as
shown in
Figure 11.99
,
and click
Next
.
