[SDP 5][60293c48-532a-4f9b-93af-9e4199170b35] SharePoint 2013 General performance and reliability diagnostic (SPPerfPub2013)

Summary

This SharePoint Performance and Publishing 2013 (SPPerfPub 2013) manifest is designed to detect certain problematic conditions that may exist in the configuration of a server that's 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 executed. To make sure that you have maximum coverage, we recommend that you run SPPerfPub on every computer in the SharePoint farm.

This article discusses the operation of this manifest file.

Required permissions

The rules in the diagnostic package use the Windows PowerShell snap-in for SharePoint to obtain 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. Be aware 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 permissions to leverage 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
1Use Windows PowerShell cmdlets to interact with the SharePoint farm.Farm administration
2Run queries against SharePoint databases.Farm administration
3Access server administrative tools.Server administrative
4Access files and other resources on the server.Server administrative

More Information

This article describes the information that may be collected from a computer when you run SPPerfPub2013.

Information that is collected

Manifest results

DescriptionFile name
This contains the actual results of the SPPerfPub manifest. This is what is displayed back to the user to indicate that status of each rule that is executedResultReport.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.SPPerfPub2013.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.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_O15SP_FarmEnvironment.txt
This is an xlst transform that formats the results in the %COMPUTERNAME%_SPSFarmReport_%LANG%_O15SP__%time%.xml file. SPSFarmReport.xslt
This file collects the SharePoint farm information. The information that is captured includes the following:
  • Farm general settings
  • Services on servers
  • Installed products on servers
  • Features on servers
  • Custom solutions
  • Service applications
  • Web applications
  • AAMs and authentication providers
  • Content databases
  • Content deployment
<ComputerName>_SPSFarmReport_<locale>_O15SP__<time>.xml
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 Table on disk
  • Top 10 Days by count of rows
  • Top 10 Paths by count of rows 
<ComputerName>_cfg_<locale>_O15SP_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 documents versions
<ComputerName>_cfg_<locale>_O15SP_DocVersionsReport.txt
This file contains a summary of the Distributed Cache settings. The information in this file includes the following: 

  • Get-AFCacheClusterHealth
  • Get-SPDistributedCacheClientSetting
  • Get-CacheStatistics
  • Get-AFCacheConfiguration
  • Get-CacheHost
  • Get-CacheHostConfig
  • Get-AFCacheAllowedClientAccount
  • Get-SPServiceApplicationPool
  • Get-SPServiceInstance -TypeName Distributed Cache
  • Get-SPServiceApplication -TypeName User Profile Service Application
  • Get-SPServiceInstance -TypeName User Profile Service
  • Get-SPTimerJob -TypeName Microsoft.Office.Server.ActivityFeed.ActivityFeedUPAJob
<ComputerName>_cfg_<locale>_O15SP_DistributedCacheReport.txt

Caching

Rule IDTitleRequired permissionsDescription
8B2B2A65-1FA3-4597-B217-73318182A8CE
Disk-based cache at critical capacity 4http://technet.microsoft.com/en-us/library/cc770229.aspx
071A5E86-5193-49C1-A332-C08FD5118238
Check Portal Super Reader Account Configuration for Claims Based Web Apps 4http://technet.microsoft.com/en-us/library/ff758656.aspx

Capacity planning guidelines

