Author: Ben Taylor

Working With Obsolescence
Editorials

Working With Obsolescence

Reading Stephen’s editorial, “Check Out Any Time You Lilke…” reminds me of software patterns intended to help reduce the feeling of being tied to a specific technology. The reality is that it is very difficult to future proof anything. You can loosely couple, inject, micros kernel and much more, and still have dependencies you can’t walk away from. I do […]

A Walk Down Memory Lane
Editorials

A Walk Down Memory Lane

I’m not coming up with a great topic for today, so I thought I would share a few of the many relational database engines I have used over the years. I started working with relational database engines while I was in college. I took a course for relational databases that used engines running on the old DEC PDP-11 computers called […]

Sharding Instead of Partitions
Editorials

Sharding Instead of Partitions

Yesterday we talked about partitioned tables. The goal was to spread the load over multiple resources allowing for large amounts of data to be live and responsive at the same time. Spreading data over multiple tables allows the data to be stored in the most optimized state with the least amount of overhead. It also improves disaster recovery. Using partitioned […]

Partition By Time
Editorials

Partition By Time

As the size of your database continues to grow, the physical implementation of your disk storage become more important. This is expressed in real time performance when using the database, and disaster recovery options. One of the key ways of handling large volumes of data, especially in a single table, is the use of partitioned tables. We are going to […]

Optimal File Group Utilization
Editorials

Optimal File Group Utilization

David Eaton brings us back to database fundamentals of file utilization for an SQL Server database. He writes: The fundamentals of SQL Server are still the same, spread out the data on as many disks as you can. Make sure the database design is correct and scalable. Set up filegroups to move indexes intelligently, meaning use two or more and […]

Getting The Most Out Of Your Database
Editorials

Getting The Most Out Of Your Database

As AZ Jim reminds us in our comments, the configuration of your disk systems matter in more ways than one. There are many ways a controller can build RAID drives, consisting of at least two disks that perform as a single disk. The more disks participating in a RAID system, the better the fault tolerance should one or more drives […]

Database Disk Usage
Editorials

Database Disk Usage

I appreciate the comments for addressing performance issues that may be based on systems out of your control as a DBA. Some suggestions rely on tools to identify bottlenecks. Others take advantage of metrics you are already able to gather from SQL Server and performance monitors built into Windows. Sometimes the issues are not with SQL Server, or Windows is […]

Optimize High Volume With a Staging Table
Editorials

Optimize High Volume With a Staging Table

There are many things you can do to improve the performance of your OLTP system when it experiences exceptionally high volume causing the system to slow to the point of visible perception. Normalization, file separation, index and statistics tuning, memory management, and report separation are your first targets for any OLTP database. We even talked about pre-assigning keys externally last […]

Two Stage Persistence
Editorials

Two Stage Persistence

In dealing with high performance systems there is another method of addressing the normalization of data when it is persisted to an SQL relational database with appropriate normalization. This was alluded to by Eilenblogger in his comments yesterday. The method uses two stages of persistence. First, the data is persisted to a temporary data store with extremely fast performance. There […]