View Health / Usage Reports in SharePoint 2013

We can get full detail of Usage within SharePoint Farm.
First we have to enable Logging in Central Administration

Set "Least critical event to report to the event log" as VERBOSE
Set "Least critical event to report to the trace log " as VERBOSE.
All the usage data will be tracked in the farm.

Then go to CA --> Monitoring --> View Health Reports

There we can see "SLOWEST PAGES" section. We can set the FARM and Web Application. When we click GO, it displays an error.

 The error explains the error regarding Database status.

We have to open Database "WSS_Logging". The we have to find the Stored Procedure mapped with the error.

We have to Modify the Stored Procedure. There we have to comment the "WITH (READPAST)" text. 

The Execute it.

Now we can run the report. We can see the full data with Slowest Page URLs and number of requests.

We have to wait some time to get real time data, mainly till the SharePoint timer job runs and collect the data.

Add A WebPart to SharePoint Page Programatically Throws File CheckOut exception

When we add a WebPart to a page, programatically we have to checkout the page.

Even we try to Checkout the file using C# code, it throws the exception.

We have to go to the Document library that resides the required page.
Then go to the Library settings section.

Then go to the Versioning settings Section.
We have to set NO to "Require Checkout" option.

Then Our Webpart will be deployed to the page successfully.