Aryasoft Blog

Insights, guides and updates on database management, data platforms, cloud architecture, analytics and technology.

Mikro Modernization Oracle SQL Server Upgrades

All Posts

Explore all insights from the Aryasoft blog.

Stacked storage drives, a database cylinder and a stopwatch, representing SQL Server disk layout and storage latency

SQL Server Disk Storage Best Practices: Layout, Formatting, File Settings and Latency

How to lay out SQL Server data, log, tempdb and backup files, format volumes with 64 KB clusters, configure storage...

SQL Server transaction log with hundreds of small virtual log files compared to a healthy log with a few evenly sized VLFs

SQL Server VLF Count: Why Too Many VLFs Hurt and How to Fix Them

What virtual log files are, why too many VLFs slow down startup, restores and replication, how to measure your VLF...

SQL Server high availability: two connected servers sharing a replicated database, with a monitoring dashboard

SQL Server High Availability Options: FCI, Availability Groups and Log Shipping Compared

Compare SQL Server high availability options (FCI, availability groups, basic AGs, log shipping and mirroring) and learn which one fits...

Padlock on a memory module with the path to disk blocked, representing Lock Pages in Memory for SQL Server

SQL Server Lock Pages in Memory: When to Enable It, How to Grant It and How to Verify It

What Lock Pages in Memory does for SQL Server, when it's worth enabling, how to grant it without losing it...

Monitor with a chart, an alert bell and a calendar, representing SQL Server monitoring routines

SQL Server Monitoring: A Daily, Weekly and Monthly DBA Checklist

What to alert on in real time and what to check daily, weekly and monthly in SQL Server, with ready...

Memory modules with a limit line next to a server, representing the SQL Server max server memory setting

SQL Server Max Server Memory: How to Calculate It, Set It and Check It

What SQL Server max server memory really limits, how to calculate a starting value, when to use min server memory...

SQL Server Agent alert firing on a database server and sending an email notification

SQL Server Alerts: Which Ones to Enable and How to Set Them Up Right

Which SQL Server Agent alerts every production server needs, a ready-to-run script for severities 17–25 and errors 823–825, the mail...

A tall stack of pages next to a small one, representing reducing logical reads in SQL Server query tuning

Why Reads Matter Most When Tuning T-SQL: Logical Reads, STATISTICS IO and Indexes

Why logical reads are the most reliable measure for T-SQL tuning, how to read STATISTICS IO output, the difference from...

Two SQL Server nodes with a failover arrow, an update symbol and a wrench representing a rolling update

Patching SQL Server and Windows on Always On: A Rolling Update Guide

How to apply SQL Server CUs and Windows updates on Always On availability groups and failover cluster instances with a...

SQL Server tempdb best practices: a central database with four equally sized data files and a monitoring panel

SQL Server TempDB Best Practices: Files, Sizing, Contention and Monitoring

Learn the SQL Server tempdb best practices that matter today: how many data files to use, how to size and...

Blank tiles being reordered next to a database cylinder and a magnifier, representing SQL Server collation and sort order

SQL Server Collation: How to Change Server, Database and Column Collation Safely

How to change SQL Server collation safely at server, database and column level: a risk and rollback table, tempdb and...

SQL Server backup compression shrinking data blocks into a compact backup file

SQL Server Backup Compression: Benefits, CPU Cost, ZSTD and Enabling It by Default

How SQL Server backup compression works, what it costs in CPU, how MS_XPRESS, QAT and ZSTD compare, what affects the...

Prev 1 … 6 7 8 9 Next