Performance problem Loading Dataset inside a virtual.

Posted by ShaneH on Stack Overflow See other posts from Stack Overflow or by ShaneH
Published on 2009-10-07T13:13:36Z Indexed on 2010/05/01 9:07 UTC
Read the original article Hit count: 267

Filed under:
|
|

Host Configuration:

  • HP EliteBook 8530w
  • 4G Ram
  • Win7 Ultimate 64Bit RC
  • SQL Server 2005 64bit Developer Edition

Virtual:

  • Windows Virtual PC
  • 1G Ram allocated
  • Integration Services installed
  • Windows XP 64bit
  • Up to date service packs and .Net framework through 3.5 SP1
  • Sharing the Gigabit network adapter of the Host

I have a simple .Net console application which loads a dataset of approximately 37K rows. Running the application on the host executes in approximately 4 seconds. Running inside the virtual takes 729 seconds. The size of the application grows to about 65Mb when the dataset is finished loading, no calculated columns or event handlers are attached.

[edit] I changed the virtual to use a loopback adapter to communicate with the host and performance is now on par with running on hardware.

Any ideas as to why it would going over the network adapter be almost 200x longer? TraceRt shows that the connection is only one hop.

Thanks, Shane Holder

© Stack Overflow or respective owner

Related posts about .NET

Related posts about virtual