Looking for Missing Memory Using R

The forwarded case didn’t have many details. Its a 9i system that started experiencing ORA-4031 errors sporadically over the last few weeks. Marc suggested using R to explore how the various SGA components changed sizes over the last few weeks and see whether we can find any interesting trends that can indicate memory leaks. So we did just that. The first step is to get the actual data out of the system, and we used the following query

T-SQL:Generate statements to add TEMPDB datafiles

TEMPDB, is one of SQL server hot-debated topics; there’s always something to say about its sizing, file placement or datafiles count in Multi-core instances. This is simply because TEMPDB is a global resource that’s heavily used and very critical asset in a busy instance; this makes any advice against TEMPDB fall in the “It depends” category.

Cambrian Explosion (Dist::Zilla Plugins Galore)

The pièce de résistance is Dist::Zilla::Plugin::NextVersion::Semantic which I had promised to Mike Doherty a long time ago. In a nutshell, the plugin examines the changes of the upcoming release and increases the version according to the rules of semantic versioning.

Avoid Gotchas While Starting up with MongoDB

When starting to work with a new technology in a development or sandbox environment, we tend to run things  –  as much as possible – using their default settings.  This is completely understandable, as we’re not familiar with what all of the options are.  With MongoDB, there are some important issues you might face if…

Queues, Pools and Caches – Hotsos 2012 Presentation and FAQ

Thanks to everyone who attended my presentation “Queues, Pools and Caches” at Hotsos 2012. I had a blast and I hope you did too. I posted the slides and paper on SlideShare for your enjoyment. The paper is by far more complete and contains a lot of material I had to leave out of the slides. There were many questions asked after the presentation, so I thought I’ll post a short FAQ to address those:

Page 80 of 274« First...102030...7879808182...90100110...Last »