Weekly link roll2 (weekly)

• Index Analysis March Update | Strate SQL

  tags: sql performance index

• sp_BlitzIndex - SQL Server's Index Sanity Test | Brent Ozar Unlimited

  "sp_BlitzIndex™ – SQL Server’s Index Sanity Test Your SQL Server indexes may be less sane than you think. Do you have duplicate indexes wasting your storage and memory? Have wide clustering keys snuck into your schema, inflating your indexes? Are there active heaps lurking in your database, causing strange fragmentation? Is blocking creeping up behind you before you can realize it? Our free sp_BlitzIndex™ stored procedure quickly does a sanity check on your database and diagnoses your indexes major disorders, then reports back to you. Each disorder has a URL that explains what to look for and how to handle the issue. sp_BlitzIndex™ also saves YOUR sanity when index tuning, by giving you the option to see both the “missing” and existing indexes for a table in a single view– when prevents you from going crazy and adding duplicate indexes. If you’ve ever struggled with index tuning, this may sound crazy good. We think it really is. Get sp_BlitzIndex™ and Check Your Index Sanity Download sp_BlitzIndex™ here! Want to run sp_BlitzIndex™ with minimal permissions? It’s easy, get the prescription here. You can also grab the code for sp_BlitzIndex™ right here: "

  tags: sql performance index

• Triage Wait Stats in SQL Server | Brent Ozar Unlimited

  tags: sql performance wait stats

• SQL Server 2008 R2 Diagnostic Information Queries (May 2013) | Glenn Berry's SQL Server Performance

  tags: sql performance

• How To: Troubleshooting SQL Server I/O bottlenecks - SQL Journey - Site Home - MSDN Blogs

  tags: sql performance

• Pushing ETW events through SignalR - Pablo M. Cibraro (aka Cibrax)

  tags: tracing ETW SignalR

Posted from Diigo. The rest of my favorite links are here.