|
|
Posted by Roy Harvey on 08/16/06 19:50
Compare the hard drive configurations. SQL Server is, after all, a
database system, and disk performance is overwhemlingly important.
More important than CPU or memory for a single load process. Factors
that could slow such a process down include logs not isolated on their
own drives and RAID 5, always slow on writes. Of course combining
those two could be particularly bad.
Next, where is the data coming from? Over the network? From another
hard drive on the same server? From the same hard drive as the
database files? Is the location of the data the same for both
servers?
Roy Harvey
Beacon Falls, CT
On 16 Aug 2006 12:36:04 -0700, "Volks" <patrick.simard@isac-inc.com>
wrote:
>Hi,
>
>It takes 4 minutes to insert 40 000 records on a SQL Server and 40 sec
>on an other SQL Server. The slower run on windows 2000 terminal server
>and the faster on windows 2000. The slower The slower have 2 Go of
>ram, the faster 512 Mo!!!
>
>How to diagnostic what's going wrong on the slower server? I can't
>change the application who do the insertions.
Navigation:
[Reply to this message]
|