April 19, 2011 at 4:35 am
Hello out there,
I would imagine what I am asking comes down to preference, but I'd just interested to know that if you had several instances on a machine, separate drives for data and logs, would you bother splitting the data up on the drive by creating a folder for each instance? I like to be mega organized, but was wondering what other people liked to do.
EG
Data drive
instance1_data
instance2_data
log drive
instance1_logs
instance2_logs
Thanks for reading!
D.
April 19, 2011 at 5:48 am
For named instances, we use mount points and a small piece of disk as the root. Example of mounted disk labels/config: I1_Data, I1_Log, I1_Tempdb, I1_System , where I1 is the 1st named instance. It is borderline micro management.
April 19, 2011 at 5:59 am
First of all you should know the Server specification as
TOTAL CPU physical and logical
TOTAL RAM
TOTAL SQL SERVER RAM
OPERATING SYSTEM Version and 32bit or 64bit
TOTAL drivers not Partition
INSTANCE tuning is based upon available resources and hardware
Its depend on the available resources,If you create the multiple instances of SQL Server then you should assign Processors and RAM to each other separately ,For processors you use Soft-NUMA and you can use also HARD-NUMA which one is depends on the Server Vendor
Second thing is if you have a single Drive so you dont need to take data and logs files in different parition because there is no performance benefits on a single head or single drive you can say
Third thing is if you have multiple drives or head or if you are using SAN drives then it will gives you performance advantage like drive should be as
DATA 1
INDEX 1
LOG 1
MSSQL (SQL Server binaries or installation files you can say)
or
DATA 1 -For base tables Filegroup
DATA 2 -For Transaction tables Filegroup
INDEX 1 -For base tables Index Filegroup
INDEX 2 -For Transaction tables Index Filegroup
LOG 1 Its mendatory Point time recovery
LOG 2 Its for backup if LOG 1 will be full
MSSQL (SQL Server binaries or installation files you can say)
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 19, 2011 at 7:07 am
Thank you everyone for your replies, I am indeed using a SAN and have another separate drive for the program files.
Regards,
D.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply