ProLiant Servers (ML,DL,SL)
1748103 Members
4782 Online
108758 Solutions
New Discussion

SQL Server performance problems?

 
Ayman Altounji
Valued Contributor

SQL Server performance problems?

I have a Compaq DL360 with an integrated smart array controller which seems to have problems when running a simple SOL script.

The SOL script is just a loop inserting approx. 750 bytes into tables.

On other systems, it takes only 5-6 minutes to insert 50000 rows.
On the Compaq DL360 system, it takes about 30 minutes.

The systems are comparable in CPU speed and RAM size as well as disk speeds.

Does anybody know of any problems or settings that need to be set when using the DL360 with an integrated smart array controller?

It seems like the DL360 or TN's interaction on the DL360 is limiting the number of I/So that get sent to the disks.

Dave
1 REPLY 1
Ayman Altounji
Valued Contributor

Re: SQL Server performance problems?

The "problem" is with the integrated controller. It does not have any write cache, so the I/Os are limited by what the disks can physically do. SQL Server performs synchronous writes to the log to ensure recoverability and this is most likely causing the slowdown. Don't use the internal disks for anything but storing static information and applications.