Usage Analysis Processing - Server Out of Memory error

In our company's project, We have Two enviornments Windows SharePoint Services and Microsoft office SharePoint Server 2007. Both are classified into 3 stages as Tes, QA and Production. In WSS 3.0 Test enviornment, when we tried to enable Usage Analysis processing, we got an error message :
"Server Out Of MemoryThere is no memory on the server to run your program. Please contact your administrator with this problem."

I can't find anything in the EVENT LOGS on the server that indicate an issue with this.
After doing lots of troubleshooting for more than 2 days, we found out the resolution.You can't believe it but the resolution is very simple and straightforward.

We found out that the application pool account was running under Network Service. We changed it to Domain admin account and after that did IISRESET.

Issue Resolved.
Cheers !

Note:-
The domain account should have the following rights as follows:-
1. It should be present in the WSS_WPG,WSS_ADMIN_WPG and IIS_WPG and Administrator group.
2.It should be present in the SQL SERVER Logins Section.
3. It should have DBCREATOR & SECURITY ADMIN Permissions in the SQL SERVER.

The application pool identity is essentially what the ASP .Net code of the site will be executing as. The user account used here must have the standard rights in order to run an application pool, and must obviously have rights to read and write to the SQL Server databases for the site.

Thanks...

How to configure Usage Analysis Processing on a Web server that is running Windows SharePoint Services 3.0

To turn on Windows SharePoint Services usage logging in an Office SharePoint Server farm, you must first turn on Usage Analysis Processing in Windows SharePoint Services 3.0, and then turn on Advanced Usage Analysis Reporting service in Shared Services Administration. To do this, follow these steps:

1.Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
2.On the Central Administration page, click Operations.
3.On the Operations page, under Logging and Reporting, click Usage Analysis Processing.
4.In the Logging Settings section, click to select the Enable logging check box.
5.In the Log file location box, type the location where you want to store the log file.The default location for the log file is \Program Files\Common Files\Microsoft Shared\Web Server Extension\12\Logs.
6.In the Number of log files to create box, type a number between 1 and 30. In general, use a number that is one to three times the number of database servers in your server farm, with a maximum number of 30 log files.
7.In the Processing Settings section, click to select the Enable usage analysis processing check box.
8.Under Run processing between these times daily, specify the range of times to start the usage analysis log processing.In the Start box, select the earliest time of day to start running log processing. In the End box, select the latest time to start running log processing.
9.Click OK.

Refferance:-
http://support.microsoft.com/kb/825541

How to configure Usage Analysis Processing on a Web server that is running Windows SharePoint Services 2.0

Usage analysis processing is set up through SharePoint Central Administration. To do this, follow these steps:

-Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint Central Administration.
-Under Component Configuration, click Configure usage analysis processing.
-In the Logging Settings section, click to select the Enable logging check box.
-In the Log file location box, type the location where you want to store the log file.The default location for the log file is c:\Windows\system32\LogFiles\STS.
-In the Number of log files to create box, type a number between 1 and 30. In general, use a number that is one to three times the number of database servers in your server farm, with a maximum number of 30 log files.
-In the Processing Settings section, click to select the Enable usage analysis processing check box.
-Under Run processing between these times daily, specify the range of times to start the usage analysis log processing.In the Start box, select the earliest time of day to start running log processing. In the End box, select the latest time to start running log processing.
-Click OK.

Refferance:-
http://support.microsoft.com/kb/825541

Configure usage reporting

Usage reporting is very useful for managing complex site hierarchies with many sites, a large number of page hits, and a large number of search queries, and it is recommended that the service be enabled for deployments of complex site hierarchies. For less complex deployments, usage reporting might not be necessary. It is also possible to disable the service temporarily to conserve resources when other those resources are needed for other processes.

To configure usage reporting, a farm administrator must first enable Windows SharePoint Services usage logging for the farm that hosts the Web application containing the SSP. The SSP administrator enables and configures the usage reporting service. Then, site collection administrators can activate the reporting feature to enable usage reports on the site collection.

Enable Windows SharePoint Services usage logging

Before you can enable usage reporting in a SSP, you must first enable Windows SharePoint Services usage logging for the farm hosting the Web application containing the SSP.

Use the following procedure to enable usage logging for the farm.

Enable usage logging for the farm

1)   On the Central Administration home page, click Operations.

2)   On the Operations page, in the Logging and Reporting section, click Usage analysis processing.

3)   On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging.

4)   Type a log file location and number of log files to create.

5)   In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing.

6)   Click OK.

Enable usage reporting

1)   On the SSP home page, in the Office SharePoint Usage Reporting section, click Usage reporting.

2)   On the Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing.

3)   In the Search Query Logging section, select Enable search query logging.

4)   Click OK.

5)   Activate usage reporting

After usage reporting is enabled for the SSP, site collection administrators must activate the reporting feature. Until the reporting feature is activated on a site collection, usage reports are not available.

Use the following procedure to activate the reporting feature.

1)   On the Site Actions menu, click Site Settings.

2)   On the Site Settings page, in the Site Collection Administration section, click Site collection features.

3)   On the Site Collection Features page, click the Activate button for the Reporting feature.

Monitor usage reporting

Usage reporting can be viewed in several places:

1)   Site administrators, including administrators of the SSP administration site, can view usage reporting for their site by clicking Site usage reports in the Site Administration section of the Site Settings page.

2)   Site collection administrators can view usage reporting by clicking Site collection usage reports in the Site Collection Administration section of the Site Settings page.

3)   Site collection administrators for the SSP administration site can view a usage summary by clicking Usage summary in the Site Collection Administration section of the Site Settings page.

4)   SSP administrators for search can view search usage reports by clicking Search usage reports in the Search section of the SSP home page.

I hope the above information helps you to configure Usage analysis Processing.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.