Reply to SQL Server on production very slow

Your name:

Reply:


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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация