[EN] Sunday Market–SharePoint Performance by Idera

Capture_Idera_SharePointPerformance08The second one from my basic package of my customer’s small SharePoint farm is free tool from Idera for monitoring SharePoint application. Of course it’s for free and it’s very simple – but for many reasons (especially when You work on free versions) is enough for the beginners. Because it’s free – has been added for my Sunday market collection (explanation are in my previous post).

The process for getting this solution is as simple as possible (back to my previous post) or follow me.

In this case I’ll show in few pictures almost all functions of Idera product free SharePoint Performance Monitor 2.0. For free download You must:
>> go to Idera SharePoint Performance Monitor 2.0 site HERE
>> fill registration data sheet 
>> check Your mail box for download link

When You get SharePoint Performance Monitor 2.0, it’s time for installation. It’s very simple:

Capture_Idera_SharePointPerformance02

Capture_Idera_SharePointPerformance03

Pic.1&2 | Decompressing installer and Welcome Screen.

Capture_Idera_SharePointPerformance04

Capture_Idera_SharePointPerformance05

Pic.3&4 | Now Read (!) and Accept license agreement, and next choose the installation folder.

Capture_Idera_SharePointPerformance06

Capture_Idera_SharePointPerformance07

Pic.5&6 | Two last steps: Confirm Your “Wish to Install” and Greetings Screen. You can and should check box Launch… 

Now, after installation You can connect to Your SharePoint site, get the data and simply collect some basic info about the farm:

Capture_Idera_SharePointPerformance09

Pic.7 | On first screen You must put address of Your site, and “Friendly Name

Capture_Idera_SharePointPerformance11

Pic.8 | Before You accept – it’s only my advice – click Test ConnectionCapture_Idera_SharePointPerformance12

Pic.9 | If You connection will be in “good condition” You’ll receiving nice message: Connection Test Passed.

Capture_Idera_SharePointPerformance13

Pic.10 | Whoohaa! After connection You can see much of basic data of Your SharePoint site. Full explanation at the and of picture part below.

Capture_Idera_SharePointPerformance14

Pic.11 | In Monitoring and Option part You can customizing all metrics: collecting time, periods; checking response site and host; percentage of usage of memory, processor, application pool usage, requests, site response and alerting. Capture_Idera_SharePointPerformance15

Pic.12 | Small but important part of customizing is about keep running after close and removing from task bar. By default when You close window, You will exit from application (!) Capture_Idera_SharePointPerformance16

Pic.13 | Last but not least customizing option is for alerting: You can specify mail alerting (with or without SSL). It’s really nice to get info about bad health just to mailbox before users.

The standard SharePoint Performance Monitoring You can see three of Your environment monitoring:

  1. SharePoint >> SP status (based on KPI); Current vs Maximum Connections, Site Response Time and better than in previous version of this application info about SharePoint version which is installed on Your host.
  2. Internet Information Services >> IIS status (based on KPI); ASP application Requests per second, ASP Requests Queued vs Rejected and info about IIS, status and ASP version.
  3. Host Server >> Host status (based on KPI); processor usage, memory usage and full info about host server: OS version, processors (physical and logical), memory (physical and virtual)

From my perspective. It’s one of the best and easiest free tool for small companies. Works very well and it’s free. Enjoy!!

[EN] Sunday Market–SQL Check by Idera

Capture_Idera_SQLCheck20Why “Sunday Market”? It’s a beginning of series of short posts about tools which You can use when the shops are closed (as in many countries on Sunday) and You can’t buy any of this… Yes I know in the Internet Era all is possible, but… OK it’s imagination from my strange mind. I want to write from time to time about free tools for SQL Server and SharePoint Server (two my favourite domains).

If You need (like one of my client) something for basic, really basic monitoring Your SQL server Instance, You can use few tools. In this case I’ll show in few pictures almost all functions of Idera product free SQL Check 3.0. For free download You must:
>> go to Idera SQL Check 3.0 site HERE
>> fill registration data
>> checking Your mail box for download link

When You get SQL Check 3.o, it’s time for installation. It’s very simple:
 
Capture_Idera_SQLCheck02

Capture_Idera_SQLCheck03

Pict.1 & 2 | First start the installer, and read and accept license agreement.

Capture_Idera_SQLCheck04

Capture_Idera_SQLCheck05

Pict. 3&4 | Next, choose permissions and place for install and make Your first check: how much place and where You need.

Capture_Idera_SQLCheck07

Capture_Idera_SQLCheck06

Pict. 5&6 | Wait two minutes for end of installation process, and next choose to start application after end, or not, and finish.

Now, after installation You can connect to Your Instance , get the data and simply collect some basic info:

Capture_Idera_SQLCheck09

Pict. 7 | On first – and in fact only one screen – add server

Capture_Idera_SQLCheck10

Pict. 8 | If You do it on SQL server, just log in to default instance (in this case it’s only one) For log in to remote serve , You must write SERVER_NAME\INSTANCE_NAME and log in.

Capture_Idera_SQLCheck16

Pict. 9 | You have five basic counters: Cache Hits…

Capture_Idera_SQLCheck15

Pict. 10 | …Physical Reads and Physical Writes…

Capture_Idera_SQLCheck14

Pict. 11 | …Seek Time Reads and Seek Time Writes…Capture_Idera_SQLCheck13

Pict. 12 | …Waits based on network, writes, reads, locks and cpu…

Capture_Idera_SQLCheck12

Pict. 13 | …and my favourite: Bubbles with the problem of processes

Capture_Idera_SQLCheck17

Pict. 14 | You can see any of five above or all together – as You wish.

Capture_Idera_SQLCheck11

Pict. 15 | And it is full “operational desktop” by this application.Capture_Idera_SQLCheck18

Pict. 16 | If You want, in option You can change default options: refreshing heartbeat graphics and show heartbeat graphics. Default are 2 sec / 120 sec.

Capture_Idera_SQLCheck19

Pict. 17 | When You refreshing view, for a moment You’ll need a minimum of patience… 5 seconds.

All limitation which You must know:

  • one monitored server at time
  • documentation only online on FAQ site
  • no agents required