September 30, 201015 yr 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.
January 22, 201115 yr 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
Create an account or sign in to comment