[SDP 5][0b99f060-e9f9-48ba-933c-51d64de85508] - SharePoint Performance and Publishing (SPPerfPub)

Summary
This SharePoint Performance and Publishing (SPPerfPub) manifest detects certain problematic conditions that may exist in the configuration of the server that is running Microsoft SharePoint Server. The rules in this diagnostic package are limited to SharePoint Performance and Reliability.

Important The problematic conditions are checked only on the server on which this manifest is run. To make sure that you have maximum coverage, we recommend that you run SETH on every computer in the Microsoft SharePoint farm.

This article explains the operation of this manifest file.

Required permissions

The rules in the diagnostic package leverage the SharePoint Windows PowerShell snap-in to get information about your farm. Therefore, the account that is used to run the diagnostic package must either be the farm account or have been given the required permissions through the Add-SPShellAdmin command. Note that the farm account is the account under which the timer service and central administration site's application pool are running.

Some rules in this diagnostic package also must have local server administrative credentials to use remote and local administrative tools and to access secure system locations, such as the registry. Use the following table to reference the permissions that are required for each rule.
Permission codeDescriptionRequired permission
1 Use SharePoint Windows PowerShell cmdlets to interact with the SharePoint farm.Farm administration
2 Run queries against SharePoint databases.Farm administration
3 Access server administrative tools.Server administrative
4 Access files and other resources on the server.Server administrative

This article describes the information that may be collected from a computer when you run SPPerfPub.
More information
DescriptionFile Name
This is the actual results of the SETH manifest. This is what is shown to the user to indicate that status of each rule that is run.ResultReport.xml
This is an xlst transform that formats the results in the ResultReport.xml file. It contains no customer data.Results.xsl
This file contains debug information that may be generated during the execution of the manifest. It also contains timings on each of the rules that are run. It may contain customer data. However, every attempt has been made to minimize the amount of data.SPPerfPub.0.debugreport.xml
This file contains additional debug information for the manifest execution. It may contain customer data. However, every attempt has been made to minimize the amount of data.Stdout.log
This file contains the environmental information for each computer in the farm. The information that is captured includes the following:
  • Computer name
  • Operating system name
  • Last reboot/uptime
  • Computer model
  • Processors
  • Computer domain
  • Role
  • Operating system language
  • Time zone
  • Total RAM
  • Drives (total and free space available)
%COMPUTERNAME%_SPPerfPub_O14SP_FarmEnvironment.txt
This file contains SQL Server information from the SQL instance that hosts the SharePoint Configuration database. The information that is captured includes the following:
  • ProductVersion
  • ProductLevel
  • Edition
  • ServerName
  • InstanceName
  • MaxDegreeOfParallelism
  • LastUpdateDate
  • IsClustered
  • IsFullTextInstalled
  • IntegratedSecurity
%COMPUTERNAME%_SPPerfPub_O14SP_FarmEnvironment.txt
This file contains a summary of the performance and capacity values for the Audit Data table. The information in this file includes the following: 
  • Total count of Audit Data table rows 
  • Size of Audit Data Table on disk 
  • Size of Audit Data Index on disk
  • Top 10 Days by count of rows
  • Top 10 Paths by count of rows
%COMPUTERNAME%_cfg_en-us_O14SP_AuditDataReport.txt
This file contains a summary of the All Doc Versions table. The information in this file includes the following:
  • Total count of table rows 
  • Size of table on disk 
  • Size of index on disk
  • Top 10 Items by count of document versions
%COMPUTERNAME%_cfg_en-us_O14SP_DocVersionsReport.txt

Hardware/software requirements

Rule IDTitleRequired permissionsDescription
8F1C132D-2656-4D8D-9E58-606C0F97B748Check for minimum hardware configuration3http://technet.microsoft.com/en-us/library/cc262485.aspx

Caching

Rule IDTitle Required
Permissions
Description
8B2B2A65-1FA3-4597-B217-73318182A8CEDisk-based cache at critical capacity4http://technet.microsoft.com/en-us/library/cc770229.aspx
5C46FD14-B4AB-C0DE-DE06-51BD7641DAEABroken ASP.Net Output Cache1, 4http://blogs.msdn.com/b/calvarro/archive/2012/01/25/moss-2007-output-cache-stops-working-after-installing-security-update-for-the-net-ms11-100.aspx
071A5E86-5193-49C1-A332-C08FD5118238Check Portal Super Reader Account Configuration for Claims Based Web Apps4http://technet.microsoft.com/en-us/library/ff758656.aspx

