Is your Business Objects Server running at CPU 99% load?

Today the Business Object server was running like a dog, checking the performance showed that the server was eating up 99% CPU at all times.  The problem turned out to be related to the Index Service running continually rather than on a scheduled basis.

Steps to address the where:

1. Login to CMC

2. Click on Application, Right click Platform Search Application>Properties

3. In Crawling frequency, select #Scheduled crawling#

4. In Level of indexing, select #Platform and Document Metadata#. (Optional, platform search application will index faster)

5. In Content Types, uncheck #Universe#. (Optional, platform search application will index faster)

6. In Error Recovery, check #Rebuild index#

7. Save and Close

8. Go to Folder>Platform Search Scheduling, schedule the Platform Search Scheduling object to be done when times when there is a lower usage of the resources

Changing the collation of a SQL Server database

If a SQL Server instance has been created using the wrong default collation, it can be a bit of a pain if you try to access the TempDB.

Luckily there is a way to fix this.

1) Logon to the server

2) Backup all the existing database (Note: The collections of existing databases won’t change on the system DBs and any new User database created using the default collation!)

3) Delete/Remove any existing database; this is not specifically needed, but it’s not a bad idea as it will confirm that you have a backup.

4) Open a command window with elevated permissions.

5) Go to the default SQL Server installation directory by typing:
cd C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

6) Enter the following command:

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=WOODGROUP\GG-EPF-AU-BSG-ADMINS "NT AUTHORITY\NETWORK SERVICE" "NT AUTHORITY\SYSTEM" "NT SERVICE\MSSQLSERVER" "NT SERVICE\SQLSERVERAGENT" /SAPWD=<password>.1 /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

Note; /INSTANCENAME=MSSQLSERVER is the name of the default instance

Important: “/SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS” was just chosen at random

7) Restore the backup databases.