Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-08-22 : 10:24:26
|
| We just moved one of our heavist databases 7 gig not great in size to a RAID 1 and the disk load still hits 100 during some heavy use.Is this something to do with the disk itself not properly configured with spindles or luns ? Not up to date on this just take the Drives for SQL when assigned them.Thanks |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-08-22 : 10:33:44
|
| What do you mean by "disk load still hits 100"?CODO ERGO SUM |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-08-22 : 15:30:36
|
| The logical disk shows it as 100 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-22 : 22:18:07
|
| Disk time or queue length? Raid 1 doesn't mean better performance by default. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-08-23 : 12:11:57
|
| Disk Time how busy the disk is |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-23 : 23:38:11
|
| If the db is really heavily used, you should add more data files in it and put them on seperate disk arrays. |
|
|
|
|
|
|
Disk Load