Monday, November 28, 2016

SharePoint Farm Performance Monitoring Tool

Sam's SharePoint Performance Monitoring Tool V2.0



Click here to read more on features.


Click here to download the V2.0. Read help.txt to start using the tool.




Post you feedback in the comment section.

V2.0 Start Page:







Sam's SharePoint Farm Monitoring Tool V1.0

Sam's SharePoint Farm Monitoring Tool is to monitor SharePoint 2010 and SharePoint 2013 farm servers and indicate to take action against the objects.


V1.0 Screenshot:




 Features

   Applicable to: SharePoint 2010 and SharePoint 2013 Farm

   1. Monitor SharePoint Servers in the Farm
   2. Monitor IIS
   3. Monitor Database Connection and SQL server
   4. Monitor Network and Domain Controller
   5. Monitor SharePoint Objects
   6. Verify State of Server, IIS, Database and Network objects and show the                      indicator to take action.
   7. Administration Panel

Benefits

  1.      Monitor SharePoint Performance
  2.       Run this tool in any machine from the network.
  3.       Monitor all the Server objects without login to each server.
  4.       Easy to Monitor Large SharePoint Farms (More than 10 servers)
  5.       Monitor SharePoint farm from your own desktop
  6.       Indicator will show to take action against objects
  7.       Tool is fast and robust because of PowerShell calls and asynchronous operations.
   8.     Live Monitoring (Coming soon)
   9.     Auto Refresh feature
 10.     Proper Error Handling
 11.      Monitor all the servers in the farm on one click by filling the Farm Sheet(as like below).













For more information please click here.If you would like to test the tool, please request in comment section.

