MOSS Limitations pre SP2

Check out performance guidelines and limitations on SharePoint 2007 with SP1 from Microsoft.

http://technet.microsoft.com/en-us/library/cc262787.aspx

Best practices for search performance

In Office SharePoint Server 2007, you also have SharePoint groups. This system is very flexible and can include multiple layers of nesting. However, security principals can adversely affect Office SharePoint Server search performance.


To ensure maximum performance from the Office SharePoint Server 2007 crawler and searches, observe the following rules when you are using Active Directory security principals and SharePoint groups:

Place user accounts into global groups, and global groups into domain local groups. Assign permissions to domain local groups. This is the recommended best practice for using security principals in Active Directory. It ensures that domain controllers can look up group memberships quickly and that users can access resources throughout the forest.

If universal groups are necessary, use the same system but put global groups into universal groups and universal groups into domain local groups.

Put domain local groups into SharePoint groups to assign permissions to SharePoint sites and other resources.


Limit the number of nesting levels used in group membership.

• Do not Assign Office SharePoint Server site permissions to individual users.
• Do not Use deeply nested Active Directory security groups.
• Do not Use distribution lists or security groups that contain contacts.

For more details -

Search Performance

SharePoint Backup Error

If you get the following error message while trying to run the backup process from Central Admin or through stsadm.

"Object WSS_Content failed in event OnBackup. For more information, see the
error log located in the backup directory. SqlException: Cannot open backup
device 'C:\SharePoint\backup\spbr0002\00000012.bak'. Operating system error
3(The system cannot find the path specified.). BACKUP DATABASE is terminating
abnormally. "

To resove this problem, make sure you are UNC path for backup and the account running SQL service has write access to this path, for more detail -
http://support.microsoft.com/kb/207187


Backup plan may fail with the following error
************************** Errors ***********************
Path: http : / / web / sites / wwwwww, Status: Failed.
Error Message: Site Level Backup Backup() error:Write error on file
"sharepoint_bak.dat".
******************************************************

A likely reason that this is failing is that the location where the file is being written to does not have sufficient space.

Remove large SQL 2005 Log file to save disk space

Sometimes we just do not need the big log file, specially if you are working on dev machine with SQL server - true in most cases with SharePoint 2007 server install. So here are the steps to clear some much needed space by removing the database log file. 

1. Detach the database
2. Rename the log file
3. Attach the database without the log file
4. Delete the log file

Let's say, the database name is WSS_Content. Open your SQL Server Management Studio,
Highlight the database -> Select Tasks , now select Detach and Click OK
Go to your log file folder -> rename the WSS_Content_log.ldf to be like testDev_log-to_be_deleted, and now go back to SQL Server Management Studio follow these steps -

Highlight Databases -> select Attach and click on Add -> add your database WSS_Content, highlight the log file and click the "Remove" button. This attach WSS_Content.mdf and create a new fresh log file.

After this is done, make sure that you verify the contents of the attached database and then delete your old log file.

And please don't forget to run Defrag on your machine, so that you can enjoy better performance.

Have Fun!!