Work Volume in V9

Robert Vignerot

My currect project is going to be rolling out our next set of users next week which means I expect us to cross the 1 million folder mark for the project.  That got me thinking about how others out there are doing on the v9 stack.  Here is a snapshot of some metrics for our project:

 

Folders for this project. - 881,000

Folders system wide - 1,376,000

Most number of folders created in a single day - 70,277

Most number of actions taken in a single day - 94,282

Most number of actions taken in a single hour - 30,483

Most number of user actions taken in a single hour - 5,706

 

If you are in production I would love to hear how you compare to this.

ICCM Support

Hey Rob,

 

Thanks for posting this, good information to know.  A couple of questions if you don't mind:

 

1.  How many concurrent users do you have on the system

2.  Whats the deployment configuration - number of engines, use of sso, etc (did you change any default settings)

3.  Are you using SBW

4.  Did you have any challenges around performance, or did everything run smoothly

 

Appreciate your time!

 

Jason

Robert Vignerot

1. We are in the middle of a phased rollout. As of today, we have rolled out 8/10 regions across the US and that puts us around 400 concurrent users.
2. We are using a 2 web/2 engine configuration against SQL Server using SSO.
3. We are not using SBW at this time.
4. We experienced a number of tuning issues with SQL Server as we scaled up, but none of the issues were MBPM specific. The biggest change for us was to turn on Read Committed Snapshot Isolation.

Stuart White

Great stats - thanks Rob. Echo'ing the request, I'd be very interested to see stats of how other production systems compare to this.

Robert Vignerot

It has been about a month since my original post, so I thought I'd give a brief update.  We have now completely rolled out the solution I have been working on and things have been going smoothly.  The business is quite happy and they are estimating that they will see 39 FTEs worth of savings in 2013 due to work efficiencies and the identification and removal of non-value added work. We have about 500 distinct users every day in the system and the system utilization is quite high.

 

We have a few performance issues we are still working out, but generally things are very good.  The main issue we have had with MBPM is a fairly esoteric one in that due to a conversion of eFolderid from nvarchar to varchar, we started getting a large number of page locks which in turn caused serious deadlock issues until we switched the SQL Server MAXDOP setting to 1.  This has caused general performance degradation, but has removed the deadlocking.  We expect an upcoming hotfix to resolve this. Here are updates to the numbers I provided a month ago:

 

Folders for this project. - 881,000 - > 1,661,118

Folders system wide - 1,376,000 -> 2,178,227

Most number of folders created in a single day - 70,277 -> 75,339

Most number of actions taken in a single day - 94,282 - > 163,012

Most number of actions taken in a single hour - 30,483 -> no change

Most number of user actions taken in a single hour - 5,706 - > 7,998

 

If anyone our there can share similar numbers on your production systems, I would very much love to hear about them.  Either post them here or send me a private message.