Monday, March 4, 2013

[SQL 2012] Disk configuration

[SQL 2012] Disk configuration


Disk configuration

Posted: 03 Mar 2013 11:05 PM PST

Hi,I'm getting a new server this week and have some say in the disk configuration. Basically i've got 2 600GB SAS drives configured in RAID1 for the OS (Windows Server 2008R2 64Bit Std). I've then got 12 7.2k SAS disks for the data/logs giving 6TB of storage.My question is this....Is there any performance advantage to be had by separating logs from data files. This is going to be a data warehousing server...Ignoring the OS partition because there's nothing i can really do there....Is it more sensible to have a) 4 disks in a RAID 10 config for logs and then 8 disks in RAID 10 for Data?b) 12 disks in RAID 10 and have data and logs on the same drives?With regards to TempDB what would you do? Put it on the faster OS disks? or split it amongst the 4/8 or 12 disk configs?Thanks for your help!Simon

SQL Server Express and SQL Server Agent?

Posted: 03 Mar 2013 07:33 AM PST

I just installed SQL Server Express with Advanced Services but can't manage to get SQL Server Agent service started...[url=http://msdn.microsoft.com/en-us/library/cc645993.aspx][u]Features Supported by the Editions of SQL Server 2012[/u][/url] seems to indicate that SQL Server Agent is not supported with the Express EditionHowever, sql server agent seems installed...Is there anyway to get it working?I find slightly silly to install it with SQL Server Express if it's not meant to work??? :angry:

No comments:

Post a Comment

Search This Blog