Business Scorecard Manager –SQL ProfilerSamples Overview

These samples will get you up and running with Microsoft Office Business Scorecard Manager 2005 using SQL Server™ 2005 Profiler as a data source. These samples do not connect directly to the SQL Profilerdatabase as they use fixed values. You can however connect the KPIs to SQL Profiler by creating a datamart to save your SQL Profiler results and then use SQL Queries to pull those values into Business Scorecard Manager.

The samples cover many of the measures found within SQL Server Profiler 2005. The sample scorecard includes:

  • CPU Utilization
  • Reads and Writes
  • Durations
  • By Application

Prerequisites

Please visit the Business Scorecard Manager ( for installation prerequisites and installation instructions.

Setup

Unzip Samples:

  1. Unzip the samples to your computer. A good place to install them is with the other samples provided with Business Scorecard Manager. You can extract the files to C:\Program Files\Microsoft Office Business Scorecard Manager 2005\Builder\Samples\SQL Profiler.

Loading Samples Files:

  1. Start Business Scorecard Manager
  2. Click the FOLDER icon More… to open a sample project file.
  3. Browse to the location where you stored the sample scorecard workspaces and double-click a sample file.

Publishing Scorecards:

Load the scorecards into Business Scorecard Manager and use the following steps to quickly publish the sample scorecards.

  1. Load a sample SQL Profiler scorecard sample workspace.
  2. Click the PUBLISH ALL button located on the Business Scorecard Manager toolbar.
  3. Click on the menu item Tools/Deploy Scorecard/To SharePoint.
  4. Click the Specify Scorecard on Server Button.
  5. Browse to Samples/SQL Profiler/[scorecard name] and click OK and then click Nextbutton.
  6. Select the Default View and click Nextbutton.
  7. Enter a page name for the SharePoint page that will be published and click the Next button.
  8. Enter the SharePoint URL. (i.e.
  9. Use the default Document Library and click the Finish button.

Additional Information

Speed up your BSM deployments!

There is nothing better than great documentation to help you deploy BSM faster. The following documents were created with your collaboration andare now customer ready! Do a CONTROL+CLICK to browse the following links.

  • Scorecarding 101: deployment considerations
  • BSM installation: click by click instructions
  • Migrating from BSA to BSM: what’s in it for your customers
  • BSM technical training: 8 free and customer ready web training sessions

Training Kit

  • Introduction
  • BSM Builder Fundamentals
  • BSM Builder Advanced
  • Report Views
  • Scorecard Views

Other Documents

  • Trial Software
  • Intro BSM demo
  • Customer Case Studies
  • Customer Video
  • Press Coverage
  • Analyst Research
  • Data Sheets
  • Technical Whitepapers
  • Business Whitepapers
  • Deployment considerations
  • Click-by-click installation guide

©2006 Microsoft Corporation. All rights reserved.