TM1 Web performance issue.

[appleglaze28]

Hi! Just look for advise from our TM1 Experts here. I'm deploying an application via TM1 Web. We're currently have problems with the users having complaints about the performance that we've encountered:

1. Accessing URL takes time.
2. Operation failed because the server times out.
3. When clicking drop down...the browser takes time to run.

'm kinda stuck on where to look to be able to isolate the problem. I'm running the TM1 9.5.2 FP1 with 6GB RAM. The application isn't even that big...8 users only access 8 cubes but with the most having 5 dimensions. Is there any new config that might solve my problem on both the TM1 & Web Config?

The following is my config setting

Code: Select all

[TM1S]
ServerLogging=T
SecurityPackageName=Kerberos
IntegratedSecurityMode=1
UseSSL=F
ServerName=Project
DataBaseDirectory=D:\Apps\Apps
IdleConnectionTimeOutSeconds =57600
AdminHost=
PortNumber=13445
ClientMessagePortNumber=13444
Language=ENG
SaveTime=
DownTime=
ProgressMessage=True
AuditLogOn=T
AuditLogMaxFileSize=1000 MB
ViewConsolidationOptimization = T
ViewConsolidationOptimizationMethod = Tree
AuditLogUpdateInterval=60 
MaximumLoginAttempts=10
#CalculationThresholdForStorage = 100


#Additional Configuration
PerformanceMonitorOn=T
LoggingDirectory=D:\Apps\Logs
MaximumViewSize=3000
GroupsCreationLimit = 20
ExcelWebPublishEnabled = T
SpreadingPrecision = 1e-8
AllowSeparateNandCRules = T
ViewConsolidationOptimization=T
ViewConsolidationOptimizationMethod=TREE
PrivilegeGenerationOptimization=T
ParallelInteraction=T
#LockPagesInMemory=T
#ProgressMessage=F

[Duncan P]

A thing that caught me was having a large number of sheets within the same Excel workbook with a few active forms and DBR drop-downs on each sheet. It was very slow to do even the simplest thing and looking on the server all the processing time was in the ASPNET.EXE process.
When I broke it down into separate books with a single sheet in each book and buttons to link between it worked a lot faster.

[tomok]

Is it just TM1Web that is slow? What about Perspective? Does the system perform fine for Perspectives but just slow down when in Web? How many tabs are in your web sheets. Do you have Auto-Recalc turned on in those web sheets? Is TM1Web on the same box as the TM1 service? It could be any number of things.