Monthly Archives: July 2013

Developers Dahboard 2013

Posted by Jim on July 31, 2013
SharePoint 2013 / Comments Off on Developers Dahboard 2013

Type below commands in Powershell

$service = [Microsoft.SharePoint.Administration.SPWebService]::ContentService $addsetting =$service.DeveloperDashboardSettings $addsetting.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::On $addsetting.Update()
Make it OnDemand
$service = [Microsoft.SharePoint.Administration.SPWebService]::ContentService $addsetting =$service.DeveloperDashboardSettings $addsetting.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::OnDemand $addsetting.Update()
Turn Off
$service = [Microsoft.SharePoint.Administration.SPWebService]::ContentService $addsetting =$service.DeveloperDashboardSettings $addsetting.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::Off $addsetting.Update()
Or the old way with STSADM:

Designers Dashboard feature

stsadm -o setproperty -pn developer-dashboard -pv on

stsadm -o setproperty -pn developer-dashboard -pv off

Install with RTM version

Posted by Jim on July 22, 2013
SharePoint 2013 / Comments Off on Install with RTM version

“Sorry, something went wrong, you can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels” Error in SharePoint 2013 health data collection.

Wednesday, June 19, 2013

​When doing an install with SharePoint 2013 usage and health data collection reports I got the following error,

Sorry, something went wrong,

You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

By checking the error in Google I have found the solution. By updating the Stored Procedure in SQL server, we can fix the error. Here are the steps to fix the issue,

  • Open SQlServer Management Studio where SharePoint installed.
  • Open WSS_Logging DB
  • In the Programmability select Stored Procedures
  • Select dbo.proc_GetSlowestPages Stored Procedure, Right Click on it, Select “Modify”
  • In the code, search for “WITH (READPAST)” and comment it as /* WITH (READPAST)​ */
  • Run the Stored Procedure and run health data collection in SharePoint 2013.

The biggest question is why MS can’t fix this with patches or hot fixes …………!!!!!