Capacity Planning

Rule IDTitleRequired PermissionsDescription
3FADCA3A-DA90-49E3-BAD9-61F146329F9CSupported: 300 content databases per web application 1http://technet.microsoft.com/en-us/library/cc262787.aspx#hierarchy​
D4B272DD-5DB9-47CB-9FAB-3CF3224EB916Threshold: 5,000 list items per folder1http://technet.microsoft.com/en-us/library/cc262787.aspx
7BF1F8F9-16F4-41D4-BC74-67F6BEB638BFThreshold: List view threshold value in resource throttling configuration set to 5,0001http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx
3ED10900-E8FD-C0DE-DE06-35E2D62DB524Supported: Checks for Site Collections with a large amount of SharePoint Groups1, 2http://technet.microsoft.com/en-us/library/cc262787.aspx

Configuration Settings

Rule IDTitleRequired PermissionsDescription
9ECC571A-EBBA-C0DE-DE06-A0AE9B529E0BSupported unique permissions1, 2http://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx#ListLibrary
78B579A4-E244-C0DE-DE06-9399DC13F645The permissions set on the User Information List will cause access denied to anonymous users1, 2
33A8CA67-9771-C0DE-DE06-3FF3A4750358CRL Checking4http://blogs.technet.com/b/lukeb/archive/2011/04/13/sharepoint-delays-crl.aspx
EEA07685-E339-C0DE-DE07-9F7F97AC7E59InetPub moved to separate drive1, 4http://support.microsoft.com/kb/2752331
CA9E9DA7-CEF9-C0DE-DE07-F0D6131F1A23Check for Max Degrees of Parallellism1, 2http://technet.microsoft.com/en-us/library/cc298801(v=office.14).aspx#Section6_3
1748BEEC-7617-C0DE-DE06-9E1E2ED206B7An account is missing from 'Allow log on locally'1,3http://technet.microsoft.com/library/cc756809.aspx
220B7176-A949-4467-86DA-D8E17DD2606BCheck immediate alerts and change log expiration timer jobs1http://technet.microsoft.com/en-US/library/cc678870(v=office.15).aspx
96F32729-D6E2-42A1-B038-8A5AEB6CB6CBChecking PSModulePath environmental variable4
DB2D6406-5155-477A-AB9B-DF5E523AA7C0Check for disabled service accounts1, 4http://technet.microsoft.com/en-us/library/cc781527(v=WS.10).aspx
17F09AA0-78E8-4C83-AAFB-BF293E580E1FCheck time difference between SharePoint Servers and Domain Controllers1
8BD57286-B25C-43AA-B68C-B06721B49C89Check the amount of time before a user token times out1, 3

Database

Rule IDTitleRequired PermissionsDescription
805BCB31-A423-404A-9B42-06D91D687F7ASupported: 200 GB per content database1http://technet.microsoft.com/en-us/library/cc262787.aspx
2F38FD7A-DEED-4D54-8711-8E3DC2301EAADetect databases that require an upgrade1http://technet.microsoft.com/en-us/library/ff607813.aspx
E425A500-35ED-4FB5-8461-C4FD49031155Check the content database for orphaned objects1http://blogs.technet.com/b/nishants/archive/2014/03/23/detect-content-db-orphans-in-a-sharepoint-2010-farm-thru-windows-powershell-updated.aspx
D84F1744-0B7B-4648-B919-D4A146469AE3Check for Symantec tables in the configuration database4http://support.microsoft.com/kb/841057
090E1341-7670-48F6-BA80-518501C0C968Check for DeleteTransactionID statistics in AllUserData table1http://support.microsoft.com/kb/2687453
0A0A4D14-3F86-409C-A6C0-F8E6680CE9D4Check for Data Source Name mismatch3
A8807C93-A607-4825-B97D-1A89F05717F0Check if Data Source Name is accessible3
420F4EBA-5532-455B-9DE6-F6D2E4A54D9FCheck if SQL Server Collation configuration is supported1, 2http://support.microsoft.com/kb/2008668
FE9646E1-BDEB-4960-A04A-F9571430932FCheck content database for outdated statistics1, 2https://support.microsoft.com/en-us/kb/3103194

IIS

