Home
%3CLINGO-SUB%20id%3D%22lingo-sub-571562%22%20slang%3D%22en-US%22%3EMy%20List%20of%20SharePoint%20troubleshooting%20tools%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571562%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Oct%2030%2C%202014%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3ENetmon%20or%20your%20favorite%20Network%20Sniffer%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ESharePoint%20is%20a%20website%2C%20and%20there%20is%20lots%20of%20communication%20that%20goes%20across%20the%20network%20between%20Client%2C%20App%20Servers%2C%20Web%20Servers%2C%20Active%20Directory%2C%20DNS%2C%20and%20SQL.%26nbsp%3B%20I%20would%20recommend%20this%20is%20installed%20on%20all%20servers%20and%20be%20prepared%20to%20run%20it%20in%20multiple%20locations%20at%20once.%26nbsp%3B%20You%20can%20download%20Netmon%203.4%20from%20%3CA%20href%3D%22http%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D4865%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D4865%20%3C%2FA%3E%20and%20you%20can%20read%20up%20on%20it%20more%20from%20%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F812953%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F812953%20%3C%2FA%3E%20.%20%3CBR%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EULS%20Viewer%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThere%20are%20a%20few%20out%20there%20but%20my%20preferred%20is%20the%20Microsoft%20one%20(And%20yes%20I%20have%20tried%20the%20others%20but%20they%20are%20missing%20things%20that%20I%20like)%20you%20can%20download%20it%20from%20%3CA%20href%3D%22http%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D44020%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D44020%20%3C%2FA%3E%20.%26nbsp%3B%20You%20can%20either%20connect%20it%20to%20live%20servers%20or%20copy%20ULS%20logs%20to%20your%20PC%20and%20review%20there.%26nbsp%3B%20Does%20not%20need%20to%20be%20on%20server%2C%20in%20fact%20I%20recommend%20you%20have%20it%20on%20your%20PC.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EEvent%20Viewer%20logs%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EI%20often%20will%20review%20the%20application%20and%20system%20logs%20quickly%20to%20see%20if%20there%20is%20an%20issue%20with%20the%20underlying%20OS%20or%20if%20SharePoint%20has%20raised%20an%20issue%20into%20these%20logs.%26nbsp%3B%20(Recommend%20you%20don%E2%80%99t%20spend%20much%20time%20here%2C%20but%20quickly%20go%20thru%20them.%26nbsp%3B%20Creating%20a%20PowerShell%20script%20to%20collect%20those%20logs%20would%20be%20a%20great%20use%20of%20time)%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EUsing%20the%20Get-Eventlog%20Cmdlet%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fee176846.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fee176846.aspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EEvent%20Log%20Grabber%20v1%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fpowershell.com%2Fcs%2Fmedia%2Fp%2F14058.aspx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fpowershell.com%2Fcs%2Fmedia%2Fp%2F14058.aspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EPerfmon%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThis%20tool%20is%20built%20into%20all%20current%20Operating%20Systems%20and%20will%20monitor%20the%20performance%20of%20hardware%20and%20software%20on%20local%20or%20remote%20machines.%26nbsp%3B%20For%20SharePoint%20there%20are%20recommended%20counters%20that%20you%20should%20monitor%2C%20please%20see%20the%20following%20article%20for%20those%20counters.%26nbsp%3B%20Remember%20it%20is%20just%20as%20important%20to%20monitor%20SQL%20as%20it%20is%20to%20monitor%20your%20Application%20servers%20and%20Web%20Front-ends.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EMonitoring%20and%20maintaining%20SharePoint%20Server%202013%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fff758658(v%3Doffice.15).aspx%23configuring%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fff758658(v%3Doffice.15).aspx%23configuring%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EFurther%20to%20this%20there%20are%20several%20Search%20counters%20you%20can%20monitor%20if%20you%20think%20search%20is%20an%20issue.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EPAL%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ENow%20that%20you%20have%20you%20perfmon%20logs%20with%20the%20counters%20you%20need%20it%E2%80%99s%20time%20to%20start%20reviewing%20them%20and%20figuring%20out%20where%20the%20problem%20is%2C%20anybody%20who%20has%20ever%20read%20thru%20these%20logs%20knows%20they%20are%20a%20mess%20and%20takes%20a%20lot%20of%20practice%20to%20read%20them%20properly.%26nbsp%3B%20The%20tool%20can%20be%20downloaded%20from%20%3CA%20href%3D%22http%3A%2F%2Fpal.codeplex.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fpal.codeplex.com%20%3C%2FA%3E%20and%20is%20a%20quick%20first%20step%20it%20allows%20you%20to%20see%20at%20a%20general%20level%20where%20you%20might%20have%20a%20problem%20and%20then%20using%20the%20perfmon%20logs%2C%20technet%2C%20and%20probably%20one%20of%20the%20other%20tools%20you%20can%20go%20deeper%20to%20figure%20out%20the%20precise%20issue.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EDebugDiag%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EWhile%20I%20don%E2%80%99t%20often%20get%20Memory%20dumps%20in%20my%20troubleshooting%20steps%2C%20it%20has%20occurred.%26nbsp%3B%20If%20you%20do%20not%20have%20an%20engineer%20who%20is%20knowledgeable%20in%20using%20WinDbg%20and%20reading%20dumps%2C%20then%20debugdiag%20can%20help%20you%20to%20collect%20and%20analyze%20memory%20dumps%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EProcess%20Explorer%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EIf%20you%20need%20to%20know%20what%20a%20process%20is%20doing%20this%2C%20can%20give%20you%20a%20quick%20insight%20hopefully%20removing%20the%20need%20to%20perform%20memory%20dump.%26nbsp%3B%20I%20have%20used%20this%20several%20times%20for%20search%20and%20web%20front%20end%20activities%2C%20with%20great%20results.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EProcess%20Explorer%20v16.04%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Fsysinternals%2Fbb896653.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Fsysinternals%2Fbb896653.aspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EPSSDiag%2FSQLDiag%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EDepending%20on%20the%20version%20of%20SQL%20you%20will%20want%20to%20use%20one%20version%20or%20the%20other.%26nbsp%3B%20The%20tool%20collects%20many%20different%20pieces%20of%20data%20including%20things%20like%20SQL%20Profiler%20trace%20which%20are%20extremely%20helpful%20in%20troubleshooting%20SQL%20issues.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EHow%20to%20use%20SQLDiag%2C%20SQLNexus%20and%20PAL%20tools%20to%20analyze%20performance%20issues%20in%20SQL%20Server%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fb%2Fpamitt%2Farchive%2F2011%2F02%2F25%2Fhow-to-use-the-sqldiag-the-sqlnexus-and-the-pal-tools-to-analyze-performance-issues-in-sql-server.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fb%2Fpamitt%2Farchive%2F2011%2F02%2F25%2Fhow-to-use-the-sqldiag-the-sqlnexus-and-the-pal-tools-to-analyze-performance-issues-in-sql-server.aspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EPssdiag%20and%20Sqldiag%20Manager%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fdiagmanager.codeplex.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fdiagmanager.codeplex.com%2F%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ESQL%20Diag%20Configuration%20Tool%20(SDCT)%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fsdct.codeplex.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fsdct.codeplex.com%2F%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-571562%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Oct%2030%2C%202014%20Netmon%20or%20your%20favorite%20Network%20SnifferSharePoint%20is%20a%20website%2C%20and%20there%20is%20lots%20of%20communication%20that%20goes%20across%20the%20network%20between%20Client%2C%20App%20Servers%2C%20Web%20Servers%2C%20Active%20Directory%2C%20DNS%2C%20and%20SQL.%3C%2FLINGO-TEASER%3E
First published on TECHNET on Oct 30, 2014

