ProLiant Servers (ML,DL,SL)
1830732 Members
1795 Online
110015 Solutions
New Discussion

Hp Proliant Ml 350 G6 too slow running SQL 2008

 
SOLVED
Go to solution
Danilo Camacho
Occasional Contributor

Hp Proliant Ml 350 G6 too slow running SQL 2008

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?
9 REPLIES 9
marcus1234
Honored Contributor

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

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
Danilo Camacho
Occasional Contributor

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

I've donne that but the problem is the same too slow
Bleeder
Frequent Advisor
Solution

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

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).
marcus1234
Honored Contributor

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

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..
marcus1234
Honored Contributor

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

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

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

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

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

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

THANK'S

Danilo Camacho
Occasional Contributor

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

Problem fixed by enabeling de write cache on the array.
marcus1234
Honored Contributor

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

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:)