asked on
ASKER
Everything depends on the needs and the expected workload.
You can put system databases, tempdb and everything on the same disk.
If you can measure your expected workload and size of your database(s) than you can start to plan the environment.very less to medium workload.
ASKER
You have to match the available IOPS to the application.
OS/SQL Software can be RAID5/6, and maybe even SQLDB but logs/tempdb should be raid 1/10
adjust the LUN RW percentages
ASKER
Not the raid array.. as a raid array can have multiple LUN's
as a raid array can have multiple LUN's
ASKER
3) RDM disk is good for MS SQL in VMWare environment.
4) is VMWare dependent of independent disk is good for MS SQL ?
5) RAW disk for MS SQL is good ?
ASKER
ASKER
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY
ASKER
sorry which one are you referering to ? any URL to support this is better?
please assume all virtua.