Spirit Software Solutions - TSM Administration and Reporting made easy
Spirit Software Solutions
  • DownloadDownload Products
  • PurchasePurchase Products
  • ProductsOur Products
    • SP Studio
    • TSM Studio Server
  • SupportProduct Support
    • Open a case
    • Helpful TSM SQL Commands
    • Knowledge Base
    • Known Issues
    • Pre Release
    • TSM Studio Documentation
  • ResellersResell TSM Studio
  • Contact UsGet in Touch With Us
Knowledge Base

TSM Studio Server

Microsoft SQL Server settings for TSM Studio Server

If SQL Server is running on the same Server as the TSM Studio Server service then we recommend 12GB of memory as a minimum to ensure the healthy running on TSM Studio Server.

By default SQL Server will be configured to use all available memory this will need to be changed so that there is enough free memory for  TSM Studio Server to function. It is recommended  that SQL Server be given 4GB of memory and the other 8GB is left available for TSM Studio Server.

To change the default memory settings in SQL Server. Start up SQL Server Management Server right click on the server and select properties

SQLServerProperties

 

Select Memory and then enter 4096 into the Maximum server memory field

sqlservermemorysettings

 

Permalink.

Performance Tuning TSM Studio Server


In TSM Studio Server 2.9.011 and above there are a number of added enhancements to help tune TSM Studio for you environment.

The first area to check is on the Concurrency Tab of the TSM Studio Server properties dialog which can be accessed from Configuration–>Properties as shown here

PropertiesMenuItem

 

The main setting to check here are Concurrent Reports and Concurrent Collector Threads. Report creation can consume large amount of memory so it is recommended to keep this number low.

PropertiesConncurrency

Also some of the collections can consume a large amount of transaction log space especially the activity log collector.  Each collector  can be individually tuned.  Goto Configuration->Collection schedules and edit the Activity Log collector and change the Concurrent Collectors to a small number (less than 5 )

ActLogCollection

Also check out the below link for SQL Server memory settings


https://www.spiritsoftware.biz/knowledgebase/microsoft-sql-…-studio-server

Permalink.

TSM Studio Server Security

As of TSM Studio Server version 2.9.1.0 security has been tightened up and no longer stores any security information in the registry.

The default logon to TSM Studio Server is now admin with a default password of password, (Domain field should be blank otherwise TSM Studio Server will assume it is a windows userid).

We strongly advise changing the admin password using the following procedure.

To change the password for the inbuilt admin userid use the Security–>Change Admin Password

SecurityChangeAdminPassword

 

Security in TSM Studio Server is now defined by assigning role(s) and Windows groups to a TSM Studio Server security group.

The TSM Studio Server security system will automatically create a group named Admins that has access to all functions in TSM Studio Server, the first time it is loaded it will look for the old group definitions in the registry and load them into this group otherwise it will populate with following default groups Administrators, Domains Admins and TSMStudioAdmins.

Also two roles will be created, one called Administrators which is assigned to the Admins Server group and one called Operational Report Viewer for allowing access to the Operational Report Viewer.

To access TSM Studio Server Groups select Security–>Groups

SecurityGroups

 

To modify the Admins Group Double Click or select edit from the Toolbar

SecurityGroupsList

 

Add Windows Group that should have admin access to TSM Studio Server, One Group per line

AddSecurityGroup

 

 

 

 

 

 

Permalink.

    • Home
    • FAQ
    • IBM Redbooks
    • Known Issues
    • Pre Release
    • Privacy Policy
    • Product Comparison
    • Sitemap
    • TSM Documentation
    • TSM Studio Dataviews
    • TSM Studio Documentation
    • TSM Resources
    • TSM Studio Videos
  • Twitter

    • #WCF If you are looking for an easy authentication method that you can use in WCF with multiple service contracts - http://t.co/ZjGu8UNJvF 25 April from Twitter Web Client
    • See the new blog on #TSMStudio posted on the tsmblog website - http://t.co/WHhd2oWRXa. 25 April from Twitter Web Client
    • Just finished the Microsoft WCF learning stream at http://t.co/oy2RmpnBqy absolutely fantastic way to understand WCF in-depth. 16 April from Twitter Web Client
    @spirit_software
  • Recent Comments

    • Operational Reporting Viewer - Spirit Software Solutions on How to uninstall4 years ago[…] Supported on Windows XP SP3, Vista. ...
    • TSM Studio Alerting - Spirit Software Solutions on How to uninstall4 years ago[…] TSM Studio Alerting Client Supported on ...
    • TSM Studio Operational Reporting - Spirit Software Solutions on How to uninstall4 years ago[…] TSM Studio Operational Reporting Client Supported ...
  • RSS IBM TSM Notifications

    • An error has occurred, which probably means the feed is down. Try again later.
© 2014 Spirit Software Solutions
  • Download
  • Purchase
  • Products
  • Support
  • Resellers
  • Contact Us