–Brought to you as a script! Enjoy –� 2017 | ByrdNest Consulting –Index B-Tree Analysis /************************************************************************************ This script explores clustered, unique-nonclustered, and nonclustered indexes at the page level. Most likely the page ids used here will change in your database configuration and setup — mine rarely used same page ids even with repetitive usage. However, […]
Read More
Over last 18 months, I’ve given several SQL Saturday (and a PASS Virtual DBA) presentations on indexes. These presentations have evolved and I find it hard to complete the material I want to address in 60 minutes. But the more I dive into the material, the more I am learning. Several times I have been […]
Read More
What would you do if someone called your baby ugly? How far would you go to rekindle an estranged relationship with your wife, daughter, husband, or son? Have you ever suddenly realized that someone you knew you once loved may not be all that any longer? Sure, you go through the motions, but your heart […]
Read More
Abstract SolarWinds® Database Performance Analyzer (DPA) is a performance analysis product unlike other resource-focused health and alerting monitors; it allows a comprehensive determination of why a particular TSQL statement or stored procedure is slow or creating a performance issue. DPA achieves its performance analysis using wait-based analytics vs. resource utilization/consumption approach. By using this technology, […]
Read More
Making sure that database applications are running optimally is one of the biggest problems faced by DBAs on an ongoing basis. DBAs are constantly monitoring and managing performance while also reacting to end user complaints. When users have to wait longer than they are used to waiting for their applications to respond it is understandable […]
Read More
I’ve come across quite a few articles on the discussion surrounding the “DBA is Dead” topic. I’d like to open this up for discussion. Perhaps the rumors of the imminent demise of the DBA are grossly exaggerated—or are they? There is lots of talk about the value of data, the expansion of data, the movement […]
Read More
About zero cost plans in SQL Server OK, first thing first, what is a “zero cost plan” in SQL Server? I did some digging around and found the following links, which I would encourage you to read before continuing with this post: http://msdn.microsoft.com/en-us/library/ms181055.aspx http://support.microsoft.com/kb/325607 If you’ve done this background reading, you should now be aware […]
Read More
SolarWinds DPA can collect a count of the number of deadlocks to be displayed as a resource graph. For Ignite versions prior to 8.2, you can update two files in order to start collecting the number of deadlocks. Enabling DPA to Collect Deadlock Information The code below takes advantage of the system_health extended event session […]
Read More
Uptime is assumed. Performance is the new black. You can’t hope for performance, you need to be certain of the performance of the system. You need to know what drives performance and how any changes to the system change (or could change) the performance profile. This is, in summary, what performance certainty means. It’s a new world, performance matters Not […]
Read More
With the added complexity of growing data volumes and ever-changing workloads, database performance tuning is now necessary to maximize resource utilization and system performance. However, performance tuning is often easier said than done. Let’s face it, tuning is difficult for a number of reasons. For one thing, it requires a significant amount of expertise in […]
Read More
In a long overdue move Microsoft has drastically changed the installation process for SQL Server Data Tools with the SQL Server 2016 release. In the past, SQL Server Data Tools was the name of two separate and quite different products. One of them was the descendant of the Business Intelligence Development Studio (BIDS) which was […]
Read More
With the SQL Server 2016 release Microsoft has changed the way that they are delivering SQL Server Management Studio (SSMS). In previous releases SSMS was installed as a part of the SQL Server installation itself from the SQL Server Installation Center. That is no longer the case with SQL Server 2016. Now SSMS is not […]
Read More