Rule IDTitleRequired PermissionsDescription
c67c8509-84c6-4672-9c4d-34cef56da742PageParserPath directives are not configured correctly4http://support.microsoft.com/kb/2659203
3f0d0fe6-dc61-4bce-9a6c-4b476e70de2eCustom ISAPI Filters are listed in IIS4http://msdn.microsoft.com/en-us/library/ms524610(v=VS.90).aspx
85aae3c9-cf71-43b0-82b4-192c217418eeA default ISAPI filter is missing from IIS4http://technet.microsoft.com/en-us/library/cc754174(v=WS.10).aspx
4138961c-03e3-4d93-9aa8-f8a20eeb3cc5No ISAPI filters are listed in IIS4http://msdn.microsoft.com/en-us/library/f4wf4ka6(v=vs.80).aspx
f50e4d49-0cab-43d4-8017-f0f4ea8a055aIsapi-dll is missing in in the IIS configuration4http://technet.microsoft.com/en-us/library/cc771240(v=ws.10).aspx
b0ddf561-1da7-4322-a932-a67288ac18a6PageHandler-Integrated is missing in in the IIS configuration 4http://technet.microsoft.com/en-us/library/cc771240(v=ws.10).aspx
e48e43b2-cc86-446b-a114-6ca162c827b8PageHandlerFactory-Integrated is listed above ISAPI-DLL in the IIS configuration 4http://support.microsoft.com/kb/2659024
4402C39D-7F32-4448-8CD2-91133C7B63CFCheck for application pool recycle settings3http://blogs.msdn.com/b/steveshe/archive/2007/12/23/overlapped-recycling-and-sharepoint-what-are-the-64-bit-settings.aspx
3425a50a-cdd8-41d4-aa89-6512611e7e0fVerify that defaultProvider="AspNetWindowsTokenRoleProvider" if roleManager enabled="true" for CA 1, 4http://support.microsoft.com/kb/2735026
C6F6524B-2BD6-4788-B2DD-E609151A378ACheck for Application Pool password mismatch1, 4http://technet.microsoft.com/en-us/library/ff607826.aspx
3266CE69-EBEB-4D24-83E7-F75301B5025ECheck for enable32BitAppOnWin644http://msdn.microsoft.com/en-us/library/microsoft.web.administration.applicationpool.enable32bitapponwin64(VS.90).aspx
19C5BFBD-6B69-40E6-BD5B-A97EAC7D0088Check for proper configuration of identity impersonation in web.config 1http://support.microsoft.com/kb/979917
967EFFC6-607D-C0DE-DE07-3896CEFF955FSupported Application Pool .NET Framework1, 4http://support.microsoft.com/kb/2807676
5203B8D0-E089-C0DE-DE06-42DC9D73AE77Web Application Batch Compilation1, 4http://blogs.technet.com/b/stefan_gossner/archive/2012/07/23/3509955.aspx
31F03482-5F56-CODE-DE06-09ED192B294CSupport Column Limits1, 2http://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx#Column
9B63EB2E-8951-CODE-DE06-E3C5D56C289BSupported SQL row wrapping for columns1, 2http://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx#Column
2CEC69D9-9222-C0DE-DE06-06942DF190CEMalformed Xml was found in a web.config file1, 4http://msdn.microsoft.com/en-us/library/ms256153(v=vs.90).aspx
02C8BACE-1D7B-C0DE-DE05-36DE92EA674DCGI and ISAPI settings are incorrect1, 4
A5B94575-59C9-4EC4-993F-D97A175E97DAMisssing System.Web.SessionState.SessionStateModule type in modules section Central Admin web config4
45952226-46F1-4867-892D-22914259E9AACheck if Security Token Web Service Exists1, 4http://support.microsoft.com/kb/2493524
648ABBED-FC26-43A9-8AD0-229E4E1558E5Check the Web Services .Net Trust Level1, 4http://support.microsoft.com/kb/815147
FF8CD171-0CFF-4D4A-8528-737FA8CEE8F9Check the SharePoint Web Services availability4http://technet.microsoft.com/library/cc772137(v=WS.10).aspx
6ED6FCB6-8917-4953-8279-8A09944BBA23Detecting if the webgarden is enabled on Sharepoint Servers1http://technet.microsoft.com/en-us/library/cc298550(v=office.12).aspx
78192395-6712-4093-9979-A699BF158D74Check whether the debug=true attribute is set in the web.config file4http://msdn.microsoft.com/en-us/library/s10awwz0.aspx
9075ED01-1E56-461B-A8C2-F049CC13652DSecurity Token Service Application is not online1http://support.microsoft.com/kb/2493524
456E96A9-DD92-4781-9085-2780898D5272Check Kerberos Web Apps for authPersistNonNTLM1, 4http://support.microsoft.com/kb/954873
9AC00049-6457-46EB-895A-35C4984E1E4ACheck Kerberos Web Apps for authPersistSingleRequest1, 4http://technet.microsoft.com/library/gg502606.aspx
c717129a-25d9-4a00-9821-ed7be333f7ee Check if application pools are domain or builtin accounts
1http://gallery.technet.microsoft.com/office/Change-SharePoint-Web-64b872d7
9e7da950-17b0-44c7-8e3c-2af5afe2a1d2 Check for Kernel Mode Authentication for each web application
1,4http://technet.microsoft.com/library/gg502606(v=office.14).aspx
dabf4752-13c0-4970-931f-fcc8636b42b9 Check for AllowAnonymousImpersonation in web.config
1,4http://support.microsoft.com/kb/2686411
B51C5DE1-C7AB-487B-9BE6-D151D656E07DCheck for multiple web app IIS bindings for PowerPivot1, 4http://support.microsoft.com/kb/2712071
B3263CE5-4A11-4AC2-80BE-EBA0C0B4AE27Check for HTTP Keep Alive on Web Apps1, 4http://technet.microsoft.com/library/cc772183.aspx
76C04E55-609E-47A6-96A2-31AAD504DF6ECheck for HTTP Redirect on Web Apps1, 4http://technet.microsoft.com/library/cc732969.aspx
2A6B030D-6425-46FD-8E03-42865DC9462ACheck if Web Services anonymous user identity is IUSR1
FF33E7C-1B80-47F6-9643-F12919E366B2Check for space in HTTP Response Headers1
13D7F8E1-220B-4591-85C0-FEF64E9ECA4FCheck for IIS Directory Browsing1, 4http://technet.microsoft.com/library/cc731109.aspx
450C32A4-225D-460F-9840-9FE16DD2C88ECheck for Require SSL on Web Apps1, 4http://technet.microsoft.com/library/cc732367.aspx
5DDE95FB-2637-4C10-A657-84038614A916Check if Windows Auth Extended Protection is Enabled1, 4
7B092422-5273-4742-A8F4-644A65AE018BCheck if Request Filtering Override is set to Deny4http://msdn.microsoft.com/library/ms689460.aspx
42D9CAA4-08C1-4824-B97F-265A8BE126F2Check for missing Machine Keys in IIS4https://technet.microsoft.com/library/cc731979.aspx
E286A6A8-13E7-4E68-A3BE-C1384F2569F6Check for Deny Authorization Rules in IIS4https://technet.microsoft.com/library/cc772206.aspx
2D56D082-693E-4282-A58A-A121D1446D29Check if W3Svc is running4https://technet.microsoft.com/library/cc734944.aspx

