Display OS Wait Stats Information

Hello,

Just finished a script that will show the top 10 OS wait states. This is helpful in determining the issue with SQL server.

For more information, check out Brent Ozar's site http://www.brentozar.com/sql/wait-stats/ where he give more information on this topic.

I hope you find it helpful.

Rudy

Download script here: https://docs.google.com/file/d/0B07PMQYOhF2DNnBkZmlUeTNFSTA/edit?usp=sharing

Convert an SSRS Report to .RDL for Editing

Hello Again,

How to copy / export an existing SSRS report for editing is a common question DBAs get asked. Here is a link that explains this easy process.

http://lukehayler.com/2010/02/download-reports-rdl-files-for-editing-4/

If the link is not available, below are the steps to take.

1. Open SQL Server Management Studio,
2. Log on to the Reporting Services Instance that contains the reports you are looking for
3. Browser through the directory structure to the report that needs to be updated
4. Right-click the report and choose Edit…
5. Now follow the prompts to save the file to a destination of your choice
6. Open BIDS & create a new project/solution
7. Import the saved .rdl file into your SSRS project.
8. Edit your content

 This process is great if you don't have the project or .rdl file but can access the report.

Thanks,

Rudy