{"id":69260,"date":"2021-08-16T04:10:04","date_gmt":"2021-08-16T08:10:04","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/scaling-out-38\/"},"modified":"2021-08-16T04:10:04","modified_gmt":"2021-08-16T08:10:04","slug":"scaling-out-38","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69260","title":{"rendered":"Scaling Out #38"},"content":{"rendered":"<p>Methods<\/p>\n<ul>\n<li> SQL Server instances <\/li>\n<li> Clustering <\/li>\n<li> Database mirroring <\/li>\n<li> Log shipping <\/li>\n<li> Replication <\/li>\n<li> Shared scalable databases<\/li>\n<\/ul>\n<li> SQL Server instancesIn the same computer install multiple instance of SQL Server to take advantage of multiple processors. Each instance may use separate processor with separate lock manager, worker threads, tempdb system database.\n<\/li>\n<li> ClusteringFailover Clustering can provide robustness and protection against failure. Clustering can provide scaling using spare hardware through passive nodes\n<\/li>\n<li> Database mirroringWith database mirroring transaction logs are directly sent to the mirror. The mirror is up to date and can be used in case of failure of the principle server.\n<\/li>\n<li> Log shippingIt depends on the transaction log backups, file copying. The secondary database need not to be updated in real time. The secondary database is read only and hence, be in great use for reporting purposes.\n<\/li>\n<li> ReplicationMerge Replication: Both way, both from and to publishers and subscribers<br \/>Transactional Replication: Publisher to the subscriber\n<\/li>\n<li> Shared scalable databasesScale out a read-only database only for reporting purposes.<\/li>\n<p>From: http:\/\/sitestree.com\/?p=4806<br \/> Categories:38<br \/>Tags:<br \/> Post Data:2007-05-23 02:02:25<\/p>\n<pre><code>    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\"&gt;https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    (Big Data, Cloud, Security, Machine Learning): Courses: &lt;a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"&gt; http:\/\/Training.SitesTree.com&lt;\/a&gt; \n    In Bengali: &lt;a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\"&gt;http:\/\/Bangla.SaLearningSchool.com&lt;\/a&gt;\n    &lt;a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\"&gt;http:\/\/SitesTree.com&lt;\/a&gt;\n    8112223 Canada Inc.\/JustEtc: &lt;a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\"&gt;http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) &lt;\/a&gt;\n    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com'&gt; https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    Medium: &lt;a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"&gt; https:\/\/medium.com\/@SayedAhmedCanada &lt;\/a&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Methods SQL Server instances Clustering Database mirroring Log shipping Replication Shared scalable databases SQL Server instancesIn the same computer install multiple instance of SQL Server to take advantage of multiple processors. Each instance may use separate processor with separate lock manager, worker threads, tempdb system database. ClusteringFailover Clustering can provide robustness and protection against failure. &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69260\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69260","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69268,"url":"http:\/\/bangla.sitestree.com\/?p=69268","url_meta":{"origin":69260,"position":0},"title":"SQL Server : Backups #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Why are backups needed? To protect accidental data loss. Still, if you use highly available and fault-tolerant systems like SAN, and RAID, you may need to backup your database regularly. These fault tolerant systems can not provide accidental data delete by users, accidental data corruption from software and hardware failure.\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69264,"url":"http:\/\/bangla.sitestree.com\/?p=69264","url_meta":{"origin":69260,"position":1},"title":"SQL Server Database System Tuning #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Database tuning approach Proactive approach Reactive approachBest Approach: Use a mix of both.Be aware (collect information) of the followings that may have significant impact on the performance. Hardware: Server, Available memory, number of processors, disk subsystems. Network Infrastructure: Network Cards, Switches, and the rest of your LAN and WAN. Operating\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69262,"url":"http:\/\/bangla.sitestree.com\/?p=69262","url_meta":{"origin":69260,"position":2},"title":"Dynamic Management Views #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Dynamic Management Views provide ways to analyze database performance and to find the cause behind bad-performing SQL server databases\/instances. Bad performance can be due to: poor design, insufficient memory, poorly configured system, disk bottlenecks, poorly written queries and many othersPreviously Windows System Monitor(perfmon.exe) and SQL server profiler were used to\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69241,"url":"http:\/\/bangla.sitestree.com\/?p=69241","url_meta":{"origin":69260,"position":3},"title":"Oracle Fundamental Concepts #40","author":"Author-Check- Article-or-Video","date":"August 15, 2021","format":false,"excerpt":"TermsDatabase: In oracle, the term database refers to the files required for the operation of Oracle. These files include:data files, temporary data files, redo log files, control files, and parameter filesInstance: All the processes and memory structures required to operate the databaseUsers: Users are accounts that can be used to\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69258,"url":"http:\/\/bangla.sitestree.com\/?p=69258","url_meta":{"origin":69260,"position":4},"title":"Scalability: SQL Server 2005 #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Scalability: SQL Server 2005After you have optimized your database design and the application design, you can improve the scalability of SQL Server in two ways1.Scaling Up2.Scaling OutScaling Up: Improve performance by 1. Adding more processors, memory, and storage capacity2. Replacing existing hardware with faster hardwareNote: You also need the right\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":69260,"position":5},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69260"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69260\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69260"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}