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 : http://www.microsoft.com/en-us/download/details.aspx?id=22602

MS SQL 2008 / 2012 : http://www.microsoft.com/en-us/download/details.aspx?id=29063

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.

clip_image002

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.

clip_image004

Create a Shared Data Source in the Report Server !

clip_image006

clip_image008

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

clip_image010

clip_image012

clip_image014

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

image

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

image

Enjoy !!

Advertisements

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

What is SharePoint ?

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 : http://blog.fpweb.net/how-to-empty-recycle-bin-sharepoint/

And I totally agree on this !

image

Read more here

http://msdn.microsoft.com/en-us/library/office/gg552610(v=office.14).aspx

http://technet.microsoft.com/nl-be/sharepoint/ee518663.aspx


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

image

Select Export to a file –> Personal PST file

image

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

image

Check the “Include Subfoders” option and click Filter

image

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

image

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.

ReportSeverConfig

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 system.net.webClient
$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 system.net.webClient
$cred = [System.Net.CredentialCache]::DefaultNetworkCredentials
$wc.Credentials = $cred
$src = $wc.DownloadString("
http://yourserver/Reports/Pages/Folder.aspx")

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