A little more than a year ago while working at Idera, I was consulted on reports from a few clients using the Idera monitoring tool SQL diagnostic manager (SQLdm). SQLdm was reporting very high numbers for internal object allocations (internal_objects_alloc_page_count) and very low numbers for internal object deallocations (internal_objects_dealloc_page_count) to the point that SQLdm showed … Read More →
Welcome to day 14 of my 31 Days of Disaster Recovery series. I’ve previously discussed handling corruption for nonclustered indexes and allocation pages. Today, I’m going to talk about a specific corruption that is very simple to fix; however, it does mean taking the server offline briefly. How brief depends on a few things, such … Read More →
Tempdb Contention That Can’t be Soothed By Adding Files I’ve talked a lot in the past about tempdb contention and how to monitor for and identify it in blog posts, a whitepaper, webcasts, and live presentations. Okay, so I tend to get a little preachy about certain things and configuring tempdb to prevent tempdb contention … Read More →
Recent Presentation Session Files I’ve been a little tardy about getting my session files posted, and I’m a little behind. So I’m going to try to catch up in one blog post. So here are my session files for SQL PASS Summit 2012, various recent SQL Saturdays, and 24 Hours of PASSe. Please let me … Read More →
SQL Rally 2012 Recap and Session Files SQL Rally 2012 was hosted by the North Texas SQL Server User Group. More tha anything, it was nice to be back in the area where I grew up. I was born in Houston, but I grew up in the Dallas/Ft. Worth area. It really brought back a … Read More →
Whitepaper: Demystify Tempdb Performance & Management There are many misconceptions and myths about tempdb and purported best practices are inconsistent at best. It’s hard to know which advice to follow when one resource says to always do it one way and another tells you to always do it the opposite way. Many times, both resources … Read More →
Breaking Down TempDB Contention (part 2) I wrote a somewhat popular script and blog post a while back called Breaking Down TempDB Contention. This post explains how to identify tempdb contention. This past Friday, Jonathan Kehayias (blog|@SQLPoolboy) contacted me about the script. Jonathan said that he thought the math was off just a little bit … Read More →
Secrets of SQL Server Webcast: TempDB: Performance and Manageability Register today for my Secrets of SQL Server webcast on July 13th. TempDB: Performance and Manageability Misconceptions and inconsistent advice on tempDB abounds. Even highly skilled DBAs cannot always agree on how to best configure tempDB. Part of the problem is that there is no single … Read More →
Idera ACE Program Members Announced Idera announced the lineup for their new ACE (Advisors & Community Educators) Program today, and I’m excited to be on of the Idera ACEs. The new Idera ACEs are established members of the SQL community who are already educators and advisors through various programs. Idera is enabling the ACEs to … Read More →
New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO A colleague I work with on the PQO* Operations SQL V-Team, Jonathan Foster, has authored and published a whitepaper on using FusionIO SSD drives for tempDB performance in SQL Server. I served as technical reviewer and Jimmy May (blog|@aspiringgeek) from Microsoft’s SQL Cat Team (blog|@SQLCat) and … Read More →
My SQL Server Magazine Articles
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS
Facebook