Logging

Rule IDTitleRequired PermissionsDescription
43527ca8-95fb-4b57-b93c-9fdfdcfd90a0Verbose Logging is currently enabled for SharePoint1http://technet.microsoft.com/en-us/library/ee748656.aspx

Miscellaneous

Rule IDTitleRequired PermissionsDescription
4fbfdb96-6647-48af-959c-80b96340e4cdSharePoint 2010 SPDiag in installed1http://support.microsoft.com/kb/2735560
D6BDB2E0-36EC-C0DE-DE06-6AE127D5762EHealth Analyzer errors1, 2http://technet.microsoft.com/en-us/library/ff686788(v=office.14).aspx
c6928b22-7fc3-4dfb-897f-5d58b032388fSupported .Net Framework1, 4http://blogs.msdn.com/b/sharepointdev/archive/2011/07/14/net-framework-support-in-sharepoint-2010.aspx
8282AAB4-6164-4991-A78B-5CDFE4917C4FCheck for expired SharePoint certificates 4http://technet.microsoft.com/library/cc730605.aspx
6243EF65-5671-414E-B3A6-6C0CEC592C19Check if Immediate Alerts Timer job exists1
625B19AB-8053-491A-BE9F-DE008D2B1371Check if Immediate Alerts Timer job has ran within its schedule1
626103B1-404A-4F6C-9CE5-6F5BF52DC53BCheck if Immediate Alerts Timer job schedule is changed from default1
6277E604-4ED0-4B2E-A02D-FF907EEFB952Check if Immediate Alerts Timer job is online and enabled1
D83259F4-E3EB-4DD4-A4CD-94B9320C2205Check if the Mail Drop Folder Exists1, 4
0C8C236A-C8B8-41EC-833A-F1D4D8C1DFA6Check if the SharePoint Farm account has modify permission on the mail drop folder1, 4
27005E36-74D8-401C-9DBF-4BDF82F8FF70Check if Impersonation Level is set to Identify4http://msdn.microsoft.com/library/ms681722.aspx
6A8495B4-993E-4668-A8B5-094F93021FECCheck for installed products mismatch in registry and database1, 4

