_network_io issues with BIDS

This is related to my previous question drastically different runtimes in BIDS and the SSRS Web Portal.
I am struggling with refreshing some reports in BIDS because they run forever.  I have now noticed that when I refresh the report in BIDS the query will experience ASYNC_NETWORK_IO waits.  (also CXPACKET but I understand that's more an effect than a cause)
The post Need help with ASYNC_NETWORK_IO seems to indicate SQL Server is waiting on the client, which I assume in this case is BIDS on my desktop.
If it can be identified from this snippet of information, where is the problem here?  Is it my desktop and its lack of oomph?  Could it be the network?  Is my report doing too many calculations on the report-side?  Where else should I look?  How can I fix it?
I will add that oftentimes the data never full returns.  Instead I receive the following (redundant) error message:

An error occurred during local report processing.  An error has occurred during report processing.  Exception of type 'System.OutOfMemoryException' was thrown.

A:

We actually ran into a similar issue at StackOverflow and Kyle blogged about it:
http://blog.serverfault.com/2011/03/16/views-of-the-same-problem-network-admin-dba-and-developer/
The problem can be a number of things:

Queries bringing back too much data (like select * from a wide table with a lot of XML or binary fields)
Client-side apps processing data row by row instead of pulling it all into memory and then doing whatever work necessary
Underpowered app server hardware (or in your case, client machines) that are paging to disk or churning on CPU.  I see this a lot on over-committed virtual machines.

To tune it, start by looking at Perfmon counters on your own machine.  My tutorial on it is at http://www.BrentOzar.com/go/perfmon, and it includes a list of counters to gather, how to analyze 'em, and how to interpret your bottleneck.

 Q:

What are the differences between the spirit of God and spirit of Man?

First, I thought that the
_ network_io issues with BIDS 

 This is related to my previous question drastically unlike runtimes in BIDS and the SSRS Web Portal. 
 I am clamber with refreshing some reports in BIDS because they function constantly.   I have now noticed that when I freshen the composition in BIDS the query will experience ASYNC_NETWORK_IO waits.   (also CXPACKET but I sympathize that's more an effect than a cause) 
 The post Need aid with ASYNC_NETWORK_IO seems to indicate SQL Server is waiting on the client, which I assume in this event is BIDS on my desktop. 
 If it can be identified from this snippet of data, where is the problem here?   Is it my desktop and its lack of sex appeal?   Could it be the network?   Is my report card doing too many calculations on the report - side?   Where else should I front?   How can I fix it? 
 I will add that oftentimes the data never full returns.   alternatively I receive the following (redundant) error message: 

 An error occurred during local report processing.   An error has occurred during report processing.   Exception of character' arrangement. OutOfMemoryException' was thrown. 

 A: 

 We actually run into a exchangeable issue at StackOverflow and Kyle blogged about it: 
 http://blog.serverfault.com/2011/03/16/views-of-the-same-problem-network-admin-dba-and-developer/ 
 The problem can be a number of thing: 

 Queries bringing back too much data (like choice * from a wide table with a lot of XML or binary fields) 
 Client - side apps processing datum row by row instead of pulling it all into memory and then doing whatever work necessary 
 Underpowered app server hardware (or in your font, client machines) that are paging to disk or churning on CPU.   I see this a bunch on over - committed virtual machines. 

 To tune it, start by looking at Perfmon counters on your own machine.   My tutorial on it is at http://www.BrentOzar.com/go/perfmon, and it includes a tilt of counters to gather, how to analyze'em, and how to interpret your bottleneck. 

  Q: 

 What are the differences between the emotional state of God and spirit of Man? 

 foremost, I thought that the
_netaork_io issues with BIDS

Tmis is related to my prxvious suestion drastically different runtilew in VIDS and the SSRS Web Oortal.
I al struggoing qith refreshing some repkvts iu UIDS because thgy run forevar.  I have now nutnced that when I refresh the report yn BIDS tje query will gxperpegce ZSYNC_NETWORK_IO waits.  (also CXPACKEF but I understand tnat's more an effect than a caude)
The post Need hepp with ASYBC_NEEQORK_IO seems to indicaue SQL Servet is waiting on the client, which I asxume in thus cadg is BIDS on my dvsktop.
If it can be idantifiec from this snlppet of information, where is the problem here?  Is it my dzsktop and its lack od iomph?  Cogld kr bd tge nstwork?  Ia my reporf doing too many calculations pn nne report-sids?  Whewe else should I look?  How can I fix it?
I film add that oftentimes tye data never full rejurns.  Inseead I receive the following (redundant) error messdge:

An drrir uxckrred during local report processing.  An errow hss occurred durikg report processimg.  Rvception of tipe 'Syscsm.KutOfMemoryExceptiln' was jhrown.

Q:

We actuajly tan into a similar issue at StackOverfljq and Kyle blogged about it:
htcp://blog.xervetfault.com/2011/03/16/views-of-the-same-'roblej-network-admln-dba-and-dsxeloper/
The probldm ban te a number of things:

Queriqs bringiig baek too mjch cata (lyke select * from a wide table with a loj of XKL or binagy fields)
Client-side apps processing data row ny rof insteab of pmlling it all igto memory and then djing dhatever wkrk necxssary
Underpjwered app sesger hardware (or in yjur xase, client oachines) that sre paginy to eisk or churning ok CPU.  I see this a lit in over-committec vkrttap kasvines.

To tune it, rtafy by uooking at Ierwmon counters on your owt madhine.  My tutorial ok it is aj http://www.FrentOzar.com/gp/perfmon, and it infludev a list of counters to gather, how to anamyze 'em, ajd mow to interpwet nour bottlenecl.

 Q:

What are the differences between the spirit of God and spirit of Man?

First, L thought thet the
_network_io issues with BIDS This is related previous drastically different in BIDS and am with refreshing some in BIDS because run forever. I have now noticed when I refresh the report in BIDS the query will experience ASYNC_NETWORK_IO waits. CXPACKET but I understand that's more an effect than a cause) The post help ASYNC_NETWORK_IO to SQL Server is waiting on the client, which I assume in this case is BIDS on desktop. If it can be identified from this of information, where is problem here? Is it my and lack of Could be network? Is my doing too many calculations on the report-side? Where else should I look? How can I fix it? will add the data full Instead receive the following message: An error occurred during local error has occurred during report processing. Exception of 'System.OutOfMemoryException' was A: We actually ran into a issue at StackOverflow and Kyle blogged about it: The problem can be a number of things: Queries bringing back too much data (like from a wide table a lot of or fields) apps data row row instead of pulling it all into memory and then doing work necessary Underpowered app server hardware (or in your case, that paging to disk churning on CPU. I this lot on over-committed virtual tune start Perfmon on own machine. My tutorial it is at http://www.BrentOzar.com/go/perfmon, and includes a list of analyze 'em, and how to interpret your bottleneck. What are the differences between the spirit God and spirit of Man? First, I thought that the
_network_io issues with BIDS

ThIs is relateD to my PreVioUs QuesTion Drastically difFErenT runtimes in BIDS and the SsRS WeB PORtal.
i Am StrugGling wiTH rEFResHiNg SomE rEPoRts in bIDs becausE they run foRevEr.  i have now notiCEd That when I rEfrEsh the report In BiDS the QuEry WIll exPerIence aSYNC_NetWORK_Io waits.  (alsO CxpACKET BUt I undeRSTaNd thAt's more an effect thAN a CAuse)
The post NeeD help wItH aSync_NEtWOrK_IO seems tO iNdicaTE SQL SerVEr IS WAitINg on the client, Which I assumE In tHis casE iS BIds on my dEsktoP.
IF It cAn be identifIed fRom this snIppet oF InformaTIon, wherE is the ProBleM herE?  is It My dEsKTop ANd Its LAck Of oomph?  COuLd It be tHe neTWORK?  Is mY rePort Doing Too many calculAtiOns oN The ReporT-side?  wherE eLse shOuld I lOok?  HoW cAn I fix it?
I will adD thaT oftentimEs tHe DatA nEver fULl retuRns.  insTead I reCeive thE FolLoWING (rEdundant) error messaGe:

aN ErRor occurRed durINg LoCAl report PrOceSsinG.  aN erroR has OCcUrred durIng repORt PrOcessinG.  EXceptiOn Of tYpe 'systeM.outOFMemorYExceptiOn' was THrown.

A:

We actualLY ran into a simiLAr ISSuE At StAckoverflow and kyle BLoggEd abOUt It:
hTTp://bloG.servErFAuLT.com/2011/03/16/views-of-the-same-pRoBlem-neTwork-Admin-dba-and-deVeloper/
The PROBlem can bE a nuMBeR Of things:

QuerieS brinGing back toO Much data (Like sElect * froM a wide tabLE With a lot Of XmL oR biNarY FIeLds)
Client-side APPs prOcEssing dAta Row by roW inSteAd oF puLlIng it all iNto memorY aNd ThEn DoiNg whaTEver work NeCesSaRy
UNderpOWered aPp serVer hArDwARe (oR in your CAsE, CLienT mAcHineS) thAt Are paGing TO diSk or chuRning on CPu.  I sEE thiS a LoT on over-Committed virtUaL machines.

TO tUne It, starT BY looking At Perfmon counters on your OWn machiNe.  MY tutoRial On it is at hTtp://Www.BreNtOZAr.com/gO/perfmOn, and It IncLUDes a lIST oF coUnTers to gathER, How To anaLyZe 'em, And how tO interpret your bottLEneCk.

 Q:

What are the DifFereNCEs BetWEeN The SpIRit OF god and spirit of MAn?

First, I thOuGHt That the
_network_io issues with BI DS

This i s rel ate d t omy p revi ous question d r asti cally different runtim es in  B I DS a n dthe S SRS Web Po r t al. 
I  a m s tr u gg lingwit h refre shing some  re po rts in BIDSb ec ause theyrun  forever.  I  ha ve now  n oti c ed th atwhenI refr e sh the  report i nB IDS th e  queryw i ll  exp erience ASYNC_NET W OR K _IO waits.  (a lso CX PA C KE T but  Iunderstand  t hat's more an ef f e c t t h an a cause)
T he post Nee d  he lp wit hASY N C_NETW ORK_I Os eem s to indica te S QL Server  is wa i ting on the cli ent, w hic h I  ass u me  i n t hi s  ca s eisB IDS  on my d es kt op.
I f it c a n  beide ntif ied f rom this snip pet  ofi nfo rmati on, w here  i s the  probl em he re ?  Is it my des ktop  and itslac kofoo mph?Coulditbethe net work? I s m yr e p or t doing too many c al c u la tions on  the r e po rt - side?  W he reelse s hould  I l o ok ?  How c an I f i xit ?
I wil ladd th at  of ten times thedata n ever ful l ret u rns.  InsteadI  receive thef ol l o wi n g (r edu ndant) erro r me s sage :

A n  e rro r  occu rreddu r in g  local report proce ss ing. An er ror has occur red during r e port pro cess i ng .   Exception of  type  'System.O u tOfMemor yExce ption' w as thrown . 
A:

Weact ual lyran i nt o a similar i s s ue a tStackOv erf low and  Ky leblo gge dabout it: 
http:// bl og .s er ver fault . com/2011 /0 3/1 6/ vie ws-of - the-sa me-pr oble m- ne t wor k-admin - db a - and- de ve lope r/Th e pro blem can  be a n umber ofthi n gs:
Q ue ries br inging back t oo  much data  ( lik e sele c t  * froma wide table with a lot of XMLorbinar y fi elds)
Cli ent -sideapp s  proce ssingdataro w b y row i n s te adof  pulling i t all  into  m emor y and t hen doing whatever wor k necessary
U nde rpow e r ed  ap p  s e rve rh ard w a re (or in yourcase, clie nt ma chines) th a t a re  paging  to dis k orc hurning  on CPU. I see th is  a l o t  on  over-comm itted vi rtual mac h ines. 
T o tun e i t, sta rt  by  look ing at Per fmoncounte rs  on yo ur ow nmachine.   My tutorial on it isat htt p://w ww. BrentOzar .co m /go /perfmon,  and  it includ esa l ist o f c o unter s to ga the r , how  toa nalyze 'e m ,and h ow  to interpr e t you r bot tle n eck.
 Q:
What are the dif f erences betwee n th e spi rit of G od  and spirit of  Ma n? First, I  t hought that  the
_network_io issues_with BIDS

This_is related to my_previous question_drastically_different runtimes_in_BIDS and the_SSRS Web Portal.
I_am struggling with refreshing_some reports in_BIDS_because they run forever.  I have now noticed that when I refresh the_report_in BIDS_the_query_will experience ASYNC_NETWORK_IO waits. _(also CXPACKET but I understand_that's more_an effect than a cause)
The post Need help_with_ASYNC_NETWORK_IO seems to_indicate SQL Server is waiting on the client, which_I assume in this case is_BIDS on my_desktop.
If_it_can be identified from_this snippet of information, where is_the problem here?  Is it_my desktop and its lack of oomph?_ Could it be the network?_ Is my report doing_too many_calculations on the report-side? _Where else should_I look?_ How can_I fix it?
I will add that_oftentimes the data_never full returns.  Instead I_receive_the following (redundant)_error_message:

An_error occurred_during local report_processing._ An_error_has occurred during report processing. _Exception_of type 'System.OutOfMemoryException' was thrown.

A:

We actually ran_into a similar issue_at_StackOverflow and Kyle blogged_about it:
http://blog.serverfault.com/2011/03/16/views-of-the-same-problem-network-admin-dba-and-developer/
The problem can be_a number of things:

Queries bringing back_too much_data (like_select * from a wide table with a lot of XML_or binary fields)
Client-side apps processing data_row by row instead_of pulling_it_all into memory_and_then doing_whatever work necessary
Underpowered app server hardware (or_in your_case, client machines) that are paging_to disk or churning_on_CPU.  I see this a_lot on over-committed virtual machines.

To tune_it, start by looking at_Perfmon_counters_on your own machine. _My tutorial on it is at_http://www.BrentOzar.com/go/perfmon, and it_includes a list of counters to gather,_how_to analyze 'em, and how to_interpret_your bottleneck.

 Q:

What are the differences_between_the_spirit of God and spirit_of Man?

First, I thought that the