Problem solved....

It looks as if the INSERT takes more time to process because of the hardware raid controller cache. Now i...

Problem solved....

It looks as if the INSERT takes more time to process because of the hardware raid controller cache. Now i encapsulate...

Updatet stats, dbcc updateusage after restoring....no effect.

in the query plans i found the following:

"slow" system : each INSERT duration 25-30, reads ~20

"fast" system : each INSERT duration 0-1, reads 0

so...

I compared the results from sp_configure advanced. Both servers are configured exactly the same.

The tables, keys and indexes are created on both servers with the same stored procedure. So...

I found checking the query plans that the INSERT's seem to cause the trouble.

On "fast" devsystem, i've 0-1 duration and 0-1 reads

On "slow" testsystem, 've about 16-20 duration and ~20...

Writing cache is enabled on the "fast" developer system, so it is on the "slow" system. I'll check if there is an performance increase when disabling write cache on the...

Anyone has some ideas ?

No success. But I don't think rebuilding indexes or update statistics will help me, because of the import process.

Every day there starts an .NET...

Hmm,

I detached, moved and attached the database. I'll try to rebuild indexes and update statistics. Hope this will help me a bit.

I'll give feedback if i've success, thanks so far...

1) Yes, both servers are plugged into the same switch

2) Hard drives configuration is different. It looks this way :

"fast" dev system:

• single disk, contains only sql databases
• Seagate ST3808110AS Barracuda 80...

It's a hardware raid, no software is used...

"fast" dev system:

• single disk, contains only sql databases
• Seagate ST3808110AS Barracuda 80 GB
• 7200 RPM
• 8,5 ms
• S-ATA II
• 8 MB Cache

"slow" test system:

• contains only sql databases
• SATA Raid1, 2 disks
• same as above

May the raid be...

Ok, I'll give you an overview of the hardware currently used...

Dev System:

• Windows Server 2003 Standard Edition
• SP 1
• 1.5 Gb RAM
• 3.00 GHz DualCore
• 100 MBit Network

Test System:

• Windows 2003 Standard Edition
• SP 1
• 2.0 Gb RAM
• 3.2...

Database filesize is the same on both system, they extend in the same way.

I think dbcc dbreindex can't be the way for me, because of the follwoing situation:

I create a...