Netmon or your favorite Network Sniffer


SharePoint is a website, and there is lots of communication that goes across the network between Client, App Servers, Web Servers, Active Directory, DNS, and SQL.  I would recommend this is installed on all servers and be prepared to run it in multiple locations at once.  You can download Netmon 3.4 from http://www.microsoft.com/en-us/download/details.aspx?id=4865 and you can read up on it more from http://support.microsoft.com/kb/812953 .



ULS Viewer


There are a few out there but my preferred is the Microsoft one (And yes I have tried the others but they are missing things that I like) you can download it from http://www.microsoft.com/en-us/download/details.aspx?id=44020 .  You can either connect it to live servers or copy ULS logs to your PC and review there.  Does not need to be on server, in fact I recommend you have it on your PC.



Event Viewer logs


I often will review the application and system logs quickly to see if there is an issue with the underlying OS or if SharePoint has raised an issue into these logs.  (Recommend you don’t spend much time here, but quickly go thru them.  Creating a PowerShell script to collect those logs would be a great use of time)


Using the Get-Eventlog Cmdlet


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


Event Log Grabber v1


http://powershell.com/cs/media/p/14058.aspx



Perfmon


This tool is built into all current Operating Systems and will monitor the performance of hardware and software on local or remote machines.  For SharePoint there are recommended counters that you should monitor, please see the following article for those counters.  Remember it is just as important to monitor SQL as it is to monitor your Application servers and Web Front-ends.


Monitoring and maintaining SharePoint Server 2013


http://technet.microsoft.com/en-us/library/ff758658(v=office.15).aspx#configuring


Further to this there are several Search counters you can monitor if you think search is an issue.



PAL


Now that you have you perfmon logs with the counters you need it’s time to start reviewing them and figuring out where the problem is, anybody who has ever read thru these logs knows they are a mess and takes a lot of practice to read them properly.  The tool can be downloaded from http://pal.codeplex.com and is a quick first step it allows you to see at a general level where you might have a problem and then using the perfmon logs, technet, and probably one of the other tools you can go deeper to figure out the precise issue.



DebugDiag


While I don’t often get Memory dumps in my troubleshooting steps, it has occurred.  If you do not have an engineer who is knowledgeable in using WinDbg and reading dumps, then debugdiag can help you to collect and analyze memory dumps



Process Explorer


If you need to know what a process is doing this, can give you a quick insight hopefully removing the need to perform memory dump.  I have used this several times for search and web front end activities, with great results.


Process Explorer v16.04


http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx



PSSDiag/SQLDiag


Depending on the version of SQL you will want to use one version or the other.  The tool collects many different pieces of data including things like SQL Profiler trace which are extremely helpful in troubleshooting SQL issues.


How to use SQLDiag, SQLNexus and PAL tools to analyze performance issues in SQL Server


http://blogs.msdn.com/b/pamitt/archive/2011/02/25/how-to-use-the-sqldiag-the-sqlnexus-and-the-p...


Pssdiag and Sqldiag Manager


http://diagmanager.codeplex.com/


SQL Diag Configuration Tool (SDCT)


http://sdct.codeplex.com/