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 |
|
dacul
Starting Member
1 Post |
 Posted - 2012-05-18 : 06:51:06
|
| Hello!Need to decide how to organize the DB server under MSSQL2005. There are simultaneously full-time working 3 DBs (12GB, 3GB, 3GB), and other 5 DBs whith similar sizes which are not so intensive use (accessed periodicaly). The task Manager shows for I/O Read bytes and I/O write Bytes very close values for the sqkservr.exe - all of databases are working under one server which seems to have I/O issues. We move it to an other server.Have six SAS 146GB, 15k HDD for DBs.My thoughts about how to organize it:Variant1.create 3 RAID1: 1st and 2nd for MDF files of different DBs, and the 3rd for all LDF files. So I can separate different DBs on two different physical disks.Variant2.one RAID1 for LDF files and one RAID10 (4 disks) for MDF files. All DBs will work on one single RAID10, but which is faster than RAID1.Note: on both variants the OS will be installed on RAID1 (two SAS 300GB, 10k HDDs) on the same server.PS: I'm thinking about virtualization. The hypervisor (VMWare) on SD Card, Virtual machines (OS) on the Raid1 (2*300GB HDDs) and Databases as described earlier V1 or V2.PPS: Server is HP DL360G7 with 24 GB of memory.Thank you, for any ideea. |
|
|
boybawang
Starting Member
15 Posts |
Posted - 2012-05-22 : 00:31:42
|
| Organizing mainly database operations can be simplified in a simplier but nicer way. |
 |
|
|
|
|
|
How to organize the DB server