Most Popular Databases

SQL Server Clustered Index Btree Traversal

–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

A Tidbit on SQL Server Indexing

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

Merits of a SQL Server Performance Analyzer vs. Performance Monitor(s)

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

Understanding DB2 Performance

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

Why DPA Uses SQL Server Trace Flag 2861 and Zero Cost Plans

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

Collecting and Alerting on Deadlocks for SQL Server

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

The Importance of Performance Certainty

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

Installing SQL Server Management Studio for SQL Server 2016

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
710