Thousands of empty customer records created every day

select * from [dbo].[Customer]
  where IsSystemAccount = 1

builtin@search_engine_record.com
[email protected]

Query should return two records. When site get crawled, system consider the bot as  builtin@search_engine_record.com instead of creating new customer records(eventually increasing identity value).

If you already have the system accounts, check if you have any third party monitoring system (like monitis, pingdom) setup to do automated testing on your site which can create guest customers and increase identity, in that case you need to modify code to assign the testing tool as a system user.

Try this

INSERT INTO [dbo].[Customer]
           ([CustomerGuid]          
           ,[Email]        
           ,[PasswordFormatId]           
           ,[AdminComment]
           ,[IsTaxExempt]
           ,[AffiliateId]
           ,[Active]
           ,[Deleted]
           ,[IsSystemAccount]
           ,[SystemName]          
           ,[CreatedOnUtc]  
       ,[LastActivityDateUtc]
           ,[VendorId]
           ,[HasShoppingCartItems])
     VALUES
           (newid()          
           ,'builtin@search_engine_record.com'          
           ,0          
           ,'Built-in system guest record used for requests from search engines.'
           ,0
           ,0
           ,1
           ,0
           ,1
           ,'SearchEngine'        
           ,GETUTCDATE() 
       ,GETUTCDATE() 
           ,0
           ,0)

INSERT INTO [dbo].[Customer]
           ([CustomerGuid]          
           ,[Email]        
           ,[PasswordFormatId]           
           ,[AdminComment]
           ,[IsTaxExempt]
           ,[AffiliateId]
           ,[Active]
           ,[Deleted]
           ,[IsSystemAccount]
           ,[SystemName]          
           ,[CreatedOnUtc]  
       ,[LastActivityDateUtc]
           ,[VendorId]
           ,[HasShoppingCartItems])
     VALUES
           (newid()        
           ,'[email protected]'          
           ,0          
           ,'Built-in system record used for background tasks.'
           ,0
           ,0
           ,1
           ,0
           ,1
           ,'BackgroundTask'        
           ,GETUTCDATE()
       ,GETUTCDATE() 
           ,0
           ,0)
GO

Can you also check if you have the uas_20140512-01.ini file in App_Data folder?

Im using 3.80 and i dont see  uas_20140512-01.ini in the app data folder. Is this expected?

If it should exist then can you please tell me how to get this file now?

<!-- You can get the latest version of user agent strings at http://browscap.org/ -->
<UserAgentStrings databasePath="~/App_Data/browscap.xml" />

Im using 3.80 and i dont see  uas_20140512-01.ini in the app data folder. Is this expected?

If it should exist then can you please tell me how to get this file now?

For 3.80, file name should be browscap.xml. If it's missing, you can get the latest version of user agent strings at http://browscap.org/


To be sure, check web.config file you would find following lines as reference.

<!-- You can get the latest version of user agent strings at http://browscap.org/ -->
<UserAgentStrings databasePath="~/App_Data/browscap.xml" />

Can you check my previous responses? Make sure you have the two system users in customer table