Server Activity History Report–MDW Report Series Part 4

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 3 of the report series, I showed how to get CPU data from the MDW and display it as a thumbnail chart in the Server Activity History report. In part 4, I’ll show how to extract data from the MDW for the Disk I/O…

4

Server Activity History Report–MDW Report Series Part 3

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 2, I added the hyperlink to the MDW Overview report to launch the Server Activity History report. In this post, I’ll show how to get the data and display the thumbnails in the report for %CPU. I’ll follow up post 4 to include Disk…


MDW Overview Report for Data Collector (Server Activity) – MDW Report Series Part 2

By Bill Ramos, Program Manager, SQL Server Manageability Team In this post, we’ll complete the MDW Overview report from part 1 of this series and then start into the makings of the Server Activity report as shown below. The Server Activity report has 4 major sections that I’ll go through that includes the timeline; server…


MDW Overview Report for Data Collector – MDW Report Series Part 1

By Bill Ramos, Program Manager, SQL Server Manageability Team The Management Data Warehouse (MDW) overview report that I mentioned in my previous blog post on Viewing MDW Reports with a Low Privileged User Account provides a list of database instances and the last collection set upload times for the MDW database. Below is an example…

1

Viewing MDW Reports with a Low Privileged User Account

Just last week, one of our technical sales people asked me the question, when will we release the source RDL files for the Management Data Warehouse (MDW) feature that we shipped with SQL Server 2008. The reason that he asked was that his customer wanted to host the reports on a Reporting Services server so…


New Manageability White Papers for SQL Server 2008

TechNet Books Online just published three whitepapers – check them out! SQL Server 2008 Management Data Warehouse: http://msdn.microsoft.com/en-us/library/dd939169.aspx SQL Server 2008 Policy-Based Management: http://msdn.microsoft.com/en-us/library/dd938891.aspx Understanding and Using PowerShell Support in SQL Server 2008: http://msdn.microsoft.com/en-us/library/dd938892.aspx


DAT315 – Session Review for SSMS Tips & Tricks Session

One of the attendees of my TechEd session “DAT315 – Manageability Series: Uncover Hidden Secrets of T-SQL Scripts with Microsoft SQL Server Management Studio” suggested that I post the list of demos that I did for the session so that they could remember the ah-ha moments. Here we go. Object Explorer Details (OED) The property…

2

PowerShell Script Examples from DAT314

I’d like to thank everyone who attended my TechEd session today titled “Manageability Series: Microsoft SQL Server Automation on Steroids, Including PowerShell Support”. Sean McCown – SQL MVP – and all around DBA – creator of the Midnight DBA videos available at: http://midnightdba.itbookworm.com/ – was kind enough to stop by after the session to point…

1

Welcome to TechEd 2009

This is my first TechEd in a long time. The last time I spoke at a TechEd was back in 1997 in Japan! I have three sessions this Tuesday, Wednesday, and Thursday that talk about how to get the most out of our manageability suite of tools in SSMS.  If you happen to be at…

1

SQLPSX from Chad Miller

I’ve been playing around Chad Miller’s SQL Server PowerShell Extensions – SQLPSX 1.5 on CodePlex getting ready for my TechEd session Manageability Series: Microsoft SQL Server Automation on Steroids, Including Powershell on Wed 5/13. Chad has developed huge library of Powershell cmdlets, functions, and scripts that hit the key scenarios for SQL Server DBAs. All…

1