Question Maximum Database Connections

[Austin Skrepak]

Do either of you have any good resources on defining storage areas and moving tables and indexes to those storage areas via dump & load?

 

[LarryD]

Check out this thread:

http://www.progresstalk.com/threads/type-ii-cluster-size-and-d-l-vs-multi-threaded-for-each.123068/

Some excellent resources (and also a video of Tom's presentation which is a great source of knowledge)

 

[Austin Skrepak]

Sample the "performance indicators" screen.

You're interested in latch timeouts. If you only have a few dozen per second it's no big deal. A few hundred then it's time to start keeping an eye on it. A thousand -- you probably have a problem.



In my experience it doesn't matter much if you hyper-thread or not.

But if you can sell about half of those cores back to the vendor you could probably find better uses for the money.

So this means I have a problem?

 

[TomBascom]

162/sec is in the "keep an eye on it" range. Not the "you have a problem" range.

 

[Rob Fitzpatrick]

Do either of you have any good resources on defining storage areas and moving tables and indexes to those storage areas via dump & load?

Try post 29 in this thread.

 

[Rob Fitzpatrick]

Also, this presentation by Paul Koufalis from PUG Challenge Americas 2012 is a good primer on database dump & load concepts and techniques.

 

[jdpjamesp]

Excellent thread, Rob and Tom. Thanks for helping this guy out!!