Centennial apps/desktop bridge, SQL Server and error "The data area passed to a system call is too small."

The title of the blog may throw someone off a little. After all, SQL Server is not a centennial app and the error message doesn’t appear to have anything to do with SQL Server. So please bear with us while the whole scenario is explained. Note: Here is an introduction to Centennial apps/Desktop bridge which…


New in SSMS – Always On Availability Group Latency Reports

With SQL Server 2012 we introduced Always On Availability Groups, and the Always On Availability Group Dashboard in SQL Server Management Studio (SSMS). This dashboard can be utilized by database administrators to view the current health of an Availability Group and its availability replicas and databases. While the dashboard can be configured to provide information…

11

Upgrade your SQL Server to scale before adding new hardware

In SQL Server Tiger team, we closely partner with our customers and partners to ensure they can successfully run and scale their Tier 1 mission critical workloads and applications on SQL Server. Based on our experience and interactions with customers, we found that most customers running older releases of SQL Server and experiencing performance and…


How we made backups faster with SQL Server 2017

In my previous blog post on enhancements in SQL Server 2017, we briefly introduced improved backup performance for smaller databases in SQL Server 2017 on high end servers. In the recent PASS Summit 2017, Pedro and I delivered a session on Intelligent diagnostics where we explained how we leveraged the indirect checkpoint heuristics to enable…


Perfect statistics histogram in just few steps

A similar question about statistics came to the team twice this week: why does updating with fullscan result in fewer histogram steps than when doing a sampled scan? The answer is: the number of histogram steps can be fewer than the number of distinct values. For a histogram with perfect distribution (frequency* = 1), the…

0

Making parallelism waits actionable

During PASS we announced changes to how users will be able to make parallelism waits more actionable – specifically the “infamous” CXPACKET. This change effectively splits CXPACKET waits into an actionable wait (CXPACKET) and a negligible wait (CXCONSUMER). This change will be effective starting with upcoming SQL Server 2017 CU3 and SQL Server 2016 SP2…

4

New Showplan enhancements

If you follow this blog, you have seen that in the past few releases we have continuously included a number of diagnostic improvements to Showplan. You can read about some of them here. Looking at the actual execution plan is one of the most used performance troubleshooting techniques. Having information on elapsed CPU time and…


Monitoring SQL Server and Azure SQL DB Session at DBA Fundamentals PASS VC

On 10/17/2017, we delivered a webinar session titled “Comprehensive Guide for Monitoring SQL Server and Azure SQL DB” hosted by DBA Fundamentals PASS Virtual Chapter. You can find the link to the recording below. In the session, we talked about different tools you can use to monitor your SQL Server, both on Windows and Linux, and Azure SQL DB…

0

SQL Server Tiger at PASS Summit 2017

The SQL Server team will again be at the Summit this year. If we are not speaking or co-speaking in a session, you can find us at the SQL Server Clinic at any time. Sessions Here are the sessions where the SQL Server Tiger team is speaking or co-speaking: SQL Server 2017: “Intelligence: Meet Database”…


SQL Server 2012 Service Pack 4 (SP4) is now available!

SQL Server Product Team is excited to bring you the final release of SQL Server 2012 Service Packs, Service Pack 4 (SP4). This release of SQL 2012 Service Pack has 20+ improvements centered around performance, scalability and diagnostics based on feedback from customers and the SQL Server community. These improvements enable SQL Server 2012 to perform…