List

So, I just rolled SharePoint 2016 into a test environment and launch Central Admin, and the first thing my eyes land on is the dreaded yellow bar (at least it’s not red) that nightmares are made of. Just like notification badges on app icons on my phone, they indicate that I have left something unfinished or that there is more to do. These things drive me insane! Not wanting to leave things unfinished, I click the link, to find only two entries. The second being a drive space warning and with a 100GB C: partition and 40GB free, I’ll move the pagefile to the D: partition and let Windows manage it. Poof! It’s gone.

The first one was more troubling… ‘Search – One or more crawl databases may have fragmented indices’ After a quick peek at the Search Service Administration and receiving the ‘All good here’ green check marks, i decided to make travel arrangements. I’m off to see the SQL, la lala la lala la la! So, I open up SSMS, expand the databases and start checking the indices on the crawl store database tables for fragmentation. How an index gets to 85%+ fragmented during a clean install, I’ll never know… The ones that were fragmented were quickly rebuilt and I even bounced the SharePoint server for good measure.

After auto-repairing and re-analyzing the SharePoint health monitor job, the notification has been addressed and dreaded yellow bar has disappeared!

As a side note:

Should any SharePoint-ers out there run into this, you may need to check the indices on the crawl related tables in the following databases:

  • Search
  • Search Analytics Reporting Store
  • Search Crawl Store
  • Search Link Store

Happy SharePoint-ing!

The SharePoint Sheriff

  Posts

February 14th, 2018

Invincible workflows

Today I encountered a list item that had two instances of the same workflow, both stuck on the first step. […]

May 17th, 2017

The case of the missing App Launcher

Today I deleted and recreated a SharePoint 2016 Web application and recreated it, without issue. Well, except that the new […]

March 10th, 2017

The server failed to process the request. Aka, the SharePoint version of PCLoadLetter

It’s Friday so I’ll keep this short The ongoing power struggle between SharePoint and it’s tamers continues. Today we’re faces […]

March 3rd, 2017

Search, search, search, all the day long…

So, I just rolled SharePoint 2016 into a test environment and launch Central Admin, and the first thing my eyes […]

May 5th, 2016

Oh, happy day!

SharePoint 2016 has been released to MSDN! Time to practice different upgrade strategies and see what this baby can do! […]

March 29th, 2016

Branding Gone Wild

Today I ran into a problematic sub-site in my SharePoint 2013 farm. This sub-site, named “Test”, was where I had […]

March 14th, 2016

SharePoint 2016 RTM Released Today

Today marks the beginning of the next chapter for SharePoint as Microsoft released SharePoint 2016 RTM today. Ready to get […]

October 13th, 2015

A SharePoint game of hide and seek!

Today I was tasked with creating a custom list. Pretty normal so far, right? Here’s where it gets interesting. The […]

October 9th, 2015

My first Hadoop install.

So, I built my first single node Hadoop cluster today using Ubuntu 14.04 LTS, Hadoop 2.7.1 and Oracle Java 1.7.0_80 […]

September 3rd, 2015

Creating a date dimension table in MS SQL

TSQL Script #1 – Create dbo.DimDate table 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849BEGIN TRY     DROP TABLE [dbo].[DimDate] END TRY BEGIN CATCH     […]