Jump to content
Sign in to follow this  
Bhuvaneswari Rajamani

6 Sigma tools in software application troubleshooting

Recommended Posts

For all related to IT through software development / maintenance,

You can leverage six sigma tools for troubleshooting issues in a software application. It need not be a complete DMAIC project.

I recently used few of the six sigma tools in such case.

One of the automated batch operations (Job1) was failing randomly. We tried to collect the data and wanted to see if there is any specific pattern in which the jobs are failing. We could do this analysis and nail down the actual issue within 4-5 hours as opposed to 2-3 days which was spent in such analysis without using the tools. At the end of analysis, we found out the issue is due to system resource contention (database connections) between Job1 and few more jobs. Whenever the previous jobs are processing more data all resources are consumed by those jobs and when Job1 kicks off according to the schedule resources were unavailable. That's why Job1 was failing intermittently.  The development team fixed this issue by changing the logic to wait for the previous jobs to complete and check if the required resources available before kicking off Job1 (and not after kicking off the job).

It was an interesting analysis and outcome was a rather surprising one.

Used run chart, time series plot, Pareto, scatter plot.

Please share if anyone else has come across such usage for 6 Sigma tools.

Share this post

Link to post
Share on other sites
Guest Pankaj K.

But i didnt get you on this as how did you find out that database connection (or system resource contenttion ) is the primary issue .the stastical analysis cn give only the understadning that either there is decrease or increase which can be due to various issues.Do you did brainstroming to understading n he primary cause .

Baecasue run chart, time series scatter etc can only show variations in certain area or certain time but cause would not be known .There can be variuos causes that would come up during brainstorming .

Did u reach to this analyis independently ? Just curiuos to know

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who's Online (See full list)

  • Forum Statistics

    • Total Topics
    • Total Posts
  • Member Statistics

    • Total Members
    • Most Online

    Newest Member