Re: Queueing Theory in Oracle

  • From: Henry Poras <hrp@xxxxxxxxxx>
  • To: exriscer@xxxxxxxxx
  • Date: Thu, 13 Mar 2014 12:18:00 -0400

I have a couple of papers from talks I gave at the Hotsos Symposiumn a few
years ago.

Applying Queueing Theory Analysis to Oracle Statspack Data (2009)
Determining Resource Utilization and Saturation Limits Using AWR history
and Queueing Theory (2010)

I would be happy to post these somewhere if someone offers up a site.

I also just skimmed through this thread. I'll try to add on when I have a
chance to read it in more depth.

Henry


On Wed, Mar 12, 2014 at 11:33 AM, Ls Cheng <exriscer@xxxxxxxxx> wrote:

> Hi Jared
>
> So when the server arrives can we hear from you if the prediction is good
> enough :-?
>
> Just to check if Queueing Theory is ok
>
>
> Thanks
>
>
>
> On Wed, Mar 12, 2014 at 4:13 PM, Jared Still <jkstill@xxxxxxxxx> wrote:
>
>>
>> On Tue, Mar 11, 2014 at 1:34 PM, Karl Arao <karlarao@xxxxxxxxx> wrote:
>>
>>> From the paper, I did the simple math to estimate the end CPU
>>> requirement and utilization without doing the migration.
>>> Then I did the actual migration of workload and the numbers were about
>>> the same that I got from the math.
>>>
>>
>> Interesting discussion - I took Craig's Queuing course about 15 years
>> ago, and used it in the same manner for some new servers that had yet to
>> arrive
>>
>> It was quite a useful exercise.
>>
>> Jared Still
>> Certifiable Oracle DBA and Part Time Perl Evangelist
>> Sr Oracle DBA at Pythian
>> Pythian Blog http://www.pythian.com/blog/author/still/
>> Oracle Blog: http://jkstill.blogspot.com
>> Home Page: http://jaredstill.com
>>
>
>

Other related posts: