Missing Index Script

I have been using the SQL Server Performance Dashboard for a long time. The Performance Dashboard is in my opinion an excellent tool to troubleshoot, specially when you don’t have a set of your own scripts. One of the things that the Performance Dashboard has is a list of the missing indexes on the SQL […]

SQL Saturday 282

SQL Saturday #282 will take place in San José, Costa Rica. The event count with great speakers, I feel honored that one of my sessions was selected for the event. If you are around San José on the 26th of April and you work with SQL Server, I will advise you to attend the event. […]

Download SQL Server 2014 now!

I did not write this post yesterday as I though that most people would think it will be an april fools’ joke. It finally arrived. SQL Server 2014 RTM is available for download. If you want to download it, you can do so by going to http://technet.microsoft.com/en-US/evalcenter/dn205290.aspx?WT.mc_id=Blog_SQL_Launch_SQL2014. I’m really happy about this new version of SQL […]

SQL Server 2014 almost here!

Today’s biggest news for anyone using SQL Server is that the SQL Server 2014 RTM release date has been announced. The newest version of SQL Server will be released on April fool’s day. Quentin Clark announced the release date in Microsoft’s official blog. If you want to know more about this release you can check […]

Have you already tried “sp_AskBrent”?

Most of you probably have heard of  Brent Ozar. Today I would like to ask you, have you already tried “sp_AskBrent”? If you have not tried yet, I will strongly recommend to try it. It will help you to identify what is making your Server slow. Even if you are not really sure about it, […]

What do the "DB File Free Space (MB)" and the "DB File Free Space (%)" SCOM performance counters really monitor?

What do the “DB File Free Space (MB)” and the “DB File Free Space (%)” SCOM performance counters really monitor?

SCOM can be very helpful when monitoring your SQL Server Infrastructure. Sometimes when I get SCOM alerts, I don’t really now what they mean. Luckly for me there are many people that do know what they mean and how they work. One of these persons is my colleague Ruud van den Hooff. He took the time […]

Annual Report

Annual Report

A few things every DBA should know about Page Life Expectancy(PLE) & NUMA

A few days ago I was talking with some friends about Page Life Expectancy and why I do not consider it to be a valuable counter anymore. I started the discussion because I read Paul Randal’s blog about how the PLE value is affected when using systems that use  Non-Uniform Memory Access. According to Paul’s blog […]

SQL Saturday #199

I just returned today from Sofia where I was presenting at SQL Saturday #199. It was my second SQL Saturday. My presentation was on “Collecting and analyzing SQL Server performance data with Dynamic Management Objects”. I just finished uploading the slides on the site. If you are interested on downloading the slides you can find […]

New waitstats script

A while ago I posted a script based on Paul Randal’s script for listing the waitstats. I have added a few more descriptions to the query. Feel free to use it and let me know if you have any tips on improving it. WITH [Waits] AS (SELECT [wait_type], [wait_time_ms] / 1000.0 AS [WaitS], ([wait_time_ms] – […]