This documentation is archived and is not being maintained.

Tuning Database

Speech Server 2007

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Analysis and tuning of speech applications in Speech Server rely on a data analysis tool called Analytics and Tuning Studio, which is integrated in Microsoft Visual Studio 2005, and a Microsoft SQL??Server database, which manages the content of Speech Server trace log files.

Create the tuning database using Microsoft SQL??Server 2005 or Microsoft SQL??Server 2005 Express Edition (SQL??Server Express):

When the tuning database is created, use the command-line tool MssLogToDatabase.exe to import speech application trace log files into the tuning database. This tool creates the tuning database schema as part of the import process. For more information, see Import Log Files into the Tuning Database.

Use database roles to regulate access to the tuning database. Roles can simplify security administration in databases with a large number of users or a complex security system. With database roles, the database administrator can improve the security of applications by granting the minimum required permission to the identity that connects to the tuning database.

For more information, see Database-Level Roles.

Tuning User Roles

In Microsoft SQL??Server 2005, use database roles like the ones described in the following table to assign access privileges to users according to their analytical roles. Tuning user roles like Speech Operator and Speech Analyst are created by MSSLogToDatabase after the schema is created. The first import of log files to an empty database might require Database Owner rights on the empty database.

Level Description

Database Owner

SQL??Server Database administrator access, with rights to create new databases and tables. In other words, full control.

Speech Operator

Write access to existing tables of the tuning database, for example, import and pruning. In other words, Speech Analyst plus data population and pruning rights.

Speech Analyst

Privileges to read all, but write only to certain extensible fields of the database, for example, the transcription field and annotation field. In other words, Speech RO plus limited write access.

Speech RO

Read-only access to the tuning database. Appropriate for users who want to perform read-only analysis of speech data and access non-editable reports as well as list and details views.