DataBaser.Net: Build

1 구축가이드
2 참고자료

[edit]

1 구축가이드 #

AlwaysOn Availability Groups in SQL Server 2012(http://www.sqlservercentral.com/articles/AlwaysOn/91408/)
SQL Server 2012 AlwaysOn Availability Groups – Part 3: Setting up AlwaysOn through T-SQL(http://www.sqlpassion.at/blog/PermaLink,guid,6d9a1e7b-5030-4281-8920-9ff1d05526ad.aspx)
Performance impact: hyperthreading for OLTP queries (http://sqlblog.com/blogs/linchi_shea/archive/2012/01/06/performance-impact-hyperthreading-for-oltp-queries.aspx)
시작매개변수
Installing and Configuring SQL Server 2012 Distributed Replay(http://sqlskills.com/blogs/jonathan/post/Installing-and-Configuring-SQL-Server-2012-Distributed-Replay.aspx)
Installing SQL Server 2008R2 on a Windows 2008R2 Core Server(http://www.sqlservercentral.com/articles/Windows+Core/75816/)
New SQL Server AlwaysOn Feature - Part 1 configuration(http://www.mssqltips.com/sqlservertip/2519/new-sql-server-alwayson-feature--part-1-configuration/)
Ports that DBAs Need to Know(http://www.sqlservercentral.com/articles/networking/75481/) --> Ports that DBAs Need to Know.docx
Standardize SQL Server Installations with Configuration Files(http://www.mssqltips.com/sqlservertip/2511/standardize-sql-server-installations-with-configuration-files/)
SQL Server on Windows Server Core part 4 – Sysprep & SQL Server(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 3–Installing 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 2–Configuring Server Core(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 1 Server Core installation(http://feedproxy.google.com/~r/technet/DeepFat/~3/irQszyqh9hs/sql-server-on-windows-server-core-part-1-server-core-installation.aspx)
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1(http://www.sqlservercentral.com/articles/virtual/72682/)
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2(http://www.sqlservercentral.com/articles/Clustering/73989/)
iSCSI + SQL Server 2008(http://ryuchan.kr/28)
가상 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 옵션 설정
SQL Server의 네트워크 데이터베이스 파일 지원에 대한 설명(http://support.microsoft.com/kb/304261) 참고(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

[edit]

2 참고자료 #

Soft NUMA, I/O Completion Thread, Lazy Writer Workers and Memory Nodes(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)
SQL Server 2008 Failover Clustering WhitePaper(http://sqlcat.com/whitepapers/archive/2009/07/08/sql-server-2008-failover-clustering.aspx)
NUMA를 이용한 포트별로 물리적 CPU 분산(http://hyoksong.tistory.com/entry/NUMA를-이용하여-포트별-물리적-CPU를-분산하자)
Deploying Merge Replication Subscribers in SQL Server(http://www.informit.com/articles/article.aspx?p=1392520&rll=1)
Database Mirroring Using T-SQL(http://www.databasejournal.com/features/mssql/article.php/3832106/article.htm)
Installing Hyper-V and Beyond(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)
Cloud Computing with Microsoft Azure SDS(http://www.databasejournal.com/features/mssql/article.php/3828571/Cloud-Computing-with-Microsoft-Azure-SDS.htm)
How To Test Drive SQL Server Clustering For Free(http://blogs.msdn.com/psssql/archive/2009/07/15/how-to-test-drive-sql-server-clustering-for-free.aspx)
Failing SQL 2005 Cluster Installation because of too many cpu's(http://www.sqlservercentral.com/articles/SQL+2005/67297/)
SQL Server 2005 고가용성 구축 및 운영가이드(http://databaser.net/moniwiki_doc/SQL2005_High_Availibility_guide.pdf)
Database Mirroring in SQL Server 2008(http://www.databasejournal.com/features/mssql/article.php/3828341/article.htm)
SQL Server Memory Configuration/Determining MemToLeave Settings
Windows Server Virtualisation: Hyper-V, an Introduction(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)
Sending E-mail from SQL Server 200X(http://www.devx.com/dbzone/Article/42178)
Top load balancing methods for SQL Server(http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1360502_mem1,00.html)
Planning Ahead - Single Node Clusters(http://www.sqlservercentral.com/articles/Clustering/66905/)
Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation(http://technet.microsoft.com/en-us/library/dd459147.aspx)
Using Microsoft Hyper-V for SQL Server consolidation(http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1356566_mem1,00.html)
Calling a Web Service from within SQL Server(http://www.databasejournal.com/features/mssql/article.php/3821271/Calling-a-Web-Service-from-within-SQL-Server.htm)
How to configure Soft-NUMA on a system with > 32 processors?(http://blogs.technet.com/sqlos/archive/2009/05/15/how-to-configure-soft-numa-on-a-system-with-32-processors.aspx)
Using Microsoft Hyper-V for SQL Server consolidation(http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1356566,00.html?track=sy41)
Setting up a SQL cluster under MS VS2005 R2 Part2(http://www.sqlservercentral.com/articles/Clustering/66246/)
Setting up a SQL cluster under MS VS2005 R2 Part1(http://www.sqlservercentral.com/articles/Clustering/65994/)
Peer-to-Peer Replication in SQL Server 2008 ? Configure a two-node topology(http://www.databasejournal.com/features/mssql/article.php/3814591/article.htm)
Installing SQL Server 2008 on a Windows Server 2008 Cluster(http://www.mssqltips.com/tip.asp?tip=1721)
SQL Server 2008: Performance Data Collector(http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/)
Setting up a Two-NODE SQL Server 2008 Cluster from the Command Prompt - Integrated Installation(http://www.databasejournal.com/features/mssql/article.php/3772826)
How to Rebuild System Databases in SQL Server 2008(http://blogs.msdn.com/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx)
SQL 2005에서 웹 서비스 구현하기(http://bybi.tistory.com/425)
New HTTP Endpoints Create SQL Server 2005 Web Services(http://www.codeguru.com/cpp/i-n/internet/http/print.php/c7887__2/)
Easy Web Services with SQL Server 2005 HTTP Endpoints(http://www.devx.com/dbzone/Article/28525/1954)
How to create a SQL Server linked server to DB2(http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1326266,00.html?track=sy200)
Configure and Manage Policy Based Management in SQL Server 2008(http://www.sql-server-performance.com/articles/dba/Configure_and_Manage_Policy_Based_Management_in_SQL_Server_2008_p1.aspx)

Contents

1 구축가이드 #

2 참고자료 #