[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:



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



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



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:


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


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.


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.


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:


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



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



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:


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


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.


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


Pict. 10 | …Physical Reads and Physical Writes…


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

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


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


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


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.


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