Abstract

This study analyzes the reliability modelling and quality analysis of SQL servers in millennium database reporting and predicts failures on Microsoft SQL Server version 2012 (pre-) and version 2014 (current or post-) and compare failure data on both the servers. The SQL reporting server runs as an application server that provides capabilities to process and manage reporting services. The SQL server helps in processing reports that are placed on the server either by scheduling the reports to run at a certain time or they could be run on demand. The data required for this project is collected from Millennium database servers from Pittsburg State University Foundation, Kansas. Each of these server versions is analyzed based on report failure rate for two years and compared using the paired t-test. This data is used to determine the mean time to failure (MTTF) and is fit to four statistical distributions: Weibull, lognormal, exponential, and normal. Weibull is found to be the best fit. Goodness of fit test validates the Weibull model. For the Weibull distribution, parameters are estimated which can be used to determine reliability, hazard rate, etc. of the database management server. Quality analysis was done using quality tools like the fishbone diagram to perform root cause analysis of the failures and a Pareto chat to know the vital causes from trivial many.