Rule IDTitleRequired permissionsDescription
38BB68F6-7EAC-420F-852E-5A020C366575Check the number of Crawl Mappings1http://technet.microsoft.com/en-us/library/cc262787.aspx
EFFCBC54-F17C-4735-B5AA-36DFB770541FCheck the number of Crawl Rules1http://technet.microsoft.com/en-us/library/cc262787.aspx
3FADCA3A-DA90-49E3-BAD9-61F146329F9CCheck for number of content databases1http://technet.microsoft.com/en-us/library/cc262787.aspx
D4B272DD-5DB9-47CB-9FAB-3CF3224EB916Check for number of items per folder in the list or library2http://technet.microsoft.com/en-us/library/cc262787.aspx
8AD5B2D2-2932-468E-B6CF-8F29F3B39D30Check the number security principals added to SharePoint groups2http://technet.microsoft.com/en-us/library/cc262787.aspx
557DE93D-E86D-49E1-8239-8642781FA27FCheck the number of Index Partitions1http://technet.microsoft.com/en-us/library/cc262787.aspx
7B31CDF4-4612-4968-A6BC-E106A63DDD9CCheck Item Count of Lists and Libraries1http://technet.microsoft.com/en-us/library/cc262787.aspx
7BF1F8F9-16F4-41D4-BC74-67F6BEB638BFCheck the list view threshold setting1http://technet.microsoft.com/en-us/library/cc262787.aspx
80FCC287-E150-4C90-B24D-BC3402F1712DCheck the list view lookup threshold setting1http://technet.microsoft.com/en-us/library/cc262787.aspx
E7E40739-90C0-4228-BED9-0C8DED1D302FCheck for number of managed paths per web application1http://technet.microsoft.com/en-us/library/cc262787.aspx
DEE2C14A-A2A8-4274-8908-962D0108C699Check the number of Managed Properties1http://technet.microsoft.com/en-us/library/cc262787.aspx
19FDA642-93D3-4D1C-BE89-0B9E80D43E13Check total number of terms and term sets2http://technet.microsoft.com/en-us/library/cc262787.aspx
15459C6E-7195-48C6-BDD3-AE2B2288ADC4Check the total number of terms2http://technet.microsoft.com/en-us/library/cc262787.aspx
D5254485-FBD0-456D-844C-BD81C4ED3DFACheck the total number of term sets2http://technet.microsoft.com/en-us/library/cc262787.aspx
E4DD000D-6D82-4B87-9E15-E8620E293B0ECheck for large Number of Search Service Application1http://technet.microsoft.com/en-us/library/cc262787.aspx
34683B93-483F-4923-BD4E-5671D964F947Check for number of site collections per content database1http://technet.microsoft.com/en-us/library/cc262787.aspx
C52E4AB7-140B-464B-9284-89D414C50267Check the number of sub-sites2http://technet.microsoft.com/en-us/library/cc262787.aspx
3ED10900-E8FD-C0DE-DE06-35E2D62DB524Check for Site Collections with a large amount of SharePoint Groups2http://technet.microsoft.com/en-us/library/cc262787.aspx
EFCE554A-5977-C0DE-DE06-B827E2D1E1D4Check whether there are more than 20 web applications1http://technet.microsoft.com/en-us/library/cc262787.aspx
B4A7071B-7EE7-C0DE-DE06-4546907CF8E3Crawl Components Per Search Application1http://technet.microsoft.com/en-us/library/cc262787.aspx
C29CD08F-E40A-C0DE-DE06-FEB7ECA47CDBQuery Components Per Server1http://technet.microsoft.com/en-us/library/cc262787.aspx
E6F5EE96-5BAC-4CEF-987A-FB7119A9D9FESearch Keywords2http://technet.microsoft.com/en-us/library/cc262787.aspx
98DD9B54-FBD6-C0DE-DE06-8BB832F93758Blog Posts per Site2http://technet.microsoft.com/en-us/library/cc262787.aspx

Configuration settings

Rule IDTitleRequired permissionsDescription
78192395-6712-4093-9979-A699BF158D74
Check whether the 'debug=true' attribute is set in the web.config file 4http://msdn.microsoft.com/en-us/library/s10awwz0.aspx
EF1144F8-7F02-4552-BCB7-C9B4D9C6AF76
Sites fail to upgrade from 2010 1http://technet.microsoft.com/library/ff382641
9ECC571A-EBBA-C0DE-DE06-A0AE9B529E0BSupported unique permissions 1, 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 users 1, 2
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
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
2F38FD7A-DEED-4D54-8711-8E3DC2301EAA
Detect databases that require an upgrade 1http://technet.microsoft.com/en-us/library/ff607813.aspx
4F51675D-8358-C0DE-DE06-E7074F5509BFChecks for orphaned databases in SharePoint1
D84F1744-0B7B-4648-B919-D4A146469AE3Check for Symantec tables in the configuration database4http://support.microsoft.com/kb/841057
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
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, 2chttps://support.microsoft.com/en-us/kb/3103194


