SQL Server Dual Processors INSERTS take long time

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: FandCDev2 (FandCDev2_at_discussions.microsoft.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 14:21:01 -0800

I've got a C# console app. that does around 300,000 inserts in a row. I know
this isn't the best way to do inserts, but for the app. design it is what we
need to do. I've set the Recovery Model to simple. When I run the app. on
my desktop (3Gh, 3Gig Ram, Win XP, etc..) it takes about 25min to complete.
When I run the app. on our server(Dual 3Gh, 4Gig RAM, seperate SCSI hard
drives for db(RAID 0) and OS, Windows 2000 Server) it takes over 3 hours.
I've verified every setting in SQL is configured the same, tried limiting SQL
to only 1 CPU, but haven't found anything. I've written small programs that
check file I/O times, and it is a lot faster on the server. I've tried doing
a bunch of DB SELECTS followed by DB INSERTS, and found that the SELECT
times are about par between my desktop and the server, but the INSERT times
are about 5 times higher.

Relevant Pages

  • Re: Selling the boss on a "publish to the web" Access app?
    ... Go to www.officelive.com, this free small business edition is only available to North America customers right now however. ... Are the users app specific where certains users can log into that app or have rights to it but not others? ... The person coming in the door that wants to sell new carpets or new desks or a new paint job on the walls or even a new computer has to justify that they're going to save the company money. ... I suppose you could bring in a whole bunch of IT people, and go through all enormous expenses and dangers of security of setting up a web host server. ...
    (comp.databases.ms-access)
  • Re: Homegrown synchronization
    ... to check for update files in the Import DropBox for the server. ... similar to the import code used to update a remote backend). ... code to close the "sync" app. ... synch app, but only one at a time would be able to do synchs. ...
    (microsoft.public.access.replication)
  • RE: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Ruby Enterprise App Design Advice
    ... Load balanced to send user to best server. ... FastCGI or SCGI - We would like to replace FastCGI with something ... certain instance and want to have a single session server (if I understand ... deals with login and logout and assigns an app server. ...
    (comp.lang.ruby)
  • Help needed: TCP Server questions/problems
    ... I know very little about writing server applications. ... I like to think that when clients ... it as a console app I could write out messages to the console telling ... console app but the service app seems unable to do this. ...
    (microsoft.public.dotnet.languages.vb)