I think many of us have faced the challenge to make the design of SQL for their System Center components. Even though we have knowledge of SQL at some certain level we are not hardcore experts in it. Thanks to Paul Keely a Microsoft MVP we now have some guides on dealing with SQL for System Center. You can download his guide
“SQL Server guide for System Center 2012” which for SQL 2008 R2 but there is no reason to use the same tips for SQL 2012.