After a V5 to V6 upgrade SQL server uses a lot of CPU when using the console.
SQL server has not been optimized yet for the particular queries.
1) Find SQLCMD.exe
The SQL command-line tool can be found in the following folder:
C:\Program Files\Microsoft SQL Server\100\Tools\Binn
where the highlighted portion can vary depending on your version of SQL server (use the folder with the highest number if there’s more than one).
2) Execute the following:
SQLCMD.exe -S (local)\SQLSERVER -d StoragePlatform -Q sp_updatestats
The highlighted values can be obtained from the ConnectionStrings.config file in the SP installation folder, like in the sample below:
<add name="BackupServer" connectionString="Data Source=(local)\SQLExpress; Initial Catalog=StoragePlatform; Persist Security Info=True; Integrated Security=SSPI; MultipleActiveResultSets=True"/>
If you don’t use integrated security and require a username and password to access the DB, those need to be supplied on the command-line as well (using -U username -P password).
Note that the case of the parameters is important (i.e. -u is not the same as -U).