SIOS SANless clusters

SIOS SANless clusters High-availability Machine Learning monitoring

  • Home
  • Products
    • SIOS DataKeeper for Windows
    • SIOS Protection Suite for Linux
  • News and Events
  • Clustering Simplified
  • Success Stories
  • Contact Us
  • English
  • 中文 (中国)
  • 中文 (台灣)
  • 한국어
  • Bahasa Indonesia
  • ไทย

5 Database Practices That Are Hurting Your Performance

May 8, 2013 by Geoff Hiten, Microsoft SQL Server MVP Leave a Comment

Experience matters, especially when administering database systems. The lessons we learn early in our careers, particularly the painful ones, stick with us a long time. This is mostly a good thing, but sometimes we apply the wrong lesson to the task in front of us. In database administration, it’s easy to head in the wrong direction, especially when we’re trying to balance the need for both efficiency and performance.

New lesson, different day

Most database administrators did not begin their careers as DBAs. Most of us started in development or system administration and eventually specialized in database systems. Unfortunately, some of the lessons learned along the way in those other fields are the exact wrong ones for a database system.

For example, system admins have to manage storage as efficiently as possible. Many central storage systems are sold to reduce storage use through consolidation. System and storage virtualization also seek to efficiently use technical resources by assigning the minimum resources possible to a particular workload.

DBAs also have to manage storage resources. The problem comes when DBAs manage storage the same way they did as general IT system administrators.

As DBAs, our primary goal is to make data usable for the business. While we don’t want to waste our platform resources, we also don’t want to cause problems through false efficiency.

Managing for best resource efficiency often leads to performance problems. This is especially true when trying to minimize the storage footprint of a Microsoft SQL Server database system.

5 Database Practices That Are Hurting Your Performance

Several common practices actually trade performance for space efficiency:

  • Using Auto-Grow to manage free space
  • Shrinking databases
  • Shrinking logs
  • Not rebuilding or reorganizing indexes
  • Shuffling backup files to offline storage

The last practice in the list is particularly frustrating. All businesses should have adequate backup storage to meet their recovery targets. Saving a small amount on the cheapest resource available (second- and third-tier storage) while wasting the most expensive resource available (skilled DBA time) is mismanagement at its worst.

Business management emphasizes cost savings, mainly because that is easily measured. But what business executives and users really want is a zero-problem IT infrastructure, including a database platform that performs quickly and consistently. Saving a few hundred dollars worth of storage space probably won’t even get you an “attaboy” from your boss. A slow database system or a missing critical backup will get noticed — just not the way you want.

When you are looking at your database management practices and processes, ask yourself, “What goal does this process enable?” Are you managing for performance or managing for space?

Consult the experts at SIOS to discuss solutions for your particular environment. Experienced technicians at SIOS can provide helpful insight to customers who are implementing high-performance, highly available SQL Server systems.

Filed Under: Blog posts, News and Events Tagged With: #SANLess Clusters for SQL Server Environments, #SANLess Clusters for Windows Environments, Clusters Your Way, MVP, SQL, SQL Mag, Windows

Recent Posts

  • The Best Rolling Upgrade Strategy to Enhance Business Continuity
  • How to Patch Without the Pause: Near-Zero Downtime with HA
  • SIOS LifeKeeper Demo: How Rolling Updates and Failover Protect PostgreSQL in AWS
  • How to Assess if My Network Card Needs Replacement
  • SIOS Technology to Demonstrate High Availability Clustering Software for Mission-Critical Applications at Red Hat Summit, Milestone Technology Day and XPerience Day, and SQLBits 2025

Most Popular Posts

Maximise replication performance for Linux Clustering with Fusion-io
Failover Clustering with VMware High Availability
create A 2-Node MySQL Cluster Without Shared Storage
create A 2-Node MySQL Cluster Without Shared Storage
SAP for High Availability Solutions For Linux
Bandwidth To Support Real-Time Replication
The Availability Equation – High Availability Solutions.jpg
Choosing Platforms To Replicate Data - Host-Based Or Storage-Based?
Guide To Connect To An iSCSI Target Using Open-iSCSI Initiator Software
Best Practices to Eliminate SPoF In Cluster Architecture
Step-By-Step How To Configure A Linux Failover Cluster In Microsoft Azure IaaS Without Shared Storage azure sanless
Take Action Before SQL Server 20082008 R2 Support Expires
How To Cluster MaxDB On Windows In The Cloud

Join Our Mailing List

Copyright © 2025 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in