Data Hosting Resource Manager Namespace API

This section provides the details of the application programming interface (API) for the Data Hosting Resource Manager Namespace included with the Microsoft Provisioning System (MPS) in the Microsoft Solution for Hosted Messaging and Collaboration version 4.0 . The Data Hosting Resource Manager Namespace is designed to provide business logic regarding the definition and management of Microsoft SQL ServerT resources in shared hosting scenarios. This includes:

  • Adding and removing SQL Servers.

  • Classification of shared SQL Servers such as Premium (2 CPUs) or Standard (1 CPUs).

  • Allocation of databases to servers and leveling of these databases across available systems.

Implementation Details

The Data Hosting Resource Manager Namespace installs as a Microsoft Provisioning Framework (MPF) Namespace in MPS Provisioning Manager. It may require the additional execution of a procedure to set up permissions, credentials, or perform additional initialization configurations.

Public Method Description

Data Hosting Resource Manager::AddServers

Adds SQL Servers to the Resource Manager SQL Server resource pool.

Data Hosting Resource Manager::ModifyServers

Modifies SQL Servers in the Resource Manager SQL Server resource pool.

Data Hosting Resource Manager::RemoveServers

Removes SQL Servers from the Resource Manager SQL Server resource pool.

Data Hosting Resource Manager::AddServerClasses

AddsServer Classes resource groups. This allows for the grouping of server resources by capability. For example, you might have a Premium server class that contains all dual processor servers with drive arrays.

Data Hosting Resource Manager::RemoveServerClasses

Removes server classes from Resource Manager. All SQL Servers must first be removed from the Server Class group for this procedure to succeed.

Data Hosting Resource Manager::CreateOrganizationQuota

Creates a SQL Server database and disk space quota for a specified organization.

Data Hosting Resource Manager::ModifyOrganizationQuota

Allocates an organization's reserve database and storage space.

Data Hosting Resource Manager::DeleteOrganizationQuota

Deletes an organization's database and storage quota. Note that all of the organizations databases must first be de-allocated in order for this call to succeed.

Data Hosting Resource Manager::AllocateDatabase

Allocates a database from the resource pool. The allocation is first checked against the organization's quota and then a server is selected from the pool.

Data Hosting Resource Manager::ModifyDatabaseAllocation

Modifies a database size allocation.

Data Hosting Resource Manager::DeallocateDatabase

De-allocates a database from the resource pool.

Data Hosting Resource Manager::QueryAllServerClasses

Returns a listing of all Defined SQL Server Classes.

Data Hosting Resource Manager::QueryAllServers

Returns a listing of all SQL Servers in the resource pool with capacity data.

Data Hosting Resource Manager::QueryServersByClass

Returns a listing of all SQL Servers in the resource pool that belong to a specified server class.

Data Hosting Resource Manager::QueryDatabasesByServer

Returns a listing of all databases allocated in the resource pool to a particular server.

Data Hosting Resource Manager::QueryDatabasesByOrganization

Returns a listing of all databases allocated in the resource pool to a particular organization.

Data Hosting Resource Manager::QueryOrganizationQuota

Returns capacity data for a specified organization.

Data Hosting Resource Manager::QueryAllOrganizations

Returns all organizations that have SQL Server quotas in resource manager.

Data Hosting Resource Manager::QueryDatabaseAllocation

Returns the allocation for a given database.

Data Hosting Resource Manager::InitializeRM

Initializes all resource, consumer, and group types.

Data Hosting Resource Manager::UnitializeRM

Un-initializes all resource, consumer, and group types. Note that the call will fail if the are resource types, consumer types, and mappings existing.

Applies To

  • Hosted Messaging and Collaboration version 4.5

  • Hosted Messaging and Collaboration version 4.0

  • Hosted Messaging and Collaboration version 3.5

  • Hosted Messaging and Collaboration version 3.0

  • Windows-based Hosting version 4.5

  • Windows-based Hosting version 4.0

  • Windows-based Hosting version 3.5

  • Windows-based Hosting for Applications version 1.0