Hardware / Software requirements

Rule IDTitleRequired permissionsDescription
8F1C132D-2656-4D8D-9E58-606C0F97B748
Check for minimum hardware configuration 3http://technet.microsoft.com/en-us/library/cc262485.aspx
86CF8E2-A537-4615-9C6A-37FA218E3731Check if AppFabric 1.1 is installed4https://msdn.microsoft.com/library/hh334300.aspx

IIS

Rule IDTitleRequired permissionsDescription
c67c8509-84c6-4672-9c4d-34cef56da742
PageParserPath directives are not configured correctly 4http://support.microsoft.com/kb/2659203
5203B8D0-E089-C0DE-DE06-42DC9D73AE77Web Application Batch Compilation1, 4http://blogs.technet.com/b/stefan_gossner/archive/2012/07/23/3509955.aspx
4402C39D-7F32-4448-8CD2-91133C7B63CF
Check for application pool recycle settings 3http://blogs.msdn.com/b/steveshe/archive/2007/12/23/overlapped-recycling-and-sharepoint-what-are-the-64-bit-settings.aspx
3425a50a-cdd8-41d4-aa89-6512611e7e0f
Verify that defaultProvider="AspNetWindowsTokenRoleProvider" if roleManager enabled="true" for CA1, 4http://support.microsoft.com/kb/2735026
C6F6524B-2BD6-4788-B2DD-E609151A378A
Check for Application Pool password mismatch 1, 4http://technet.microsoft.com/en-us/library/ff607826.aspx
3266CE69-EBEB-4D24-83E7-F75301B5025E
Check for enable32BitAppOnWin644http://msdn.microsoft.com/en-us/library/microsoft.web.administration.applicationpool.enable32bitapponwin64(VS.90).aspx
6ED6FCB6-8917-4953-8279-8A09944BBA23
Check for WebGarden configuration 4Best Practice - Documentation is currently being generated
2CEC69D9-9222-C0DE-DE06-06942DF190CEMalformed Xml was found in a web.config file 1, 4http://msdn.microsoft.com/en-us/library/ms256153(v=vs.90).aspx
02C8BACE-1D7B-C0DE-DE05-36DE92EA674DCGI and ISAPI settings are incorrect 1, 4
33A8CA67-9771-C0DE-DE06-3FF3A4750358Checking Certificate Revocation List (CRL) connection3http://blogs.technet.com/b/lukeb/archive/2011/04/13/sharepoint-delays-crl.aspx
DDE88E63-BD4F-4FED-8338-488F6286AEADThe anonymous access account is not set to IUSR1http://support.microsoft.com/kb/2892419
648ABBED-FC26-43A9-8AD0-229E4E1558E5Check the .NET Trust level for SharePoint Web Services1,4http://support.microsoft.com/kb/815147
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
9075ED01-1E56-461B-A8C2-F049CC13652DSecurity Token Service Application is not online1http://support.microsoft.com/kb/2493524
45952226-46F1-4867-892D-22914259E9AACheck whether Security Token Web Service Exists1, 4http://support.microsoft.com/kb/2493524
03778503-CA8E-4FF1-AA25-FAD5A00F5104Check the authentication modes for Security Token Web Service1, 4http://support.microsoft.com/kb/2493524
c717129a-25d9-4a00-9821-ed7be333f7eeCheck whether application pools are domain or built-in accounts
1http://gallery.technet.microsoft.com/office/Change-SharePoint-Web-64b872d7
9e7da950-17b0-44c7-8e3c-2af5afe2a1d2Check for Kernel Mode Authentication for each web application
1,4http://technet.microsoft.com/library/gg502606(v=office.14).aspx
dabf4752-13c0-4970-931f-fcc8636b42b9Check 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
76C04E55-609E-47A6-96A2-31AAD504DF6ECheck for HTTP Redirect on Web Apps1, 4http://technet.microsoft.com/library/cc732969.aspx
B3263CE5-4A11-4AC2-80BE-EBA0C0B4AE27Check for HTTP Keep Alive on Web Apps1, 4http://technet.microsoft.com/library/cc772183.aspx
74B418B9-84CD-491D-9251-A0B6C572FCE5Check SharePoint application pool .Net Framework version1, 4 
2A6B030D-6425-46FD-8E03-42865DC9462ACheck if Web Services anonymous user identity is IUSR1
1FF33E7C-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
E259EEED-8042-492D-95FA-76E5198D859ACheck for asterisk in IIS Site Host Headers1, 4
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
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-9fdfdcfd90a0
Verbose Logging is currently enabled for SharePoint 1http://technet.microsoft.com/en-us/library/ee748656.aspx

