Chapter 1: Understanding a Least Privileged SharePoint Build This chapter is an introductory discussion about the key settings to a good build 1.1 Key decisions in planning a least privileged farm and how this plays into resolving issues. 1.2 Use of AutoSPInstaller and PowerShell to least privilege a farm and a prepper on PowerShell 1.3 Determining if a farm is least privileged 1.4 Avoiding over privileging 1.5 Testing connectivity and firewalls Chapter 2: Key Settings to a Good Build 2.1 Configuring the Microsoft Distributed Transaction Coordinator and how it impacts errors 2.2 SQL Alias to make your SharePoint portable, in the event of a SQL meltdown 2.3 App fabric garbage collection and distributed cache trouble shooting 2.4 Permissions for Network Service 2.5 Local security for the farm account Chapter 3: Advanced Key Settings to a Good Build This chapter is a wrap-up discussion of the key settings to a good build 3.1 Verifying and working with domain accounts and managed accounts 3.2 IIS WAMREG settings and configuring registry and DCOM settings 3.3 Publishing infrastructure settings 3.4 Logging Locations and level Chapter 4: Files, Virtual Mappings, and IIS Settings In this chapter readers will learn about the files that are added to a windows server and how they affect troubleshooting 4.1 Bring in the files - What happens on the server and in the database when you install a web application. 4.2 IIS File mappings - Examining the SharePoint file system from within IIS. 4.3 IIS File Mappings part 2 - various locations in the SharePoint hive and how they are mapped in IIS. 4.4 Application vs Sites - A look in IIS application pools, sites, bindings, and redirects. 4.5 The SharePoint Root (a.k.a Hive) - The SharePoint Hive, key files and permissions. Chapter 5 title: Database and Security Operations In this chapter readers will learn about SharePoint databases, restore activities, about Logging, security settings in SQL, and various PowerShell operations. 5.1 SQL vs Database Settings - Key SQL settings and Database settings. 5.2 Backup and restore - Using PowerShell and SSMS, backing up sites and databases. 5.3 Unattached restore - getting data out of backed up databases without attaching them to SharePoint. 5.4 Security & Settings - using SSMS and PowerShell to remediate security and interrogate settings 5.5 Logging issues and Distributed cache - how to troubleshoot issues with logging sizes or lack thereof, and issues with distributed cache Chapter 6: Registry, Search, and Cache Configuration In this chapter readers will learn about registry locations, host files, search components, SharePoint databases, and more PowerShell operations; including, but not limited to resetting the config cache 6.1 Registry locations - Various locations in registry that affect SharePoint - Central administration, Distributed Cache, opening sites on the server, host named site collections 6.2 Host files - how they work and how to use in troubleshooting 6.3 Search components - Finding and configuring search using PowerShell 6.4 Finding info about Databases - use PowerShell to find out information about databases. 6.5 Reset IIS and Config Cache - reset IIS and the SharePoint configuration cache on all servers in a farm using Powershell and understand when to do this action Chapter 7: Attaining Key Information About a Farm This chapter demonstrates how to get key info about a farm used in troubleshooting. 7.1 Farm info - get info about the servers in the farm, including uptime, servers in the farm, names of servers, and understanding how this can be useful in troubleshooting. 7.2 Basic commands - msinfo32, compmgmt.msc, appwiz.cpl, IISreset, get-member, and more. Additional PowerShell prepper - Creating Variables, using dot notation. Windows logs - looking through the application log and system log via GUI and PowerShell Solutions in the farm - get the install state, install solutions and export solutions. Event Logs - using PowerShell to query event logs, and using gui Chapter 8: Troubleshooting Services This chapter teaches readers how to use PowerShell and other tools to interrogate what is going on with services and resolve issues 8.1 Search Crawl history - Using the GUI and PowerShell to look at the crawl history 8.2 Search Topology - Using the PowerShell to restructure the Search Topology 8.3 Provisioning and Un-Provisioning Services - use the GUI and Powershell to unprovision 8.4 Finding web.config modifications - use PowerShell to determine if web.config is modified 8.5 Timer Jobs - Finding out if timer jobs are failing, using PowerShell to interrogate 8.6 Log levels - setting log levels with PowerShell Chapter 9: Unified Logging System, Merge-splogfile, and Other PowerShell Friends, Tools Part I In this chapter readers will learn about ULS and Merge 9.1 Merge-SPLogFile - learning the various parameters of this command are key to troubleshooting. 9.2 What is the log saying? - deciphering the ULS logs and various GUIDs, levels. 9.3 ULS Viewer - Sorting, filtering, various views, settings, when and why. Chapter 10: Network Packet Tools and Support, Tools Part II In this chapter readers will learn about ULS and Merge 10.1 PerfMon, ProcMon, 10.2 Wireshark, NetMon, and Fiddler 10.3 IIS log data 10.4 Webalizer and Indihaing 10.5 Developer dashboard - using these tools in troubleshooting. 10.6 MIISClient Chapter 11: Tools part 3 - Understanding the SharePoint Health Analyzer, Tools Part III 11.1 Installing PAL for SharePoint - how to use the PAL results 11.2 Feature Admin Tool 11.3 SharePoint Manager Tool - a look at the SharePoint manager tool and how to use it in troubleshooting 11.4 Storage monitoring at the site collection level