Answer to your feedback:

  • Where can you run this tool ?
    • You can run this tool from anywhere in your network. Because everything is powershell call and I hope every machine has windows powershell installed(in-built with OS). 
    • But if your machine/laptop in running in a Domain(let's say North America) and your SharePoint servers are hosted in a Western Europe domain, then I would recommend to run this tool in the same domain where your SharePoint servers are hosted to monitor it faster/quicker. Otherwise it will be slow because of network bandwidth.
    • But one of biggest advantage of using powershell calls is that: If you are running this tool for the 1st time for any test, it will take time as it takes, but if you run the same test again and again, it will be faster. Because I believe by the time, connection between your machine and SharePoint servers was established on the 1st test, so it only checks server objects.
  • Is there any possibility to enable Auto Refresh ?
    • Yes, I have uploaded the latest build exe (1.1) where you can find Auto Refresh feature.
  • Is there any possibility for live monitoring ?
    • There is no live monitoring, you can enable Auto Refresh feature to test on certain intervals.
    • Latest Update: Live Monitoring for CPU is ready. I will publish it very soon.
  • EXE doesn't run on my 64bit windows 8.1 version ?
    •  please change the Compatibility of the EXE file to Windows 7. Follow the link to change.
  • Alternative way, if you are somehow unable to test using excel sheet

    • you can click on Admin Panel(top right corner and put your servers with comma) to do the Test. See the steps here for your reference.
  • Didn't see a option to run as farm admin account
    • You need to hold Shift key and right click on the EXE -> Click on Run as different user -> Put your farm account credentials.

Saturday, September 17, 2016

File Migration System in SharePoint 2007



Open the below link for the source code.

FMS

If you would like to test the tool, please send a request to samarendraswain@gmail.com

Welcome User WebPart

Open the link for detail information.

Manage IIS in SharePoint 2010 Using PowerShell Script

On your day-to-day activity as a SharePoint Administrator, you always need to monitor web sites, application pools in your SharePoint farm. Especially after the application deployments, I see there are many times, these websites and application pools got stopped in many servers and you need to login to each and every server and verify them and start them.

Here I have developed the below scripts where you do not need to login to each server, you just need to login to any one server in a farm and execute the below scripts which will remotely verify the websites, application pools and show you the results. There is also a possibility to start them if anything is stopped in any server in the farm.

Especially if you have a large SharePoint farm with multiple WFE servers, it will be very helpful to manage from one server. You do not need to login each server and manage them. You can save a lot of time!

Additionally there are two scripts to restart IIS and SharePoint services in the whole farm.  

Steps to follow:

Login to any server in Farm - > Copy the attached zip file and extract it -> Open SharePoint 2010 Management Shell -> Execute the below ps1 files.

Note: You will find Sam.Functions.ps1 file which contains below functions definitions.
  • Get all the Application Pools which are stopped in the SharePoint 2010 Farm
         .\Sam.GetAppPoolStatusOnFarm.ps1
  • Start the Application Pools which are stopped in the SharePoint 2010 Farm
         .\Sam.StartStoppedAppPoolOnFarm.ps1
  • Get all the web sites which are stopped in the SharePoint 2010 Farm
         .\Sam.GetWebsitesStatusOnFarm.Ps1
  • Start all the web sites which are stopped in the Farm(If Default web site is stopped in a server, then it will skip that server)
         .\Sam.StartStoppedWebSitesOnFarm.ps1
  • Restart IIS in all servers in the SharePoint 2010 farm
         .\Sam.RestartIISOnFarm.ps1
  • Restart SharePoint services in all servers in a SharePoint 2010 farm
         .\Sam.RestartSharePointServicesOnFarm.ps1

Note: For start/restart scripts, it will ask to you confirm(yes/no) in powershell window before it execute. So that you can take a decision before execute them.

Hope you like it!

Please find attached zip file containing all script files.

Please post your comment/feedback/questions.


Friday, September 16, 2016

SharePoint Site Monitoring Tool

Sam's SharePoint Site Monitoring Tool V2.0



Click here to download the tool.


New Features in SharePoint Site Monitoring Tool V2.0
  • Test a SharePoint site from selected WFE servers.
  • Test a SharePoint site with Server Load Balancing(in case of multiple WFE servers).
  • Test a SharePoint site and verify the test properties. Please see below for test properties.
  • Test a SharePoint site and export the test properties.
  • Test a SharePoint site and get the SharePoint GUID which helps in finding detailed information from SharePoint ULS log. 
  • Use auto-generated Merge-SPLogFile Command(from test properties) to run directly in SharePoint farm to get the test specific logs(merge log file). 
  • Use the same merge log file to get the execution time of each function using Log Parser Command(from detailed properties) which may help is finding the actual root cause of the application performance.
  • Browse a SharePoint site from a specific WFE server to verify the source(html/text) in Text View Tab.
  • Browse a SharePoint site from a specific WFE server to verify the UI in Browse Tab.
  • Type a command to perform Ping operation.
  • Type a command to perform NSLOOKUP operation.
  • Clear internet explorer cache.
  • Perform Flush DNS.


Test Properties
    
Property NameProperty Value
Server NameSPSERVER01
Date2/4/2017 7:02
ContentTypetext/html; charset=utf-8
MethodGET
Is Mutually AuthenticatedFALSE
Protocol Version1.1
ServerMicrosoft-IIS/7.5
Status CodeOK
Status DescriptionOK
SharePoint Version14.0.0.7192
SharePoint Correlation IDdf1464ed-e6c7-4525-8b30-50h3ea7871da
SharePoint Health Score0
AuthenticationNTLM
Persistent AuthTRUE
Content Length126521 Bytes
ASP.Net Version2.0.50727
Absolute Path/Default.aspx
Absolute Urihttp://hr.sharepoint.com/Default.aspx
DNS Safe Hosthr.sharepoint.com
IsLoopbackFALSE
HostNameTypeDns
IsFileFALSE
Port80
Schemehttp
User Info
IsFileFALSE
Cookies Count0
Number of SharePoint WebParts6
Load Time in Second3.5754414
Merge-SPLogFileCommandMerge-SPLogFile -Correlation 'df1464ed-e6c7-4525-8b30-50h3ea7871da' -StartTime '02/04/2017 07:02:06' -EndTime '02/04/2017 07:03:06' -Path 'C:\SPULSlog_df1464ed-e6c7-4525-8b30-50h3ea7871da.txt'
LogParserCommandForExecutionTimeOfEachFunctionSELECT Top 5000 Message FROM 'C:\SPULSlog_df1464ed-e6c7-4525-8b30-50h3ea7871da.txt' where Message like '%Execution Time=%'

Sam's SharePoint Site Monitoring Tool V1.0

Please click here to download the V1.0 tool. Post your questions in comment section

Or

Download Link: https://drive.google.com/file/d/0B4CB5bnIlui7WldwU3JoZWpsNk0/view?usp=sharing

SharePoint Site Monitoring tool is to monitor the sites from each Web Front End(WFE) server and show you the results.

Features:
  • Test a SharePoint site from each WFE server.
  • Test multiple SharePoint sites from each WFE server.
  • Test a SharePoint site from a specific WFE server.
  • To know more click here.
If you would like to get the source code, please request in comment section.

Demo Screenshots.

Test a site:

Unexpected Error:

Watch the video for Version 1.0...............


-Samarendra Swain

Sam's SharePoint ULS Log Analyzer Tool

SharePoint ULS Log Analyzer Tool analyse ULS logs in a easy and simple way ! It has many more filters which helps SharePoint developers...