DOCX

Demo Creating a Utility Control Point (UCP)

By Alfred Berry,2014-04-20 22:52
7 views 0
Demo Creating a Utility Control Point (UCP)

Demo Script

    Creating a Utility Control Point (UCP)

Demo version: 1.0.0

    Last updated: 4/20/2012

CONTENTS

    OVERVIEW ............................................................................................................................................. 3 Key Messages ..................................................................................................................................... 3 Key Technologies ................................................................................................................................ 3 Time Estimates .................................................................................................................................... 3 SETUP AND CONFIGURATION ............................................................................................................. 3

    Task 1 Running the Configuration Wizard ...................................................................................... 4

    OPENING STATEMENT ......................................................................................................................... 5 STEP-BY-STEP WALKTHROUGH ......................................................................................................... 6 Segment #1 Creating a Utility Control Point (UCP) ............................................................................ 6 SUMMARY ............................................................................................................................................ 20

Overview

    This document provides a written script for showing how to create a Microsoft SQL Server Utility Control Point. You can also use this document as a tutorial or walkthrough of the technologies involved. Key Messages

    ; SQL Server Utility Control Points help monitor the health of an organization's SQL Server instances.

    ; SQL Server Utility Control Points help locate targets for server, instance or application consolidation.

Key Technologies

    This demo uses the following technologies:

    1. Microsoft SQL Server 2008 R2

    2. Microsoft SQL Server Management Studio

Time Estimates

    ; Estimated time to complete the demo: 15 min.

    Setup and Configuration System Requirements

    ; Microsoft SQL Server 2008 R2

    ; Microsoft SQL Server Management Studio

    ; SQL Server AdventureWorks2008R2 sample database

The setup and configuration for this demo involves running the Configuration Wizard tool included with the training kit.

Task 1 Running the Configuration Wizard

    The following steps describe how to run the Configuration Wizard tool included with the demo to verify that all the prerequisites are properly

    installed.

    1. Browse to the Setup folder in the Source folder of this demo, and run the Setup.cmd script. This script will launch the Configuration

    Wizard for the demo. The Configuration Wizard is designed to check your computer to ensure that it is properly configured with all of

    the dependencies needed to run the demo.

    2. Click through the steps in the Configuration Wizard to get to the Detecting Required Software step; a scan of prerequisites will be

    performed on your computer. If you do not have the necessary dependencies, install them using the links provided by the tool and

    rescan your computer.

    Figure 1

    Dependencies check completed successfully

    3. Once the required software is properly installed click Next to configure your computer for this demo. A script will be executed to create

    four sample databases, other for register two databases as Data-tier Applications, other to create a job to force the data load into the

    Utility Explorer, and another to create the server alias ('SQLServerTrainingKitAlias') used in this demo to establish a connection with the

    database.

    Figure 2

    Configuration Wizard tasks

Opening Statement

    Today I would like to walk you through a demo of setting up a Utility Control Point, as part of SQL Server 2008 R2. Utility Control Points are used

    as a central location for monitoring installed SQL Server instances across an organization.

In this demo you will specifically see these things:

    1. Setting up a Utility Control Point (UCP)

    Step-by-Step Walkthrough This demo is composed of the following segments:

    1. Creating a Utility Control Point

    Segment #1 Creating a Utility Control Point (UCP) Action Script Screenshot

    1. Open up Microsoft SQL Server ; If we have a look at the SQL Server

    2008 R2 | Configuration Tools | Configuration Manager, this will show

    SQL Server Configuration us the SQL Server Services that are

    Manager. installed and are running on this

    machine.

    2. In the SQL Server Configuration

    Manager, right-click SQL Server ; What is of interest to us, the normal Agent (MSSQLSERVER) and click SQL Server Service was the SQL Properties. Server (MSSSQLSERVER) i.e. the

    default instance.

    3. Click the Service Tab and change

    the Start Mode to Automatic then ; We also have the agent for that click Apply. instance called SQL Server Agent

    (MSSQLSERVER).

    4. Click Logon tab and click Start (if is

    not already started). ; We will do is start SQL Server

    Management Studio

    5. Open SQL Server Management

    Studio from the Start menu. ; Connect to the Database Engine

     using an administrative credential.6. Log on to the local Database Engine

    instance using the

    SqlServerTrainingKitAlias server

    alias.

    7. Open Utility Explorer from View | ; We will open Utility Explorer from the

    Utility Explorer. View menu.

    8. Navigate between two icons and ; From the toolbar icon, you can also

    show the differences between the connect to an existing UCP or Create

    two. a new UCP.

    9. Create a new UCP by clicking on the ; Click on the Create UCP icon to

    Create Utility Control Point icon. create a new UCP

    10. Click Next button to navigate to the ; Introduction screen warns us about

    next step. what we are about to do and will take

    us through five steps.

    ; Click Next to navigate to the next

    step.

    11. In the Specify Instance step, click ; For this wizard, in the first step we

    Connect. need to say which SQL Server it is

    that we will connect to and where the

    UCP that will be established. 12. In the Connect to Server screen, Importantly this is very similar to what type the SqlServerTrainingKitAlias we have with Data Collection System server alias as the Server name and and Management Datawarehouse then click Connect. where Performance Data Collection.

    The idea here is that there will be a

    13. Type Contoso Utility in the Utility Management Datawarehouse style Control Point Name textbox. database created that will hold the

    details for the different instances of

    SQL Server. 14. Click Next.

    ; For this case, we will be connecting

    to our local SQL Server.

    ; Click Connect.

    ; We need to pick a name for the UCP,

    and in this case, I would suggest a

    name like Production Utility. It will

    be a name that will be used for our

    entire domain. I am going to call it

    Contoso Utility.

    ; Click Next.

    15. In the Specify Account step, select ; The next step asks what Windows

    the Use the SQL Server Agent account is it going to run when it

    service account option. needs to do data collection. Similar to

    when it needs to do Performance

    data collection system. We are going 16. Click Next. to have tasks that need to run to go

    off, collect details from a dynamic

    management view and push them up

    to a central Data Warehouse.

     ; Typically, this will be a Windows

    Service Account that has been set up

    to run SQL Server or SQL Server

    Service Account.

    ; In this case, for simplicity, we are

    going to select the SQL Server Agent

    service account and in this case it is

    our SQL Service Agent account. You

    may well have a separate account

    setup for that.

    ; Click Next.

    17. In the Instance Validation step, click ; The next it does is that it goes

    Next. through and checks to see that the

    Instance that we have connected to is

    one that we can validly use as a

    configurable UCP.

    ; This is a change that has been made

    to many of these steps where they

    tend to go ahead and pre-validate the

    whole thing and show you whether it

    is possible rather than wait until it

    tries to configure something and falls

    over part way through. This is great.

; If anything fails here too, you can

    potentially modify it and click the Re-

    run Validation button and that would

    go through and re-run to see if those

    things are still applicable.

    ; Importantly note the things that are

    required. We need to have

    Administrative privileges.

    ; SQL Server version needs to be

    10.50 or higher which means SQL

    Server 2008 R2.

    ; The Edition must support UCP

    creation. It mentions this one cannot

    have another UCP in place, so we

    cannot have this already on the

    server itself. In addition, the server

    itself cannot be enrolled in another

    UCP.

Report this document

For any questions or suggestions please email
cust-service@docsford.com