Possible Bottlenecking and 100% failure on making viewables

[Aaronm87]

Two questions here. I was reviewing Microsofts best practices for windchill on SQL 2008. I ran the query for a possible bottlenecking scenario and the following came up. Can anyone explain to me if I have a bottle neck anywhere? We pretty much have 2 active users, but a lot of our models are pretty large and sometimes I noticed it takes quite a while to check out or check in objects.

When I check in an object, there are no viewables at all. The WVS Job manager shows 0 successful jobs (on job 36k now). The other user has had about 5-10 sucessful jobs right when we installed windchill but the next 36k jobs all failed. Any ideas on what might be causing this to fail?

We are using Creo 2.0 with Intralink 10.0

[ChrisSpartz]

In regard to the possible bottleneck, how long are the Check in/Check outs taking, and how large are the files? Checking in/out large files will take longer than small files as they will take longer to be transferred between the client and the Windchill server. So, if the check in/out time is about the same as the amount of time required to transfer the files across the network, then the bottleneck is your network speed.

However, if the check in/out is taking considerably longer than it would to transfer the file, then the bottleneck is somewhere else. You can determine if it's a DB bottleneck by following the instructions in CS105356. The first part of this article explains how to gather data about what the DB is doing during the check in/out process. The second part explains how to use various tools to analyze the data gathered in part 1.

[mdigman-2]

Hi Aaron,

On the viewables, are you getting thumbnail images of your parts in Windchill? You can check by going to the details page for any given part; do you get an image of the part, or do you have an image of some rollers? If, indeed, all your publishing jobs are failing, then you need to determine what is wrong with your publishing server. Did you setup a Creo Worker to publish files, and can you verify that the worker starts correctly?

Drop me an email if you need any help,

Thanks,

Micah