Great MS IT Goodness on Search/Indexing Optimization From SPC

I was looking at the SharePoint Conference Deck from Nick Hardin and Sam Crewdson and found some golden nuggets in their deck as well as in the appendix that likely hasn’t seen the light of day until the DVDs just went out.  Now it’s totally public… like it wasn’t before 🙂
 
I’m a bit supprised some of this hasn’t made it to the blogosphere, but I wanted to give them credit for sharing their findings or at least their gleanings from their own tests, reverse engineering or from their conversations with Devs, PMs, Testers or whoever.
 
I’m sure Corey Burns should get some credit and even Andre Heymann who I’m sitting with in his apartment in Zurich wants some credit.
 
Maximizing Indexing Performance on Servers with 64 bit and 8GB or more RAM.  Improves speed.  (Obviously I have to really caution you since this is registry and you should not do this in production without testing it first, and always remember to back up your registry first!)
 
RegKeyName  RegKey Value (Decimal) Suggested Value (Decimal)
DedicatedFilterProcessMemoryQuota  104,857,600 209,715,200
FilterProcessMemoryQuota  104,857,600 209,715,200
FolderHighPriority 50 500

Reporting samples with LogParser

Looking for Cheap Reporting?  Look no further than the text based log parser.  When you’re ready for real reporting then check out Nintex Reporting 🙂

Top 10 users sorted by alias
logparser.exe "SELECT TOP 10 cs-username, count (*) AS TOTAL from \servernamelogshareW3SVCex080215.log group by cs-username order by TOTAL desc“

Top 100 hits by Username
logparser.exe "SELECT top 100 * from \servernamelogshareW3SVCex080215.log where cs-username like ‘%%username’ order by time desc“

Number of hits by IP Address
logparser.exe "select count (*) as number, cs-host, cs-username, c-ip, cs-uri-stem from \servernamelogshareW3SVCex080215.log group by c-ip, cs-host, cs-username, cs-uri-stem order by number desc“

Number of hits by URL match
Logparser.exe "SELECT count (*) from \sp-sfw-r07e$WWWLogW3SVCex080228.log where cs-uri-stem like ‘%%userprofileservice.asmx’"

Published by

Joel Oleson

I LOVE traveling our little planet. In my quest to visit every country in the world I've got about 35 UN countries left! I'm not just country hopping, but looking for the most immersive cultural experiences and capturing them as photos and videos. Yes, I'm also a geek. I've been recognized as a Microsoft Regional Director, a community leadership award. When not traveling, I'm in paradise in sunny southern California as I'm a Senior IT Manager at Blizzard Entertainment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s