#title Build [[TableOfContents]] ==== 구축가이드 ==== * [http://www.sqlservercentral.com/articles/AlwaysOn/91408/ AlwaysOn Availability Groups in SQL Server 2012] * [http://www.sqlpassion.at/blog/PermaLink,guid,6d9a1e7b-5030-4281-8920-9ff1d05526ad.aspx SQL Server 2012 AlwaysOn Availability Groups – Part 3: Setting up AlwaysOn through T-SQL] * [http://sqlblog.com/blogs/linchi_shea/archive/2012/01/06/performance-impact-hyperthreading-for-oltp-queries.aspx Performance impact: hyperthreading for OLTP queries ] * [시작매개변수] * [http://sqlskills.com/blogs/jonathan/post/Installing-and-Configuring-SQL-Server-2012-Distributed-Replay.aspx Installing and Configuring SQL Server 2012 Distributed Replay] * [http://www.sqlservercentral.com/articles/Windows+Core/75816/ Installing SQL Server 2008R2 on a Windows 2008R2 Core Server] * [http://www.mssqltips.com/sqlservertip/2519/new-sql-server-alwayson-feature--part-1-configuration/ New SQL Server AlwaysOn Feature - Part 1 configuration] * [http://www.sqlservercentral.com/articles/networking/75481/ Ports that DBAs Need to Know] [attachment:Build/sql_server_ports.docx --> Ports that DBAs Need to Know.docx] * [http://www.mssqltips.com/sqlservertip/2511/standardize-sql-server-installations-with-configuration-files/ Standardize SQL Server Installations with Configuration Files] * [http://feedproxy.google.com/~r/technet/DeepFat/~3/BHi2eyrlJrU/sql-server-on-windows-server-core-part-4-sysprep-amp-sql-server.aspx SQL Server on Windows Server Core part 4 – Sysprep & SQL Server] * [http://feedproxy.google.com/~r/technet/DeepFat/~3/kYTMbqp-zAQ/sql-server-on-windows-server-core-part-3-installing-sql-server.aspx SQL Server on Windows Server Core part 3–Installing SQL Server] * [http://feedproxy.google.com/~r/technet/DeepFat/~3/MAYI7Ty_4aM/sql-server-on-windows-server-core-part-2-configuring-server-core.aspx SQL Server on Windows Server Core part 2–Configuring Server Core] * [http://feedproxy.google.com/~r/technet/DeepFat/~3/irQszyqh9hs/sql-server-on-windows-server-core-part-1-server-core-installation.aspx SQL Server on Windows Server Core part 1 Server Core installation] * [http://www.sqlservercentral.com/articles/virtual/72682/ Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1] * [http://www.sqlservercentral.com/articles/Clustering/73989/ Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2] * [http://ryuchan.kr/28 iSCSI + SQL Server 2008] * [attachment:Build/StarWind.docx 가상 iSCSI 구성환경 구성 프로그램 StarWind] [http://www.dbnuri.com/mboard/mboard/mboard.asp?board_id=comm_pds&group_name=board&idx_num=8&page=1&category=&search=&b_cat=0&order_c=idx_num&order_da=desc 출처] * [MSCS 구축가이드] * [AWE 옵션 설정] * [http://support.microsoft.com/kb/304261 SQL Server의 네트워크 데이터베이스 파일 지원에 대한 설명] [http://www.sqldba.org/articles/43-sql-server-database-on-UNC-network-drive-trace-flag-1807.aspx 참고] * Trace Flag * http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1110445,00.html * http://sqlserverpedia.com/wiki/Trace_Flags ==== 참고자료 ==== * [http://blogs.msdn.com/psssql/archive/2010/04/02/how-it-works-soft-numa-i-o-completion-thread-lazy-writer-workers-and-memory-nodes.aspx Soft NUMA, I/O Completion Thread, Lazy Writer Workers and Memory Nodes] * [http://sqlcat.com/whitepapers/archive/2009/07/08/sql-server-2008-failover-clustering.aspx SQL Server 2008 Failover Clustering WhitePaper] * [http://hyoksong.tistory.com/entry/NUMA를-이용하여-포트별-물리적-CPU를-분산하자 NUMA를 이용한 포트별로 물리적 CPU 분산] * [http://www.informit.com/articles/article.aspx?p=1392520&rll=1 Deploying Merge Replication Subscribers in SQL Server] * [http://www.databasejournal.com/features/mssql/article.php/3832106/article.htm Database Mirroring Using T-SQL] * [http://www.simple-talk.com/exchange/exchange-articles/installing-hyper-v-and-beyond/?utm_source=simpletalkExchange&utm_medium=email&utm_content=Hyper-V-20090803&utm_campaign=Exchange Installing Hyper-V and Beyond] * [http://www.databasejournal.com/features/mssql/article.php/3828571/Cloud-Computing-with-Microsoft-Azure-SDS.htm Cloud Computing with Microsoft Azure SDS] * [http://blogs.msdn.com/psssql/archive/2009/07/15/how-to-test-drive-sql-server-clustering-for-free.aspx How To Test Drive SQL Server Clustering For Free] * [http://www.sqlservercentral.com/articles/SQL+2005/67297/ Failing SQL 2005 Cluster Installation because of too many cpu's] * [http://databaser.net/moniwiki_doc/SQL2005_High_Availibility_guide.pdf SQL Server 2005 고가용성 구축 및 운영가이드] * [http://www.databasejournal.com/features/mssql/article.php/3828341/article.htm Database Mirroring in SQL Server 2008] * [SQL Server Memory Configuration/Determining MemToLeave Settings] * [http://www.simple-talk.com/exchange/exchange-articles/windows-server-virtualisation-hyper-v,-an-introduction/?utm_source=EmailDirect.com&utm_medium=Email&utm_campaign=ST+Exchange+-+22/06/09+-+Live Windows Server Virtualisation: Hyper-V, an Introduction] * [http://www.devx.com/dbzone/Article/42178 Sending E-mail from SQL Server 200X] * [http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1360502_mem1,00.html Top load balancing methods for SQL Server] * [http://www.sqlservercentral.com/articles/Clustering/66905/ Planning Ahead - Single Node Clusters] * [http://technet.microsoft.com/en-us/library/dd459147.aspx Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation] * [http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1356566_mem1,00.html Using Microsoft Hyper-V for SQL Server consolidation] * [http://www.databasejournal.com/features/mssql/article.php/3821271/Calling-a-Web-Service-from-within-SQL-Server.htm Calling a Web Service from within SQL Server] * [http://blogs.technet.com/sqlos/archive/2009/05/15/how-to-configure-soft-numa-on-a-system-with-32-processors.aspx How to configure Soft-NUMA on a system with > 32 processors?] * [http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1356566,00.html?track=sy41 Using Microsoft Hyper-V for SQL Server consolidation] * [http://www.sqlservercentral.com/articles/Clustering/66246/ Setting up a SQL cluster under MS VS2005 R2 Part2] * [http://www.sqlservercentral.com/articles/Clustering/65994/ Setting up a SQL cluster under MS VS2005 R2 Part1] * [http://www.databasejournal.com/features/mssql/article.php/3814591/article.htm Peer-to-Peer Replication in SQL Server 2008 ? Configure a two-node topology] * [http://www.mssqltips.com/tip.asp?tip=1721 Installing SQL Server 2008 on a Windows Server 2008 Cluster] * [http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/ SQL Server 2008: Performance Data Collector] * [http://www.databasejournal.com/features/mssql/article.php/3772826 Setting up a Two-NODE SQL Server 2008 Cluster from the Command Prompt - Integrated Installation] * [http://blogs.msdn.com/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx How to Rebuild System Databases in SQL Server 2008] * [http://bybi.tistory.com/425 SQL 2005에서 웹 서비스 구현하기] * [http://www.codeguru.com/cpp/i-n/internet/http/print.php/c7887__2/ New HTTP Endpoints Create SQL Server 2005 Web Services] * [http://www.devx.com/dbzone/Article/28525/1954 Easy Web Services with SQL Server 2005 HTTP Endpoints] * [http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1326266,00.html?track=sy200 How to create a SQL Server linked server to DB2] * [http://www.sql-server-performance.com/articles/dba/Configure_and_Manage_Policy_Based_Management_in_SQL_Server_2008_p1.aspx Configure and Manage Policy Based Management in SQL Server 2008]