Attix5 Pro FAQ
Search:     Advanced search

SQL server using CPU after V5 to V6 upgrade

Article ID: 38
Last updated: 05 Jan, 2011

Symptom

After a V5 to V6 upgrade SQL server uses a lot of CPU when using the console.

Reason

SQL server has not been optimized yet for the particular queries.

Resolution

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="BackupServerconnectionString="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).
Article ID: 38
Last updated: 05 Jan, 2011
Revision: 1
Views: 2442
Comments: 0
Posted: 08 Oct, 2010 by Marais D.
Updated: 05 Jan, 2011 by Marais D.
This article was:  
Prev   Next
Article 39 - Controlling the runaway cache on Windows Server 2008     Article 17 - Storage Platform errors due to incorrect time synchronisation