On index key size, index depth, and performance |
In my Insider newsletter a couple of weeks ago, I discussed how index fragmentation is often considered when designing indexes, but index depth often isnt. In the newsletter I said Id do a more comprehensive blog post with some data, so this is it. Fanout and Index Depth The index depth is determined by the fanout of [&]
The post On index key size, index depth, and performance appeared first on Paul S. Randal.
Метки: Indexes From Every Angle Performance Tuning |
Low priority locking wait types |
SQL Server 2014 (and Azure SQL Database V12) added some cool new functionality for online index operations to allow you to prevent long-term blocking because of the two blocking locks that online index operations require. At the start of any online index operation, it acquires a S (share) table lock. This lock will be blocked until [&]
The post Low priority locking wait types appeared first on Paul S. Randal.
Метки: Indexes From Every Angle Locking Wait Stats |
Cool workshops at SQLintersection in October |
This years Fall SQLintersection conference in October is fast approaching and weve got some excellent full-day workshops lined up for you: Sunday 25th: Kimberly with Queries Gone Wrong: Statistics, Cardinality, Solutions Monday 26th: Jon and Tim with Managing SQL Server for the Non-DBA Monday 26th: Glenn with Analyzing and Improving I/O Subsystem Performance Friday 30th: Me [&]
The post Cool workshops at SQLintersection in October appeared first on Paul S. Randal.
Метки: Conferences Training |
June 2016 London classes open for registration |
I’ve just released our London classes for 2016 for registration! Well be teaching the following classes: IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 June 13-17 (US$200 discount for registering in 2015) IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2 June 20-24 (US$200 discount for registering in 2015) As you can see, [&]
The post June 2016 London classes open for registration appeared first on Paul S. Randal.
Метки: Classes Training |
New SSIS Immersion Events with Andy Leonard and Tim Mitchell |
We’re very excited to announce that we’re partnering with our friends at Linchpin People to offer two new Immersion Events on SSIS, both debuting in 2016 along side our existing classes. IESSIS1: Immersion Event on Learning SQL Server Integration Services This is a 5-day course taught by Andy Leonard, with the following modules: Introduction Creating Your First [&]
The post New SSIS Immersion Events with Andy Leonard and Tim Mitchell appeared first on Paul S. Randal.
Метки: Classes Training |
2016 Chicago and Bellevue classes open for registration |
Ive just released our first sets of US classes for 2016 for registration! Our classes in April/May will be in Chicago, IL: IE0: Immersion Event for Junior/Accidental DBAs April 18-20 (US$120 discount for registering in 2015) IEPTO1: Immersion Event on Performance Tuning and Optimization Part 1 April 18-22 (US$200 discount for registering in 2015) IEPTO2: Immersion [&]
The post 2016 Chicago and Bellevue classes open for registration appeared first on Paul S. Randal.
Метки: Classes Training |
“Attempt to read or write protected memory” error from SSMS for System.Data |
I just spent a couple of hours fruitlessly trying to solve a problem and thought Id blog the solution in case anyone else hits the issue. A few months back I got a new laptop and installed SQL Server 2014 on it and everything worked fine. A few weeks ago I installed SQL Server 2008 [&]
The post Attempt to read or write protected memory error from SSMS for System.Data appeared first on Paul S. Randal.
Метки: Tools |
My upcoming sessions at PASS and SQLintersection |
The two major Fall conferences (PASS Summit and SQLintersection) are coming up in October so I wanted to give you a heads-up about what Ill be presenting. The workshop Ill be doing at both conferences is based on one of my favorite topics – wait statistics and using them for performance troubleshooting. I’m very passionate about helping people learn about [&]
The post My upcoming sessions at PASS and SQLintersection appeared first on Paul S. Randal.
Метки: Conferences Training |
Disaster recovery 101: fixing a broken boot page |
One of the corruptions that can stymie all efforts at disaster recovery is broken boot page. If the boot page cant be processed, the database cant be brought online or even put into emergency mode. I first demonstrated how to work around this in my session on Advanced Data Recovery Techniques at PASS in 2014 [&]
The post Disaster recovery 101: fixing a broken boot page appeared first on Paul S. Randal.
Метки: Corruption Disaster Recovery |
T-SQL Tuesday #67 – monitoring log activity with Extended Events |
On the second Tuesday of each month, many people in the SQL Server community join together to all blog on the same topic a cool idea from Adam Machanic many years ago. This months topic is Extended Events, hosted by Jes Borland (b | t) you can see her original post here. Yesterday [&]
The post T-SQL Tuesday #67 monitoring log activity with Extended Events appeared first on Paul S. Randal.
Метки: Extended Events Transaction Log |
November classes in Chicago |
We’ve released our Fall lineup of classes for registration! Our November classes in Chicago, IL will be: IE0: Immersion Event for Junior/Accidental DBAs November 16 18 IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 November 16 20 IEPDS: Immersion Event on Practical Data Science November 16 19 You can get [&]
The post November classes in Chicago appeared first on Paul S. Randal.
Метки: Classes Training |
New course: Index Fragmentation Internals, Analysis, and Solutions |
My latest Pluralsight course has been published! Its called SQL Server: Index Fragmentation Internals, Analysis, and Solutions and is just over 2.5 hours long. The modules are: Introduction Index Structure and Index Uses Types of Index Fragmentation Causes of Index Fragmentation Detecting Index Fragmentation Avoiding Index Fragmentation Removing Index Fragmentation Check it out here. We now [&]
The post New course: Index Fragmentation Internals, Analysis, and Solutions appeared first on Paul S. Randal.
Метки: Fragmentation Indexes From Every Angle Performance Tuning Pluralsight Training |
Finding a transaction in the log for a particular user |
In the last IEHADR class we just had in Chicago, I was doing a demo of looking in the transaction log to find the point at which a table was dropped so a restore could be performed (as described in this blog post). One of the students asked how to find a transaction for a [&]
The post Finding a transaction in the log for a particular user appeared first on Paul S. Randal.
Метки: Backup/Restore Disaster Recovery Transaction Log Undocumented commands |
New course: part 2 of Kimberly’s Optimizing Stored Procedure Performance |
Kimberlys latest Pluralsight course is live! This is part 2 of her very popular course: SQL Server: Optimizing Stored Procedure Performance. The course is more than 3 hours long and has the following modules: Introduction Session Settings Session Settings (section 2) Special Considerations Troubleshooting Techniques Check it out here. We now have more than 130 hours [&]
The post New course: part 2 of Kimberlys Optimizing Stored Procedure Performance appeared first on Paul S. Randal.
Метки: Performance Tuning Pluralsight Training |
How would indexes on AG readable secondaries work? |
Last weekend there was a suggestion on the MVP distribution list about having temporary nonclustered indexes on AG readable secondaries, in the same way that you can have temporary statistics on them. I replied that in my opinion it would be extremely difficult to do that, and said Id blog about why. Heres my explanation. [&]
The post How would indexes on AG readable secondaries work? appeared first on Paul S. Randal.
Метки: Indexes From Every Angle Inside the Storage Engine |
Survey: page life expectancy |
Its been a while since Ive done a survey, and this one is inspired by a discussion I had with Matt Slocum (b | t) yesterday that led me to update my PLE post Page Life Expectancy isn’t what you think… with the discovery that on NUMA systems, Buffer Manager: Page Life Expectancy is a harmonic mean, not an [&]
The post Survey: page life expectancy appeared first on Paul S. Randal.
Метки: Surveys |
Make sure you’re eligible to vote in the PASS elections this year! |
Last year PASS introduced some eligibility requirements for voting in the 2014 PASS elections, but a lot of people didnt get the message for various reasons (including me) before the deadline expired. PASS did the right thing and allowed people to become eligible by delaying the elections. This year there are similar eligibility requirements and youve [&]
The post Make sure youre eligible to vote in the PASS elections this year! appeared first on Paul S. Randal.
Метки: Community |
Identifying queries with SOS_SCHEDULER_YIELD waits |
One of the problems with the SOS_SCHEDULER_YIELD wait type is that its not really a wait type. When this wait type occurs, its because a thread exhausted its 4ms scheduling quantum and voluntarily yielded the CPU, going directly to the bottom of the Runnable Queue for the scheduler, bypassing the Waiter List. A wait has [&]
The post Identifying queries with SOS_SCHEDULER_YIELD waits appeared first on Paul S. Randal.
Метки: Example Scripts Performance Tuning Wait Stats |