Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.5 - User Guide

About Backing Up/Restoring with LiteSpeed LiteSpeed User Interface Configure LiteSpeed for First Use Cloud Back Up Databases Automate Maintenance Tasks Restore Databases Restore Objects View Activity and History Use Command-Line Interface Use Extended Stored Procedures Troubleshoot LiteSpeed Review Additional Resources

Configure Job Manager Options

To set Job Manager options

  1. Click the Application Button and select Options.
  2. Select the Job Manager tab. Review the following for additional information:

    Use this option...

    To...

    Default

    Scheduler Page

    Set the following options.

    Show server time

    Display the local time and the time difference between the desktop and the server at the top of the Calendar tab for each server.

    Selected

    Show recurring executions as one item

    Simplify the display by showing jobs that run multiple times as one job.

    Selected

    Show jobs that run continuously during the day on top of the schedule

    Display the continuously running jobs at the top of the schedule.

    Task List Page

    Set the following options.

    Show steps

    Display each job step on the Job List tab in an expanding row in the list or in a separate pane at the bottom of the window.

    Under each row of a job

    Show history

    Display job history on the Job List tab in a separate pane at the bottom of the window.

    On Demand—Display history only after clicking Show History. (Selected.) If cleared, history displays automatically when you select a job.

    Cleared

    Advanced

    Click Advanced to set the following options.

    Maximum number of threads

    Specify the maximum number of total concurrent threads to use on target instances to run the jobs.

    3

    Maximum appointments

    Specify the maximum number of appointments that can display on the Calendar tab. If the number of appointments exceeds this value, appointments may display incorrectly.

    25

    Show disabled jobs

    Display the jobs that have been disabled.

    Selected

    Refresh job status after start/stop

    Refresh the job status automatically after the job is either started or stopped.

    Selected

    Auto refresh windows tasks every:

    Specify the auto refresh rate in seconds for windows tasks.

Tip: Click Advanced | Known Applications to add new or change existing masks and icons. A mask is a pattern used to group jobs or tasks with similar names and display the appropriate icon for them. Masks are stored locally.

 

Related Topic

Set Log Reader Options

To set the Log Reader options

  1. Select the Application Button and select Options (Keyboard: ALT+F+O).
  2. Select the Log Reader tab.
  3. Review the following for additional information:

    Use this option...

    To...

    Default

    Check log file changes every

    Check the log file for changes every so many seconds.

    Selected
    10 seconds

    Show uncommitted transactions

    List all the transactions that are not committed.

    Selected

    Reconstruct DDL commands

    Select this option to display both DML and DDL commands

    Selected

    Export all details of the log

    Export all details of the log file.

    TIP: Select this option to get a full report.

    Not Selected

    Online log reading timeout

    Set the amount of time the log is read before a timeout is reached.

    300 seconds

    Maximum BLOB size

    Set the maximum Binary Large Object (Blob) Data size.

    8000 bytes

    Reconstruction

    Select one or both of the following:

    • Request full database backup file if needed - When reading an online or offline log, the Log Reader might need to refer to the full-backup file for the database to reconstruct old log records. Select this option to enable the use of the full-backup file.
    • Enclose Undo/Redo scripts in a transaction - Use this option to turn on or off transactions for undo/redo scripts.

      NOTE: You need to turn off transactions to undo or redo in-memory objects.

    Selected

    Search Depth

    Select whether to read the entire log file or only a set number of records in the log file. The options are:

    • Read entire log file - Select this option to read the entire log file.
    • Read approximately - Select this option to set the number of records to read.

      NOTE: The minimum number of records to read is 100,000.

      The Log Reader stores temp data in %temp%/Quest Software where %temp% is the first path found of: the path specified by the TMP environment variable, the path specified by the TEMP environment variable, the path specified by the USERPROFILE environment variable, the Windows temp directory.

    100000

 

Related Topics

Configure Replication and Retention Options for Repositories

LiteSpeed requires the following privileges and grants:

Account Requirement

User account that performs the LiteSpeed installation

Windows administrator rights and DBA privileges required to
  • Install stored procedures and extended stored procedures
  • Create databases, tables, and indexes
  • Insert, update, and delete to/from the MSDB, LiteSpeedLocal and LiteSpeedCentral databases
User account that runs the LiteSpeed UI Console

Power User privileges (or some equivalent).

NOTE: When executing a Double Click Restore, Windows Vista, Windows Server 2008, and higher require that the Windows user account is an administrator.

SQL Server service account

Sysadmin server role privileges required to

  • Push stats to local repository
  • Back up or restore using extended stored procedures
  • Execute a scheduled job
  • Start a job manually

TIP: The SQL service account needs at least read\write access to the following directory and all its contents:
C:\ProgramData\Quest Software\LiteSpeed\SQL Server\

NOTE: SQL Server Configuration Manager should always be used when changing SQL Server service accounts.

SQL Agent service account (or a proxy account)

Windows or SQL Server accounts specified during instance configuration (Start | All Programs | Quest Software | LiteSpeed for SQL Server | Instance Configuration)

For more information, see Configure Server Instances.

If you select SQL Server authentication, the SQL Server account must have sysadmin server role privileges, while the Activity Manager service account must have the Log on as a service permission.

If you select the Windows authentication method for both the local and central repository, then the Activity Manager service account specified on the Service Account page must have the sysadmin privileges and the Log on as a service permission.

NOTE: If the central repository is located on another server, the LiteSpeed Activity Manager service account must have domain rights for two-way communication between the local and central repositories.

Windows or SQL Server account (Application Button | Repository Registration...)

For more information, see About Collecting Statistics in Repositories.

Db_owner of the central repository (required to retrieve data from the central repository)

Windows or SQL Server account (Application Button | SQL Server Registration...)

Sysadmin server role privileges required to

  • Connect to SQL Server and retrieve SQL Server properties
  • Back up or restore
  • Execute procedures, retrieve MSDB history
  • Access repositories

TSM with LiteSpeed

If using TSM, its recommended that the following line be added to the dsm.opt file used by LiteSpeed.

errorlogname "C:\ProgramData\Quest Software\LiteSpeed\SQL Server\Logs\dsierror.log"

 

Push Statistics to Central Repository

There are two options for replicating statistics to the central repository. The first option replicates the LiteSpeed activity. The second option only replicates job status, maintenance plans and log shipping information.

If you did not select to populate the central repository automatically or via a scheduled job during Instance Configuration, you can manually force a replication at any time by calling the ActivityManager.exe file from the command line or using the extended stored procedures.

NOTE: The xp_replicate_activity_statistics command is designed for sync changes between the local and central repositories. LiteSpeed does not contain information about the native backup history because it is a SQL Server native tool. You must use the [LiteSpeedLocal]..[LiteSpeed_ImportNativeHistory] procedure to import the native backup history first into the local repository.

To replicate database and LiteSpeed activity information

On the local repository server, do one of the following:

  • Execute dbo.xp_replicate_activity_statistics against the master database.
  • From the command line, change the directory until you are in the directory containing the LiteSpeed command-line utilities (Usually, C:\Program Files\Quest Software\LiteSpeed\SQL Server\Engine) and run ActivityManager.exe.

To replicate job, maintenance plans and log shipping information

On the local repository server, do one of the following:

  • Execute dbo.xp_replicate_job_statistics against the master database.
  • From the command line, change the directory until you are in the directory containing the LiteSpeed command-line utilities (Usually, C:\Program Files\Quest Software\LiteSpeed\SQL Server\Engine) and run ActivityManager.exe -GatherJobStats.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating