FogBugz is Too Slow

If you are using FogBugz On Demand, disregard this guide and contact us.  This article is meant for Licensed FogBugz.

Problem:

Every time FogBugz tries to load a page it takes a long time.

Solutions:

  1. Email Server Issues? Determine if this only happens when automatic email notifications get sent. Is it the case that assigning a bug to a person with email notification turned on causes a delay, but assigning a bug to a person with email notification turned off happens instantly?

    If this is the case, the problem is related to your SMTP mail server. It's possible that the mail server is remarkably slow. More commonly, it's caused by a firewall between the mail server and the FogBugz server. See Troubleshooting Email Notification Problems for more details, especially the section titled "Check that you are not blocking ident traffic" and the notes on nslookup right above that.

  2. Database Authentication? If it happens for all page loads, it may be an authentication issue. In Windows: If your connection string has this in it:

    Integrated Security=SSPI; 

    ...then switch to name and password in the connection string, using a SQL Server login that has db_owner rights and access to the FogBugz database. Example: 

    Provider=sqloledb;Data Source=SERVER-NAME-HERE;Initial Catalog=fogbugz;uid=USER-NAME-HERE;pwd=PASSWORD-HERE

  3. DNS Issues? If you are not using Windows Integrated Security, and are passing a username and password for a database login, and page loads are still slow, one thing to try is the following. In the connection string, shown above, note the server name part:

    Data Source=SERVER-NAME-HERE;

    Instead of using the server name, use the IP address. Or, if the database is on the same machine as the web server, use:

    Data Source=[localhost];

    This has been known to work in some cases.

  4. Slow SQL Server? If you use SQL Server with FogBugz, try restarting SQL Server. If after restarting SQL Server, an event in Event Viewer comes up as:

    supersocket info: connectionlisten(shared-memory LPC)) error 5

    Go to http://support.microsoft.com/kb/815249 and execute the workaround listed there...

  5. Virus Scanner?   McAfee Virus Scan may be monitoring all files. Other users found that this killed their performance (presumably because every time SQL Server hit the disk, McAfee was checking the DB files for viruses. Updating McAfee to the latest version and having it ignore the DB files completely solved the problem).

  6. ASP Caching?   IIS may have ASP caching turned off.  If every single FogBugz page takes a long time to load, including the log on page, check to make sure that ASP Caching is turned on by following the instructions at Microsoft's TechNet for Windows Server 2003.