SQL Performance Archives - Page 52 of 101 - SQL Authority with Pinal Dave

SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries

June 27, 2014

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Recently when I was busy working on my next course for Pluralsight, one of my friend pinged me for some help over messenger. And the conversation went on a different spin, here is a gist of what we talked and I felt this was worth a share – Me: Hi…

SQL SERVER – In-Memory Databases and Caching Wars

June 25, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Server

The In-Memory Database and In-Memory Caching market is heating up and we (the users) are the real winners. Exciting!!!

SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033

June 19, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Notes from the Field, Shrinking Database, SQL Scripts

[Notes from Pinal]: I am working with SQL Server for almost 10 years. I have seen the most ignored databases on any database server is system database. We hardly pay attention to them. Just for the sake of it – try to run queries in your master database and see…

SQL SERVER – SQL Server High Availability Options – Notes from the Field #032

June 12, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Notes from the Field, Shrinking Database

[Notes from Pinal]: When it is about High Availability or Disaster Recovery, I often see people getting confused. There are so many options available that when the user has to select what is the most optimal solution for their organization they are often confused. Most of the people even know…

SQL SERVER – Iridium I/O – SQL Server Deduplication that Shrinks Databases and Improves Performance

June 2, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database performance is a common problem for SQL Server DBA’s. It seems like we spend more time on performance than just about anything else. In many cases, we use scripts or tools that point out performance bottlenecks but we don’t have any way to fix them. For example, what do…

SQL SERVER – Faster SQL Server Databases and Applications – Power and Control with SafePeak Caching Options

June 2, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Safepeak

Update: This blog post is written based on the SafePeak, which is available for free download. Today, I’d like to examine more closely one of my preferred technologies for accelerating SQL Server databases, SafePeak. Safepeak’s software provides a variety of advanced data caching options, techniques and tools to accelerate the…

MySQL – Scalability on Amazon RDS: Scale out to multiple RDS instances

May 21, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

MySQL, SQL Server

Today, I’d like to discuss getting better MySQL scalability on Amazon RDS.
The question of the day: “What can you do when a MySQL database needs to scale write-intensive workloads beyond the capabilities of the largest available machine on Amazon RDS?”