none
Search Server 2010 vs SQL Server Express 2012

    Question

  • Hi,

    We have a "Microsoft Search Server 2010 Express" server using "SQL Server 2012 Express" located on another machine.

    My understanding is that "SQL Server 2012 Express" has a limitation of 10 Gb of storage per database.

    However, on the Search Server indexing stops after a while with this message in Event Viewer:

    "Database « Application_de_service_de_recherche_CrawlStoreDB_663ceeb544c34ef68777db5b95363971 » is near the 4 Gb limit imposed by SQL Express." (translated from french).

    It seems like "Search Server 2010 Express" is not aware that the limit is now 10 Gb.

    Any ideas how to make Search Server 2010 go over the 4 Gb limit ?

    Thank you.


    - ThePro

    Monday, April 23, 2012 3:35 PM

Answers

  • The value is set in code, though it looks like you might be able to override it in the registry by creating a MaxSearchDBSizeMB value in the registry.

    private static float ReadMaxDBSizeForSqlExpress()
    {
        float num = 3686.4f;
        using (RegistryKey key = Registry.LocalMachine.OpenSubKey(@"Software\Microsoft\Office Server\14.0\Search\Global"))
        {
            object obj2 = key.GetValue("MaxSearchDBSizeMB");
            if (obj2 is int)
            {
                num = (int) obj2;
            }
        }
        return num;
    } 
    


    http://sharepoint.nauplius.net

    • Marked as answer by McThePro Monday, May 07, 2012 1:01 PM
    Thursday, April 26, 2012 1:00 PM
    Moderator
  • I'll try that and come back with the result.

    Is it how the registry key should be for 10 GB max ?


    - ThePro

    • Marked as answer by McThePro Monday, May 07, 2012 1:01 PM
    Friday, April 27, 2012 1:13 PM

All replies

  • Can you please confirm if SPF is using the R2 instance and not the built-in one (I believe that one is the vanilla copy with 4 GB limit).

    SQL Server Express imposes a 4 GB database size limit, which translates to about 500,000 items in the search corpus. Moving to a different SQL Server edition would eliminate this limitation.

    For more details:

    http://social.msdn.microsoft.com/Forums/hr/sharepoint2010general/thread/477ecdf2-e67b-448d-b979-58e8f326b31f

    Tuesday, April 24, 2012 4:46 AM
  • Hi,

    I do not know how to "confirm" which database the server is using. I know that if I run the "Sharepoint configuration assistant", on the second screen the database server is my SQL Server 2012 Express server.

    Note that the error message says that it is "near" the 4 GB limit, not that it hits the limit. It seems like Search Server is limiting itself when it should not.


    - ThePro

    Tuesday, April 24, 2012 11:59 AM
  • I checked my SQL Server 2012 Express and here is a screen shot of the CrawlStore database. It is already over 4 GB !


    - ThePro

    Tuesday, April 24, 2012 1:09 PM
  • Go to "Central Administration" and click on "Manager Servers in Farm" under "System Settings". You can check here get information about servers.
    Wednesday, April 25, 2012 5:42 AM
  • You can see from this screen shot that the database server is my SQL Server 2012 Express (SQLSAG01).


    - ThePro

    Wednesday, April 25, 2012 11:58 AM
  • Can you please click on SQLSAG01 and show details there?
    Thursday, April 26, 2012 3:48 AM
  • There is not much there...


    - ThePro

    Thursday, April 26, 2012 11:58 AM
  • The value is set in code, though it looks like you might be able to override it in the registry by creating a MaxSearchDBSizeMB value in the registry.

    private static float ReadMaxDBSizeForSqlExpress()
    {
        float num = 3686.4f;
        using (RegistryKey key = Registry.LocalMachine.OpenSubKey(@"Software\Microsoft\Office Server\14.0\Search\Global"))
        {
            object obj2 = key.GetValue("MaxSearchDBSizeMB");
            if (obj2 is int)
            {
                num = (int) obj2;
            }
        }
        return num;
    } 
    


    http://sharepoint.nauplius.net

    • Marked as answer by McThePro Monday, May 07, 2012 1:01 PM
    Thursday, April 26, 2012 1:00 PM
    Moderator
  • I'll try that and come back with the result.

    Is it how the registry key should be for 10 GB max ?


    - ThePro

    • Marked as answer by McThePro Monday, May 07, 2012 1:01 PM
    Friday, April 27, 2012 1:13 PM
  • It doesn't specify, and Microsoft doesn't indicate what type the key should be as this is undocumented.

    http://sharepoint.nauplius.net

    Friday, April 27, 2012 1:18 PM
    Moderator
  • Our week-end indexing worked OK, so I think the problem is solved. I will know for sure next Monday. Thank you very much for your help here.

    - ThePro

    Monday, April 30, 2012 1:40 PM
  • Keep me updated, would be interested to see if that registry key works correctly, and if the DWORD was the right type to use.

    http://sharepoint.nauplius.net

    Monday, April 30, 2012 1:41 PM
    Moderator
  • I confirm that the registry key solves the issue. Thank you very much.

    I wrote the solution on my blog: http://mytechweblog.blogspot.ca/2012/05/search-server-2010-vs-sql-server.html


    - ThePro


    • Edited by McThePro Monday, May 07, 2012 1:25 PM Added link
    Monday, May 07, 2012 1:01 PM