Category Archives: optimization

My Latest Book: Mainframe Specialty Processors

Posted on November 30, 2023 by craig@craigsmullins.com

Today’s post will be brief… just to announce my latest book. It does have relevance to data, but only for IBM System Z mainframe shops. The book is titled: Mainframe Specialty Processors: Understanding zIIPs, Licensing, and Cost Savings on the … Continue reading →

Posted in architecture, books, capacity planning, DB2, IBM, mainframe, optimization, performance, software cost, zIIP | Leave a comment

Optimizing Database Performance

Posted on August 29, 2023 by craig@craigsmullins.com

Last week I was proud to publish my latest database book, this time on the important topic of achieving and maintaining efficient performance for your databases and the applications that access them. Appropriately enough, this book is titled Optimizing Database … Continue reading →

Posted in analytics, availability, data availability, DBA, indexing, operational, optimization, performance | Tagged , , , | Leave a comment

Let’s Talk About Database Performance Analyzer

Posted on March 11, 2022 by craig@craigsmullins.com

Recently, I published a tweet thread on database performance and SolarWinds’ Database Performance Analyzer. Today’s blog post captures those tweets for posterity! Let’s talk about #DatabasePerformance and SolarWinds (Tweet #1) Applications that access relational databases are only as good as … Continue reading →

Posted in automation, DBA, optimization, performance, SQL | Tagged | 1 Comment

IBM POWER and SAP HANA: A Powerful and Effective Combination

Posted on September 18, 2020 by craig@craigsmullins.com

As organizations looks for differentiators to improve efficiency and improve cost effectiveness, the combination of IBM Power Systems and SAP HANA can provide a potent platform with a significant return on investment. Why IBM Power Systems? IBM Power Systems is … Continue reading →

Posted in analytics, Big Data, business planning, data, DBMS, ERP, IBM, In-Memory, optimization, performance, SAP HANA | Tagged , , , , , | Leave a comment

What causes SQL Server to have performance issues or run slow?

Posted on June 29, 2020 by craig@craigsmullins.com

Today’s post is a guest article written by a friend of the blog, Kevin Kline, an expert on SQL and Microsoft SQL Server. Image Source: Pixabay SQL Server can suffer from all sorts of problems if it is not properly … Continue reading →

Posted in DBA, Microsoft SQL Server, optimization, performance, SQL | Leave a comment

SQL Performance and Optimization

Posted on December 11, 2018 by craig@craigsmullins.com

Just a quick post today to refer my readers to a series of blog posts that I recently made to the IDERA database community blog. This four-part blog series took a look into SQL performance and optimization from a generic … Continue reading →

Posted in optimization, performance, SQL | 4 Comments