[Note from Pinal]: This is a 18th episode of Notes from the Field series. Performance is very crucial subject and to come up with the right strategy along with a performance one needs to have more knowledge related to the overall performance of the server. However, most of the organization does not come up with the best strategies related to performance. It is very crucial that DBA collects performance statistics of the entire collection methodologically and scientifically. Let us learn more Performance Statistic Collection in this episode.
SQL SERVER – 28 Links for Learning SQL Wait Stats from Beginning
It has been exact two years since I have written series on SQL Wait Statistics and Queues. I often received quite a few questions related to this subject. Here are my answers to the questions. Q: The series which you have written two years ago, is it still relevant to…
Read MoreSQL SERVER – SafePeak SQL Server Acceleration Software Gets an Upgrade
SafePeak, the SQL Server application acceleration software, gets a new version upgrade and launches on Amazon Cloud Marketplace. SafePeak’s idea in a nutshell is simple. SafePeak is a query-level automated caching middleware for SQL Server-based operational applications. SafePeak accelerates apps by caching SQL queries while keeping a 100% ACID compliance…
Read MoreBig Data – Real-Time Analytics Performance with ClustrixDB
Note: The product used in comparison is ClustrixDB. It is available to download for FREE. NewSQL databases provide scale-out of NoSQL without giving up on SQL or ACID transactions. While most NewSQL databases focus only on transactions, ClustrixDB also provides fast real-time analytics that are becoming increasing important to many…
Read More
MySQL – MySQL Query Optimization and Performance Tuning – Online Video Courses
In year 2013, I had focused on MySQL along with SQL Server in database products. As I learn more and more MySQL, I quickly realized that there is no proper course or structured information for MySQL Performance Tuning. I had decided to build a course around common MySQL Performance Problems. I have decided to build the performance tuning course in two parts. 1) MySQL Indexing for Performance and 2) MySQL Query Optimization and Performance Tuning. I had released MySQL Indexing for Performance course earlier this year and right before the end of the year 2013 the second course MySQL Query Optimization and Performance Tuning has released as well.
SQL SERVER – Monitor Database via a Heatmap, Alarms List and Realtime Diagnostics for FREE
Note: This review is based on the performance monitoring and tuning free product Spotlight on SQL Server Freemium. If you think of a DBA’s life, it has one very simple goal – their server should never go down and all the queries should always perform excellently. However, just like any…
Read MoreSQL SERVER – Detecting Potential Bottlenecks with the help of Profiler
Probably, everyone who writes SQL code has used INSERT statement, which alongside SELECT, UPDATE and DELETE, is a part of a basic operations’ set for data manipulation. At the first sight syntax of the INSERT statement may seem very trivial , especially when inserting one record – INSERT INTO ……
Read More