Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.
Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.
Please reference Microsoft Article 319942 for information on how to determine the proper SQL Server configuration settings.
- Microsoft SQL Server Management Studio
- Right click on the instance, select properties
- Highlight Processors under Server Properties
- Un-mark the checkbox "Boost SQL Server priority"
- Select "OK", close Microsoft SQL Server Management Studio
- Reboot the SQL Server
"By default, the priority boost setting is 0, which causes SQL Server to run at a normal priority whether you run SQL Server on a uniprocessor computer or on a symmetric multiprocessor (SMP) computer. If you set priority boost to 1, the SQL Server process runs at a high priority. This setting does not make the SQL Server process run at the highest operating system priority.
Based on actual support experience, you do not need to use priority boost for good performance. If you do use priority boost, it can interfere with smooth server functioning under some conditions and you should not use it except under very unusual circumstances. For example, Microsoft Product Support Services might use priority boost when they investigate a performance issue."