New Dynamic Cache Master functionality fill tempdb in some days, find a solution!

[ngiacom]

1. Describe your environment: What is your industry? What is your role in your organization? Describe your stakeholders.
My company is a Manufacturing Company, I am a "Project Optimization Engineer PLM" but for you I am a Windchill Administrator and Customizer. My stakeholders are the Windchill and CAD users, many departments of the company.

2. What version of Windchill are you currently running?
12.0.2.2

3. Describe the problem you are trying to solve. Please include detailed documentation such as screenshots, images or video.
I've just created an idea in the past about this issue, 559076 but recently ptc archived it. I have to create a new one, this one. The old description is valid yet:

Tempdb is always slowly increasing until sql server is restarted.

Then is mandatory a periodical offline for Windchill. This is a regression and it must be solved.

https://www.ptc.com/en/support/article?n=CS288119

4. What is the use case for your organization?
Use case is to arrive a the end of the week without a system down. I need to restart Windchill every weekend, with the risk of this operation and blocking some user that works on sunday.

5. What business value would your suggestion represent for your organization?
Less down, more business.

[TomU]

Backup up the transaction log on a regular basis is super simple and totally eliminates this problem.  Here is a script to make this even easier: https://ola.hallengren.com/sql-server-backup.html

[ngiacom]

Hello @TomU , my database is Simple and not Full, I don't need and I can't backup transaction logs, but I have the issue.

Thanks

Nicola

[TomU]

The article also suggests making tempdb larger.  Disk space is super cheap.  Is there some reason you can't simply allow it to grow larger?  This also helps when doing upgrades because the upgrade will fail if tempdb is too small.  I choose to run 4 tempdb files at 32 GB each (on their own dedicated drive) in my environment.

Some good info here:

• https://www.brentozar.com/training/fundamentals-database-administration/tempdb-config-9m/
• https://www.brentozar.com/archive/2014/05/tell-need-tempdb-files/
• https://www.brentozar.com/archive/2011/10/how-tell-if-tempdb-performance-problem/

[ngiacom]

My tempdb disk is 130 GB SSD (for performance reasons) in 8 files (8 cpus), the disk is dedicated to tempdb.

Usually it works fine for a 1 week, sometimes 1 week is not enough.

Nicola

[TomU]

Seems like you're doing everything right.  Apparently PTC needs to do a better job of managing their queries so this doesn't happen in environments where transaction logs are not used and the server can't constantly be restarted.

[olivierlp]

Hello, 

Thank you for your idea and the information provided.