sql server performance

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: izumi (test_at_test.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 17:40:37 +0800

I posted message before about 10GB database , generated report very
slowly(Using RAID 5 ).... Many people suggest me to create filegrpup on that
data file

Now I set up server to test that 10GB data....and report speed.....

there are total 5 disks

2 for OS, RAID 1 setting

3 for sql data(2 for RAID 0, 1 for normal harddisk)

that mean have C, D, E drive

C for OS

D for sql data

E for log

after that I wil create different file for data file(that mean seperate
d:/data/mdf to different disk)

any comments to me to let report generate much more faster??????

Relevant Pages

  • sql server performance
    ... I posted message before about 10GB database, generated report very ... slowly(Using RAID 5).... ... there are total 5 disks ...
    (microsoft.public.sqlserver.server)
  • sql server performance
    ... I posted message before about 10GB database, generated report very ... slowly(Using RAID 5).... ... there are total 5 disks ...
    (microsoft.public.sqlserver.server)
  • Re: A8N-E RAID 1
    ... Maybe this is something you can report to Asus tech support. ... RAID problem. ... >>> with no warning icons. ...
    (alt.comp.periphs.mainboard.asus)
  • Re: bad blocks on raid5 cause filesystem failure
    ... > fail at the same time, before rebuild can finish parity on the first, ... At some point, the RAID ... > controller should, like you say, stop all host IO and report the drive ... You are 100% right though about the RAID array not working properly. ...
    (comp.os.linux.hardware)
  • Re: Polygamist Sect Mothers Deny Allegations of Abuse: "A Wonderful Pure Life"
    ... < investigating the report, abuse is found, it has to be acted on. ... FACTS they CHOSE NOT to share with the judge as they got their warrants. ... I don't think fake calls by the woman in Colorado were connected to "Sarah" from the compound until a few days after the raid. ...
    (alt.true-crime)