Blog

ULSViewer Filters – Performance Filters

By Scott Kyser
SharePoint, Troubleshooting, ULSViewer

 

By now everyone should know about ULSViewer that is available for download from MSDN, and you also should be familiar with the data filter that comes built into the tool.   If you are not familiar with the ULSViewer you may be using some other log reader that is out there, but I would highly recommend getting use to ULSViewer as it is a powerful, user friendly,  tool.   This blog is about making your life easier to troubleshoot SharePoint issues using the ULS logs and ULSViewer filter.  

One of the  best things I have found with the ULSViewer is the ability to create, save, and reuse a filter.   When you do this, you can bring it to any other ULSViewer and import the filter.  Why is this handy?  This is handy because you may have a common web application, or site that you are trying to troubleshoot and you know exactly what you are looking for but don't like entering in all of the filter fields over and over again.

The following filter is one that I have used many times in performance related issues.   It has a the common stack of performance EventIDs and has saved me many times during troubleshooting performance problem.

 

Tag Description (EventID)


nask             SPRequestMemory leak
c8hq             ECM Object Cache Full Flush - too many changes
8gsc             WSS Template Cache Trim - memory usage exceeds target
avjr              WSS Template Cache Trim - low memory condition
fa43             slow query with duration
fa44             call stack for slow query
tzkv             query text (useful for slow queries and sql exceptions)
tzku             connection string (useful for slow queries and sql exceptions)
8pbe            Watson bucketing parameters
fa45             exception encountered during a sql query
btq8             exception encountered during a sql query
d0d6            exception encountered during a sql query
880i             exception encountered during a sql query

 

So how to do this?

1.) Open ULSViewer and load a ULS log - this gives you the ability to create a filter

Notice:     The EventID are IDs inserted in the ULS directly from the SharePoint source.   In most scenarios this will be a pretty unique ID, however some generic catch-all's will be used and may not be as helpful, but great to Bing!

2.) Open the Filter Tool with the icon directly below the Edit Menu (shown above)

3.) Start creating your filter!

Note:  This will be the hardest part.  Everything will be OK in the end, so start clicking and typing!

Notice:  One thing to note here is the 'Save As', 'Save', and 'Load' button.  This is obviously where you would save, or import your filter for reuse.   Start using this TODAY!

Notice:  Another very cool feature is the ability to Group your AND/OR logic so your filter works as expected.   If you have a grouping set the bar will show on the left side of the filter.

 

4.)  That's It!  You now have created a very useful filter that will help you troubleshoot a lot of performance related problems.

 On a final note, I really love when our customers are proactive in troubleshooting new features or applications in SharePoint.   You could create a AND filter like I have done above to watch for specific sites and see how they are performing when using your new tool, and if they trigger any of the performance EventIDs above when you test them.

 If anyone has a useful filter combination please post it in the comments below and explain how it helped you troubleshoot SharePoint!

 


Scott Kyser

Scott Kyser is the CEO and Co-Founder of SkyNorth Software.  Prior to SkyNorth, Scott enjoyed 9 years at Microsoft where he held various roles supporting SharePoint and Azure. As a Dedicated Premier Field Engineer, he worked with top Enterprise Fortune 500 companies and assisted in proactive reviews, architecture design, software upgrades, migrations, and plenty of trouble-shooting. He was integral to architecting technical solutions, as well as providing world class support and leadership.  In addition to a very successful Microsoft career, Scott brings passion, integrity, and common-sense solutions to the SkyNorth team where he values providing the best solution for technology related business issues.

Company Info

SkyNorth Software LLC
5357 Penn Ave South
Minneapolis, MN 55419

Follow Us

Get the latest news and updates.


© SkyNorth Software LLC