Note: These steps are for those organizations that host their Blackbaud NetCommunity site and/or The Raiser's Edge within their organization.  If you host both of these databases, Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.
If Blackbaud host the NetCommunity website or both of these databases, please Contact Support and reference this article. 
 
  • Database Maintenance: Ensure you are running database maintenance on a regular basis.  Running database maintenance can improve process times which improves overall performance. The Raiser's Edge database maintenance is performed in the Blackbaud Management Console. If we do not host your Blackbaud NetCommunity database, perform Blackbaud NetCommunity maintenance either in Management Studio or Enterprise Manager, depending on the version of SQL Server is installed.
     
  • Files and Folder Permissions: When Blackbaud NetCommunity is functioning slowly but connects to The Raiser's Edge database, ensure that file and folder permissions are applied appropriately on the server that has The Raiser's Edge Web Services installed (Commonly referred to as the 'REWS'). These permissions must be propagated in the advanced section.  For more information, refer to What NTFS permissions are required for Blackbaud NetCommunity
     
  • IIS Logs: Review IIS logs for at least the last two days. If logging is not enabled in IIS, enable logging and provide logs after the error has been recreated.
     
  • Pooling setting check: Pooling should be enabled by default on the SQL server ODBC driver. To confirm this:
    1. Select Star, Run from the taskbar
    2. Enter ODBCAD32 and click Run
    3. Select the Connection Pooling tab
    4. Double-click SQL Server in the driver list. Ensure 'Pool Connections to this driver' is set.  
       
  • Firewall settings: Review your firewall logs to see if there are any logs around the times your errors or performance issues occurred. Look for traffic being blocked on ports 80, 443 or the port on which SQL Server is running.
     
  • Netstat: Run netstat -n from the Blackbaud NetCommunity Web Server to ensure all 'States' show established.
     
  • VNC Viewer: We have seen performance issues when the VNC Viewer is run on the Blackbaud NetCommunity server, causing performance issues throughout the entire site. Instead of running VNC, use RDP.
     
  • McAfee: Run Blackbaud NetCommunity with McAfee turn on and turned off to see if McAfee is negatively affecting Blackbaud NetCommunity performance.