Re: Boss is asking for 'root cause analysis'

Ed Stevens <nospam_at_noway.nohow> wrote:

> Now my manager is pressing for a root cause analysis and preventative
> measures. When the question is asked regarding why did things
> suddenly fall over and break, the only response the DBA that found the
> solution can give is that perhaps we passed some sort of threshold.

Do you have a test environment, identical or very similar to the production environment, that you can play with? If not, then tell your manager to put his money where his mouth is. If so, then restore test to the state that production was in just before it went bad, and capture some explain plans for the queries, load more data until it breaks, then capture explain plans of the now broken queries. Then set STAR_TRANSFORMATION_ENABLED=TRUE, and capture more explain plans. Compare and contrast amongst the three sets.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB