Oninit cdi / Archive
Talk to an expert →

Re: High lngspins - IDS 9.30 UC2

Posted in 2003

Topics: Performance & Tuning, Installation, Setup & Upgrades, Storage & Space Management, Versions, Editions & End-of-Life

Mark D. Stock — — source: Usenet: comp.databases.informix

Hari Gupta wrote: > Hi All, > > We have recently upgraded IDS 9.21UC3 to IDS 9.30 UC3 on RHL 7.3 > (Kernel - 2.4.18-27.7.xbigmem). Platform - Dell PE6600 - Quard Xeon, > dual channel, 8GB RAM - HT. Channel-A has 8 72 GB mirror & stripped > and Channel-B has got 8 36 GB mirror & stripped. > > I have been keeping an eye on the database performance and constantly > observing that lngspins are keeps on growing. Within 2 days of > running, > lngspins gone upto more than 21000. Also notice high seqscans. This is not necessarily a bad thing. Do you have a performance problem? > So far as seqscans are concern, probably they have been there with > IDS 9.21 UC3 as well. It's difficult to evaluate a system from a few snapshots, but I would guess that a lot of the sequential scans come from temporary table usage. You only have one temp dbspace and it is being hammered. Also, it looks like you have placed all your data in one dbspace, so that will be another hot spot, albeit in 3 chunks during the snapshot. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list

↪ replying to Mark D. Stock
Hari Gupta — — source: Usenet: comp.databases.informix

Thanks Mark. I love your comments and sharp observation. Performance is an issue but not crirical. Regd. tempdbs, if I create another temp dbspace, you reckon, it will help in hammering down. Hari "Mark D. Stock" <mdstock@mydassolutions.com> wrote in message news:<bmn8ls$s8m$1@terabinaries.xmission.com>... > Hari Gupta wrote: > > > Hi All, > > > > We have recently upgraded IDS 9.21UC3 to IDS 9.30 UC3 on RHL 7.3 > > (Kernel - 2.4.18-27.7.xbigmem). Platform - Dell PE6600 - Quard Xeon, > > dual channel, 8GB RAM - HT. Channel-A has 8 72 GB mirror & stripped > > and Channel-B has got 8 36 GB mirror & stripped. > > > > I have been keeping an eye on the database performance and constantly > > observing that lngspins are keeps on growing. Within 2 days of > > running, > > lngspins gone upto more than 21000. Also notice high seqscans. > > This is not necessarily a bad thing. Do you have a performance problem? > > > So far as seqscans are concern, probably they have been there with > > IDS 9.21 UC3 as well. > > It's difficult to evaluate a system from a few snapshots, but I would guess > that a lot of the sequential scans come from temporary table usage. You > only have one temp dbspace and it is being hammered. > > Also, it looks like you have placed all your data in one dbspace, so that > will be another hot spot, albeit in 3 chunks during the snapshot. > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| > | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| > | +-----------------------------------+//// / ///| > | |We value your comments, which have |/// / ////| > | |been recorded and automatically |// / /////| > | |emailed back to us for our records.|/ ////////| > +----------------------+-----------------------------------+-----------+ > > sending to informix-list

Glossary