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…
| News From the Frontlines |  |
Tag Archive: Performance & Optimization
[Shameless Plug] Can We Have Your Vote?
[Shameless Plug] Can We Have Your Vote? Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL Rally 2012 in Dallas, TX called “Demystifying Database Administration Best Practices”. We think it’s going to be an epic session with just loads and loads of tips and best practices on multiple aspects of Database Administration, from…
(No Ratings Yet)
Loading ...Breaking Down TempDB Contention (part 2)
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…
(5 votes, average: 4.60 out of 5) Loading ...Webcast: Putting a Better SQL Server in Production
Webcast: Putting a Better SQL Server in Production Webcast: Putting a Better SQL Server in Production Date: Wednesday, January 18, 2012 3:00 PM to 4:00 PM Eastern Time / 2:00 PM CT / 12:00 PM PT Problems come up everyday that could have been avoided by simply configuring SQL Server appropriately before using it. The…
(4 votes, average: 5.00 out of 5) Loading ...The Barking Dog Analogy
The Barking Dog Analogy A discussion started today on Twitter about CXPacket waits. There had been a heated debate on the subject on Twitter the previous night (wow, does that sound geeky), so many of us got looped into today’s discussion. Someone had experienced a problem with a delete query on a large table causing…
(5 votes, average: 5.00 out of 5) Loading ...Secrets of SQL Server Webcast: TempDB: Performance and Manageability
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…
(4 votes, average: 4.00 out of 5) Loading ...Idera ACE Program Members Announced
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…
(No Ratings Yet) Loading ...New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO
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…
(1 votes, average: 5.00 out of 5) Loading ...SQLU HA/DR Week – Database Mirroring Performance Counters
SQLU HA/DR Week – Database Mirroring Performance Counters Database mirroring debuted in SQL Server 2005 and had eleven performance counters for monitoring mirroring. There were ten new performance counters released with SQL Server 2008. We now have twenty-one performance counters to use for monitoring database mirroring. A list with a brief description of each can…
(2 votes, average: 5.00 out of 5) Loading ...SQLU VLDB Week – Archiving and Purging Data
SQLU VLDB Week – Archiving and Purging Data Welcome back for the final day of VLDB week at SQL University. Today, we will talk about one of the big challenges that all administrators must eventually tackle when working with a VLDB: archiving and purging data. This particular problem has a very simple solution; however, if…
(1 votes, average: 5.00 out of 5) Loading ...-
My SQL Server Magazine Articles
- Database Mirroring for Disaster Recovery September 16, 2011
- Comparative Review: Database Schema Comparison Tools August 24, 2011
- 3 Log Shipping Techniques June 22, 2011
- Hardening SQL Server June 20, 2011
- Review: ScriptLogic Security Explorer for SQL Server February 8, 2011
-
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS