January 18, 2011 at 4:18 am
Hi there,
Please can anyone help
when importing 9million rows from same 12 tables the duration can be anything from a few hours up to 10 hours.
This is from 1 database to another on the same Instance of SQL 2008
If we watch the process thread in the SSMS we keep seeing ‘Suspended’ (Wait type) against ‘PageIOLatch.EX’ or ‘PageIOLatch.SH’
Can anyone suggest why the duration can fluctuate so much..
OS: Windows Server 2003 R2
RAM: 4GB
VM Machine
HD in a SAN
Many Thanks.,
January 18, 2011 at 5:47 am
i think you have more number of measures\dimensions,
that's why your cube is taking more time to processing
try to decrease those measures\dimensions
and try to make another cube for same datasource
then check the processing time.
definately,the processing time'll decrease...
[font="Verdana"]SRIHARI(:~[/font]
January 18, 2011 at 9:32 am
Simon Hardstaff (1/18/2011)
If we watch the process thread in the SSMS we keep seeing ‘Suspended’ (Wait type) against ‘PageIOLatch.EX’ or ‘PageIOLatch.SH’
Those are drive I/O waits. You're pulling, most likely, off shared spindles and the other items on your spindles in the SAN are interfering at varying amounts. I'd talk to your SAN administrator and find out what your LUNs are sharing physical spindle space with.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply