Automatic Update of Microsoft SQL Server Statistics
If you monitor the performance of Microsoft SQL server in your tests and
collect SQL performance counters statistics, you may sometimes need
to update server statistics. This can be done automatically if you create a job
in Microsoft SQL Server Management Studio and define the necessary scheduling options.
Note that usually MSSQL server statistics is updated automatically and you will not need to create any special jobs.
This procedure is required only in case you receive wrong results using the default settings,
e.g. you see that received
values are not updated, or they are equal to 0, or you do not receive any values at all.
In this case we recommend adding a new job for regular update. Below is the instruction how to do it.
Open Microsoft SQL Server Management Studio, select
SQL Server Agent -> Jobs, right-click to get the menu and choose the New Job...
option on the menu.
In the displayed New Job dialog select the General tab and enter a name
for the new schedule.
Then select the Steps tab and click the New... button.
In the displayed New Job Step dialog enter a step name and type sp_monitor
in the Command field. Make sure that the option master is selected in the
Database combo-box. Click OK.
Select the Schedules tab and click the New... button.
Enter a name for the new schedule. In the Occurs combo-box select "Daily", "Weekly" or
"Monthly". Then specify how often to refresh the server statistics
(Recurs every options) and click OK.
Your new job will be added to the list of jobs.
Now the update of Microsoft SQL server statistics will be done automatically according to the scheduling options you
have just specified.