Miscellaneous

Rule IDTitleRequired permissionsDescription
4fbfdb96-6647-48af-959c-80b96340e4cd
SharePoint 2013 SPDiag in installed 1http://support.microsoft.com/kb/2735560
D6BDB2E0-36EC-C0DE-DE06-6AE127D5762EHealth Analyzer errors 1, 2http://technet.microsoft.com/en-us/library/ff686788(v=office.14).aspx
67C8E3DF-45A7-C0DE-DE06-857FB5419E3FSharePoint is at a version less than RTM4http://technet.microsoft.com/evalcenter/hh973397.aspx
8282AAB4-6164-4991-A78B-5CDFE4917C4FCheck for expired SharePoint certificates4http://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, 4http://technet.microsoft.com/library/cc263260.aspx
0C8C236A-C8B8-41EC-833A-F1D4D8C1DFA6Check if the SharePoint Farm account has modify permission on the mail drop folder1, 4http://technet.microsoft.com/library/cc263260.aspx
A2EDC3B9-611A-48DA-A379-741E74B05FABCheck if work management service account has access to UPA1
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
D2C42A33-6707-458D-8898-BAC12C10D7ABCheck for distributed cache timeout for ADFS Web Apps1
B14A6BA4-6A56-4992-90C9-5E7FDD205434Check if clienttemplates.js exists within the layouts directory1, 4
5662A2F9-29D5-41B9-BCA3-F516CA98E7BCCheck if SharePoint Guidance Library is deployed1http://msdn.microsoft.com/library/ff649628.aspx

Patches / Updates

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

Security

Rule IDTitleRequired permissionsDescription
2233F30F-EA46-44E0-AD93-D5826C349715
Check for authentication mode attribute 1, 4http://technet.microsoft.com/en-us/library/ee806890.aspx
E3BCD45E-00A6-43FB-A930-69800785987BCheck the local farm trust 1http://support.microsoft.com/kb/2545744
C595FFB6-2E91-4354-AF5E-5D62513B76E4
Check whether the Root Certificate of the farm is added to the local certificate store 1http://support.microsoft.com/kb/2625048
A0650077-7F64-4EF0-9023-092E9BF90BF2
Check whether the certificate chain takes more than 10 seconds to finish 1http://social.technet.microsoft.com/wiki/contents/articles/4954.windows-xp-certificate-status-and-revocation-checking.aspx
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

References

973559 Frequently asked questions about the Microsoft Support Diagnostic Tool (MSDT) when it is used with Windows 7 or Windows Server 2008 R2  
属性

文章 ID:2776818 - 上次审阅时间:2015年12月1日 - 修订版本: 1

反馈