Patches / Updates

Rule IDTitleRequired PermissionsDescription
A25B487F-0E58-C0DE-DE07-9221FE4101A1MS11-087 Fix it! is installed1http://support.microsoft.com/kb/2639417
03544645-7DB3-45CC-839A-7B1842FCC13CCheck for known issues with Advapi32.dll file version4http://support.microsoft.com/kb/2878378

Search

Rule IDTitleRequired PermissionsDescription
4298BA58-9003-C0DE-DE07-1E720756EF28Sitedata.asmx has been modified1, 4http://msdn.microsoft.com/en-us/library/ms774821(v=office.12).aspx

Security

Rule IDTitleRequired PermissionsDescription
E3BCD45E-00A6-43FB-A930-69800785987BCheck the local farm trust1http://support.microsoft.com/kb/2545744
C595FFB6-2E91-4354-AF5E-5D62513B76E4Check if the Root Certificate of the farm is added to the local certificate store1http://support.microsoft.com/kb/2625048
24CDF5DA-2825-C0DE-DE06-D862BFB067B4An account might be missing from 'Replace a Process-level Token'1, 4http://technet.microsoft.com/library/cc784623.aspx
A0650077-7F64-4EF0-9023-092E9BF90BF2 Check whether the certificate chain takes more than 10 seconds to finish1http://social.technet.microsoft.com/wiki/contents/articles/4954.windows-xp-certificate-status-and-revocation-checking.aspx
DDE88E63-BD4F-4FED-8338-488F6286AEADThe anonymous access account is not set to 'IUSR'4
C561F893-F8A9-4684-85D2-487AFBF877E4Check for FIPS algorithm4http://technet.microsoft.com/library/cc263215.aspx
20A65937-7466-4D30-AB60-696315D0FE82Check User Rights Assignments for 'Replace a Process-level Token'1, 4http://technet.microsoft.com/library/cc784623.aspx
496B9934-D593-4241-B97F-60B96680CEC2Check permission for IISWasKey file1http://support.microsoft.com/kb/977754
74AE6A28-1711-4D83-B6AA-5B5DFC043686Check for BUILTIN\Administrators in farm administrators group1http://technet.microsoft.com/library/cc263291.aspx
ABDC5740-01A7-41F3-B610-9F119EEF7696Check if SharePoint Web Application ports are open in the Windows Firewall1, 4http://technet.microsoft.com/library/dd448559.aspx

Site Collection

Rule IDTitleRequired PermissionsDescription
8afa294c-32c1-41e7-825d-a9296a85ba81More crawl log entries exist than the supported threshold1, 2http://technet.microsoft.com/en-us/library/cc262787.aspx#hierarchy
69472cb0-301c-4a32-a8fd-141df896c02eMore search alerts exist than the supported threshold1, 2http://technet.microsoft.com/en-us/library/cc262787.aspx#hierarchy
effcbc54-f17c-4735-b5aa-36dfb770541fMore Crawl Rules exist than the supported threshold1http://technet.microsoft.com/en-us/library/cc262787.aspx#hierarchy
References
For more information about the Support Diagnostic Tool, click the following article number to go to the article in the Microsoft Knowledge Base:
973559 Frequently asked questions about the Microsoft Support Diagnostic Tool (MSDT) when it is used with Windows 7 or Windows Server 2008 R2
SharePoint Performance Publishing manifest 2010 Diagnostic Package SETH
Properties

Article ID: 2777462 - Last Review: 12/01/2015 22:30:00 - Revision: 54.0

Microsoft SharePoint Server 2010, Microsoft SharePoint Server 2010 Service Pack 1

  • KB2777462
Feedback