SQL and IIS HDDs configuration on server

Posted by john_1234 on Server Fault See other posts from Server Fault or by john_1234
Published on 2011-01-17T15:23:24Z Indexed on 2011/01/17 22:55 UTC
Read the original article Hit count: 128

Filed under:

sql-server

|

hdd

Hi,

I've just added a new production server and I was wondering if you guys could help me decide which configuration suits best.

Current configuration:

40GB ~ C (System)
250GB ~ D (SQL - MDF & LDF)
250GB ~ F (IIS)
1TB ~ E (storage of users' files)
(note: C and D are partitions on the same physical HDD)

I've heard splitting LDF/MDF can do magic in terms of performance. Therefore, the core of my question is how would you recommend to do so. For example, putting the MDF with the IIS is an option, yet I'm not so sure about it.

© Server Fault or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about hdd

Installing Ubuntu 10.04 to external HDD overwrites the MBR of the internal HDD

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have a Asus A42F laptop which has Windows 7 32 bit installed on it's internal HDD. I have just installed Ubuntu 10.04 on a portable HDD using the laptop. Now my laptop does not boot Windows 7 if the portable HDD is disconnected. I can only get the boot menu when the portable HDD is connected. The… >>> More
Problem with running sata hdd with pata hdd.

as seen on Super User - Search for 'Super User'
There's a problem when I try to connect my pata hdd(slave) with the sata hdd(primary). The computer sometimes detects the drive and sometimes not. How can I fix this problem? >>> More
Fedora-13 not detecting USB HDD enclosure (with HDD)

as seen on Super User - Search for 'Super User'
I recently purchased this enclosure: http://www.amazon.com/Inland-2-5-Inc.../dp/B003SZ2Y12 and this HDD: http://www.amazon.com/Seagate-Barrac...3811667&sr=8-1 Now, I let my brother in law use the enclosure with his 160GB disk to back some stuff up. He then gave me that disk in my enclosure… >>> More
Moving windows-2003 hdd into virtual machine - with HDD shrink

as seen on Super User - Search for 'Super User'
Before you vote to close as exact duplicate, please read the full question. I was already read: Can I make a virtual machine out of a Windows XP physical machine? Disk2vhd,convert my PC to Hyper-V Virtual Machine Creating a Windows Virtual PC image from a Physical machine physical machine to virtual… >>> More
How to copy files from HDD to HDD with integrity checking

as seen on Super User - Search for 'Super User'
I am moving data from an almost dead HDD to an external USB drive using linux , because for some reason Windows cannot see the data. I want to copy a large amount of data over from the HDD to the USB drive with integrity checking. I thought about copying everything over and then checking with md5summer… >>> More