topic Re: Hp Proliant Ml 350 G6 too slow running SQL 2008 in ProLiant Servers (ML,DL,SL)

Hp Proliant Ml 350 G6 too slow running SQL 2008

Danilo Camacho — Thu, 10 Dec 2009 16:44:27 GMT

I've instaled a G6 Ml 350 whith Windows Small Busibess Server 2008 and Sql 2008 server for sbs. For some reason de aplication that creates databases in Sql is to slow. To creat a simple Database it takes about 7 minutes. I've made de same instalation on a Hp Ml350 G5 and the same process is done in 50 second's. How can'i resolve this problem?

Re: Hp Proliant Ml 350 G6 too slow running SQL 2008

marcus1234 — Thu, 10 Dec 2009 20:35:20 GMT

hmmmm ,,danilo boot from firmware maintenance cd 8.6

then install software cd rom 8.3 via the os
reboot if all is okay, then fine

if not boot from the software cd rom 8.3 and run full diagnostics,,
This is how we thank in the forum

http://forums11.itrc.hp.com/service/forums/helptips.do?#33

Re: Hp Proliant Ml 350 G6 too slow running SQL 2008

Danilo Camacho — Fri, 11 Dec 2009 17:24:10 GMT

I've donne that but the problem is the same too slow

Re: Hp Proliant Ml 350 G6 too slow running SQL 2008

Bleeder — Fri, 11 Dec 2009 19:33:00 GMT

I had same problem and it was because server did not have battery for P410i RAID controller. Had to buy battery separate. Then make sure to enable write cache in acu (array configuration utility).

Re: Hp Proliant Ml 350 G6 too slow running SQL 2008

marcus1234 — Fri, 11 Dec 2009 22:43:42 GMT

yes sql does really nead cache and battery preferances for read write should be selected after using msoft tol that monitors sql read writes, usually option is 70% 30%

but you are just installing the data base and have not got so far yet correct..

Re: Hp Proliant Ml 350 G6 too slow running SQL 2008

marcus1234 — Sun, 13 Dec 2009 18:30:30 GMT

how abou t copying files from local usb stick to hdd is that slow too..

Re: Hp Proliant Ml 350 G6 too slow running SQL 2008

Bleeder — Mon, 14 Dec 2009 15:47:29 GMT

There is also a new Smart Array firmware 2.72 that has a couple enhancements to improve performance under certain circumstances.

Re: Hp Proliant Ml 350 G6 too slow running SQL 2008

Danilo Camacho — Mon, 14 Dec 2009 16:03:20 GMT

I FIX TRE PROBLEM ENABELING DE WRITE CACHE N THE ARRAY CONFIGURATION

THANK'S

Re: Hp Proliant Ml 350 G6 too slow running SQL 2008

Danilo Camacho — Mon, 14 Dec 2009 16:05:34 GMT

Problem fixed by enabeling de write cache on the array.

Re: Hp Proliant Ml 350 G6 too slow running SQL 2008

marcus1234 — Mon, 14 Dec 2009 19:27:21 GMT

Danilo as you are new to forums

This is how we thank in the forum

http://forums11.itrc.hp.com/service/forums/helptips.do?#33

Enjoy:)