sql server performance
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date: Sat, 24 Apr 2004 00:05:15 +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) |
|
