Blogging at SQLPerformance.com
As part of my role on the SentryOne Product Advisory Council (PAC), I'm going to occasionally be contributing posts over at SQLPerformance.com
Continue readingBrowse the archive
Performance
Does the 'reads' column in SQL Profiler mean the same as IOPS?
Question I just executed a query that went pretty fast and the SQL Profiler said it used 30.000 reads. Now I'm looking at this page: https://cloud.google.com/compute/docs/disks/performance and see that a standard persistent disk has 3000 reads IOPS. Does that …
Continue reading
Plan Explorer 3.0: More power and completely free
Today, SQL Sentry announced the release of Plan Explorer 3.0. There are a few big changes, so let’s dive right in. Plan Explorer just got free-er Up until now, Plan Explorer was essentially a freemium product. There was the free edition (which was really …
Continue readingSQL Server 2014 slow insert
Question I have a very strange slow insert issue, here I am providing the table structure, and the insert statement used. The database is clean, contains no other tables, no indices, no constraints, no triggers. I tested this on two different machines, with …
Continue reading
How to shrink a database in 4 easy steps
Shrinking a SQL Server database is usually the wrong fix; learn when the rare exceptions may apply.
Continue reading
How fast queries hurt performance
This week at work, I noticed CPU on one server seemed pretty high. I wasn’t familiar with this particular server, but based on the applications it supported, I was expecting the server to be under-utilized. I went over to vCenter to look at historical CPU …
Continue readingConverting delimited values to a table (efficiently?)
This is a pretty common problem. I think it’s a question every developer has asked at one time or another: “I want to pass in a comma-separated list of values, then convert it into a table." Every company I’ve ever worked for has had a function that does this. …
Continue reading