Posted by bie2 on 01/17/07 19:59

Hi,


I ran test data on my development machine and it took 1 minute to
insert the data. Ran the same set of data on the server and took 5
minutes.

Check both database and everything is the same. I even copied the
production DB on my machine and it was taking still about 1 minute.
Look at the fragmentation, and all the numbers are better on the server
than my development machine so it should be faster.

In the application I put some timer and discover that the insert is
taking 0.015 ms on the server and 0 on the development. So the problem
is on the insert.

It is a Web application using ASP.NET.

Here are the spec of the computers:

Development: P4 HT 3.2GHz 1gig memory running WIN XP
Server: Xeon 2.8GHz 1.5Gig memory running WIN 2000 server

Any idea how I to pinpoint the problem? I'm not at the point of
thinking that it can be the hardware, but how to verify that?

Thanks
Frank

• Next in forum: Re: SQL Server on production very slow
• Prev in forum: Re: Disappearing Records
• Thread view: SQL Server on production very slow

[Reply to this message]