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 |
|
racinghart
Starting Member
49 Posts |
 Posted - 2007-02-05 : 18:02:15
|
| can someone explain or link me to some reading material regarding best practice for setting up a sql server (solomon dynamics server)... we are using windows server 2003 R2 and SQL Server 2005. We have partitioned two drives... one 36GB for solomon Log files and 36GB for solomon Data files... our actual solomon database will be hosted on a huge MSA1000 device. Just wondering if this is the best practice for setting it up |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-05 : 18:06:07
|
| I've never heard of solomon dynamics server, but I'll provide my input anyway.SQL Server 2005 supports mount points. I would highly suggest using mount points if your storage solution supports them. We setup 3 different mount points for most of our instances:Backup --BAKs, TRNsData --MDFs, NDFsLog --LDFsI'd recommend using perhaps 2 mount points (1 for Data and 1 for Log) per database if the database is IO intensive. For a best practice though, I'd suggest contacting the vendor.Tara Kizer |
 |
|
|
racinghart
Starting Member
49 Posts |
Posted - 2007-02-05 : 18:11:53
|
| so you are saying you separate backup, data, and log files on three separate physical disks or partitions? |
|
|
|
racinghart
Starting Member
49 Posts |
Posted - 2007-02-05 : 18:17:25
|
| we have decided to put the data files on the msa1000 and on the sql server itself we have partitioned 36Gb for Log and another 36Gb for backup files. hows that sound? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-05 : 18:31:13
|
quote:
Originally posted by racinghart
so you are saying you separate backup, data, and log files on three separate physical disks or partitions?
Well they are separate mount points, which would sort of equate to a partition. Our 3 mount points exist on one drive letter. To the OS, they look like folders. But underneath they act more like a different partition. Mount points are used for performance. SQL Server 2000 did not support them, but 2005 does. We are using Veritas Volume Manager with a Hitachi SAN I believe.Tara Kizer |
|
|
|
racinghart
Starting Member
49 Posts |
Posted - 2007-02-05 : 19:04:50
|
| thanks again everyone. and thanks for answering again tara you seem to have so far answered all my questions... i got one more coming to you in a separate thread though haha. |
|
|
|
|
|
|
setting up new sql server for solomon dynamics