Add the following registry key:
Value name: GCFailFastOnOOM
Value type: REG_DWORD
Value data: 4
The value of “4” writes an event message that includes the size of the allocation that failed and the number of bytes in use. A value of “1” simply logs an event in the Application event log. A value of “2” allows a debugger to be attached.
Use the “4” option to grab a dump, then examine the dump for severe fragmentation of the heap, or an attempt to allocate a huge object.
Select count(distinct crawlid) from msscrawlurllog
stsadm.exe -o execadmsvcjobs
Several content databases have a scheduledworkitems table where timer job GUID’s are kept.
For WSS, you will find the data in the “userinfo” table of the content database. For MOSS, you will also find user data in the SSP database in the “UserProfile_Full” table.
Here’s a shortcut to getting the db_id of the SharePoint content database:
“Go to Central Administration > Application Management > Content Databases. Select the Web Application that is of your interest, and then click on the database name. Once you are on “Manage Content Database Settings” page, you can see the ContentDBID in the URL.”
Or open SQL Management Studio and select a database in Object Explorer. Then click “New Query” and execute the following script: “select DB_ID() as [Database ID];”
This will return the Database ID.
select * from sys.databases;
C:Documents and SettingsAll UsersApplication DataMicrosoftSharePointConfig
From the 12 Hive’s BIN directory, run this command:
psconfig -cmd upgrade -inplace b2b -wait -force