MS SQL – Performance Dashboard

December 6, 2012

Microsoft is distributing a nice – MS SQL Performance Dashboard which you can use in the SSMS and SSRS.

MS SQL 2005 :

MS SQL 2008 / 2012 :

Getting Started with the Performance Dashboard Reports in SSMS

1. Each SQL Server instance you plan to monitor must contain the procedures and functions used by the queries in the reports. Using SQL Server Management Studio (SSMS), open the Setup.sql Script from your installation directory (default of %ProgramFiles(x86)%\Microsoft SQL Server\110\Tools\Performance Dashboard) and run the script.

Close the query window once it completes.

2. In the Object Explorer pane in SSMS, right mouse click on the SQL Server instance node, then choose Reports-Custom Reports. Browse to the installation directory and open the performance_dashboard_main.rdl file. Explore the health of your server by clicking on the various charts and hyperlinks in the report.

All of the remaining reports are accessed as drill through operations from the main page or one of its children. For a detailed explanation of all installation requirements and guidance on how to use the reports, please see the help file, PerformanceDashboardHelp.chm.

Once installed you can also use it inside of the SSMS – Browse to %ProgramFiles(x86)%\Microsoft SQL Server\110\Tools\Performance Dashboard folder and open the performance_dashboard_main.rdl report.


Getting Started with the Performance Dashboard Reports in SSRS

To get it to work you need to run the SETUP.SQL query in the Master DB. Copy all files from the install directory to your SSRS reports directory. And upload them to the SSRS Reporting Portal.


Create a Shared Data Source in the Report Server !



Once the reports are using the correct data source you can run the main Report to test it.




SharePoint Database Health Dashboard – Bonus

If you are running SSRS in SharePoint Integrated Mode, than you have a nice interface to monitor your database Health.

Just publish the SSRS report to a SharePoint library


And there you go all the data is available per content database.


Enjoy !!

Windows – Understanding Windows at a deeper level

December 6, 2012


Sessions, Window Stations, and Desktops

When trying to access sessions in windows using Win32 API’s. It might be of any interest to look into this article about.

Understanding Windows at A deeper level

  1. A gentle introduction to Sessions
  2. Vista changes how Sessions work
  3. Communication across Sessions
  4. Communication across Desktops
  5. How to circumvent all security

SharePoint – What is it ?

December 5, 2012

According to some “SharePoint is a beast.”

You may think you’re an expert at SharePoint, only to find out later you’re an expert at merely a small aspect of the beast’s capabilities.”

Source :

And I totally agree on this !


Read more here

Outlook – How to create a lot’s of PST Archive sub folders

December 5, 2012

You might have users in the company that have a PST file that has hundreds of folders and subfolders in there.

So re-creating them manually is no option, for a CEO or any other manager !

The trick goes as follows.

Create a new PST using the Import – Export option


Select Export to a file –> Personal PST file


Select the Source PST that has all the folders and subfolders.


Check the “Include Subfoders” option and click Filter


In the filter box select the Date field “RECEIVED” and the condition option select “Tomorrow”. Don’t forget to click ADD to LIST.


Select the Destination PST file are a new on to be created.

This trick will export all mails received tomorrow which is none. And ‘voila’ all your subfolders will appear in the new PST.

SSRS – MS Reporting Services – Recycle times

December 4, 2012

When accessing the SSRS web page the first time in the morning, this can be frustrating that the first users have to wait a long time before they can see the reporting service home page.

Many posts have been logged on the internet about this but there is descend solution except these workarounds

Step 1

Change the <RecycleTime>1440</RecycleTime> in the C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer/rsreportserver.config file.


Don’t forget to restart the reporting service after applying the change.

If this does not help and it won’t ! You will have to move to the final workaround.

Step 2

Make a Powershell script that will restart the service and trigger the reporting service home page.

Stop-Service "SQL Server Reporting Services (MSSQLSERVER)"
Start-Service "SQL Server Reporting Services (MSSQLSERVER)"

$wc = New-Object
$cred = [System.Net.CredentialCache]::DefaultNetworkCredentials
$wc.Credentials = $cred
$src = $wc.DownloadString("http://srvplsk02/Reports/Pages/Folder.aspx")

This will do the job, but again not in our case ! Sad smile

We noticed that even running this script daily at 2 AM it would work throughout the morning for about 8 hours and then again the long wainting time came along.

So a second script was needed to mimic the user activity, which I scheduled every 2 hours.

$wc = New-Object
$cred = [System.Net.CredentialCache]::DefaultNetworkCredentials
$wc.Credentials = $cred
$src = $wc.DownloadString("

Finally everything ran fine so far !! I Can’t understand why this most frustrating event was not fixed by MS in the first place.