Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.
This topic has not yet been rated - Rate this topic

Use SQL Server Express to Create a Tuning Database

Speech Server 2007

Use Microsoft SQL??Server 2005 Express Edition (SQL??Server Express) to create and view a tuning database if a different version of Microsoft SQL??Server 2005 is not installed. SQL??Server Express supports a single processor, and a maximum database size of 4 GB.

Use the sqlcmd utility from the command prompt window to create an empty tuning database. For more information about sqlcmd, see Using the sqlcmd Utility (SQL Server Express).

To create a new tuning database
  1. Open the Command Prompt window.

  2. Locate the directory that contains sqlcmd.exe.

    By default, the path is %ProgramFiles%\Microsoft SQL??Server\90\Tools\Binn.

  3. At the command prompt, type a command using the following syntax to connect to a SQL??Server Express server.

    The SQL??Server (SQLExpress) service must be started if it is not running.

    sqlcmd -S myComputerName\SQLExpress
    

    Notice that the command prompt changes to a number one with an angle bracket (1>).

  4. Use an SQL query to create a new database, for example:

    CREATE DATABASE myTuningDB
    GO
    
  5. Type QUIT to return to the command prompt window.

Use the MSSLogToDatabase command-line utility to import Speech Server trace log files into the tuning database. See the following example syntax, which identifies the server as SQL??Server Express and uses the /noencrypt flag to specify an unencrypted connection. SQL??Server Express supports only unencrypted connections.

MSSLogToDatabase *.etl /database:myTuningDB /server:.\sqlexpress /noencrypt

For more information, see Import Log Files into the Tuning Database.

Use Analytics and Tuning Studio to view and analyze speech application log data contained in a Speech Server tuning database. To specify that the server is running SQL??Server Express, identify the server using the text .\sqlexpress in the Connection Properties dialog box.

Community Additions

Show:
© 2014 Microsoft. All rights reserved.