Article Library, Page 6
Every Red9 article in one place, most recently updated first. Written by the senior DBAs who do the work.
- articles
- 208
- categories
- 6
All Articles
Guide · SQL Server TipsSQL Server Log File Too BigSQL Server log (LDF file) is too big - what causes log file too large, how to detect it, how to fix it and how to shrink it
Guide · SQL Server Migrations & UpgradesSQL Server High Availability (HA)If you need to introduce a high availability solution for one of your SQL Server databases, then there's lots of confusion as to what is the right option
Guide · SQL Server Performance TuningSQL Server Index Tuning for PerformanceSQL Server Index Tuning has a major impact on performance. Proper indexing is one of the quickest and most effective ways to boost SQL speed.
Guide · SQL Server Performance TuningWhy Picking the Right Data Types in SQL Server Matters6x more space: one wide key took 2,193MB vs 381MB. SQL Server data type choices decide speed, data integrity and storage.
Guide · SQL Server TipsSQL Server Change Tracking: Benefits, Limitations, and When to UseSQL Server Change Tracking records which rows changed. Check whether you need it, see where the overhead comes from and find databases using it.
Guide · SQL Server Health CheckWhy Should You Enable SQL Server Database Backup Compression by Default?Most DBAs enable SQL Server backup compression too late. Here's what it quietly improves - and what you're risking by leaving it off.
Guide · SQL Server Migrations & UpgradesShould I Migrate My SQL Server to Linux?With SQL Server 2017, and now SQL Server 2019, SQL Server is available on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu.
Guide · SQL Server SecuritySQL Server Data Encryption and Your OptionsWe recently got a question from someone about how to encrypt large SQL Server database for compliance reasons with minimal impact on software applications.
Guide · SQL Server Health CheckReview Your Windows Task Scheduler: It Can Impact Your SQL Server PerformanceIt is a Windows component that can schedule programs to run at pre-defined times or after specified time intervals.
Guide · SQL Server TipsSimple Recovery Model in SQL ServerSQL Server simple recovery model means no transaction log backups. See what you can restore and whether the possible data loss fits your needs.
Guide · SQL Server TipsNew Microsoft Software Assurance Benefits for SQL Server High Availability and Disaster RecoveryMicrosoft Software Assurance now grants SQL Server new HA and DR rights, including free passive and DR replicas. See what changed and who benefits.
Guide · SQL Server Health CheckBest Windows Power Plan for Optimizing SQL Server PerformanceUsually, the balanced power plan is set by default, which is what Microsoft recommends for general use.
Guide · SQL Server Migrations & UpgradesMigrating Microsoft SQL Server to Amazon AWS RDSUnderstand how AWS RDS handles SQL Server workloads - from licensing and storage to HA, compliance, and where the real platform limits show up.
Guide · SQL Server Health CheckSQL Server – Priority Boost OptionThe Priority Boost option looks like free speed, but it can starve the OS and crash your instance. Why Microsoft says leave it off, and the rare exception.
Guide · SQL Server TipsNever Use the Full Recovery Model Without a BackupIf you are using a database in Full Recovery Model or Bulk Logged Recovery Model, SQL Server does not free up the log file when your transactions finish.
Guide · SQL Server Performance Tuning[7 Tips] How to Improve T-SQL Query Performance7 quick tips that show you how to improve TSQL query performance. The BEST part: You don't need to be a PRO to use these! Anyone can!
Guide · SQL Server Migrations & UpgradesHow to Test SQL Server Migrations Using Log ShippingWhat is the key to SQL Upgrades project success? Preparation. Prep work is going to take 80-90% of the time.
Guide · SQL Server TipsHow to Re-Initialize SQL Server Merge Replication PublicationReinitialize SQL Server merge replication in SSMS. Follow the snapshot and subscription steps, then check synchronization in Replication Monitor.
Guide · SQL Server TipsMicrosoft Dynamics 365Microsoft Dynamics 365 is a cloud ERP and CRM enterprise platform for organizations announced by Microsoft in July 2016.
Guide · SQL Server SecurityEncrypting Drives on Live SQL Server with AlwaysOnEncrypting drives on SQL Server AlwaysOn? Review the guide's replica sequence, failover options and latency checks before planning the change.
Guide · SQL Server Health CheckKeep Your Jobs Safe Using SQL Agent NotificationsMissing SQL Server Agent job notifications? Find jobs that won't email on failure, then set the operator and notification option in SSMS.
Guide · SQL Server Performance TuningIncreasing Cost Threshold for Parallelism May Improve Your SQL Server PerformanceSQL Server's default cost threshold of 5 forces tiny queries to go parallel and waste CPU. What to raise it to, and how to find the right value.
Guide · SQL Server Performance TuningHow Many CPUs Is Your SQL Server Able to Use?SQL Server may be ignoring cores you paid for, from licensing limits to offline schedulers. How to check how many CPUs it actually uses, and why.
Guide · SQL Server Performance TuningHow Can You Find the SQL Server Jobs That Start Simultaneously?Multiple SQL Server Agent jobs are configured to start simultaneously, which will not perform as fast as if jobs would not overlap.
Guide · SQL Server Performance TuningHardware and Performance Tuning in SQL ServerStruggling with slow SQL Server performance? It’s probably your disk! Learn why and how to fix it for faster, smoother databases.
Guide · SQL Server Performance TuningImprove Your SQL Server Transaction Log Performance Using Delayed DurabilityDelayed durability can cut SQL Server log waits and speed up writes fast. How it works, how to turn it on, and the data-loss tradeoff to weigh first.
Guide · SQL Server Performance TuningImprove Your SQL Server Performance Enabling Data CompressionSQL Server data compression trades CPU work for fewer reads. Find tables and indexes worth checking, and weigh storage savings against the CPU cost.
Guide · SQL Server Health CheckDisabling Windows “Visual Effects” to Boost PerformanceWindows spends CPU and memory on visual effects a database server never uses. Turn them off in two minutes to hand those resources back to SQL Server.
Guide · SQL Server Health CheckDisable Unnecessary SQL Server Instances and ServicesUnused SQL Server services can still consume resources. Find installed instances and services, then check which ones your server actually needs.
Guide · SQL Server Performance TuningDatabase Engine Tuning Advisor (DTA) in Microsoft SQL ServerChanging database design to a proper one makes it to perform better. One of the performance-critical areas of databases is proper table indexing and their usage.
Guide · SQL Server Health CheckBest Practices for the SQL Server Error LogIt’s a file used by SQL Server to write data about events that occurred as backups, stack dumps, and a lot of other informational events.
Guide · SQL Server Health CheckFinding User Tables in SQL Server System DatabasesUser tables in SQL Server system databases can be forgotten during a migration. Find misplaced tables and review the backup and access risks.