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…


Backup Compression for TDE-enabled Databases: Important fixes in SQL 2016 SP1 CU4 and SQL 2016 RTM CU7

Backup Compression and Transparent Data Encryption (TDE) have been two immensely valuable and popular features for customers in SQL Server. In SQL Server 2016, backup compression was enabled for TDE-enabled databases, where if you backup a TDE-enabled database with compression and MAXTRANSFERSIZE > 64K, backup compression will kick in, reducing backup size and improving overall…


Choosing the right server memory for restore and recovery of memory-optimized databases

Recovering database with memory-optimized tables involves hydrating the contents of checkpoint files (data/delta files) into memory and then replaying the tail of the log (see this link for more details). One of the important difference between disk based tables and memory-optimized store is frequency of checkpoints. Automatic checkpointing for in-memory tables occurs every 1.5GB of…


Tiger Team and Data Migration team at Data Platform Summit 2017

Tiger Team (@mssqltiger) represented by (Ajay Jagannathan, Parikshit Savjani, Tejas Shah and Akbar Farishta) and the Data Migration team represented by (Sudhakar Sannakkayala, Amit Banerjee and Nikhil Patel) will be in full force by speaking at 17 sessions at the Data Platform Summit (#DPS2017), Asia’s Premier Data & Analytics Conference taking place on 17-19 August…

1

Persisting statistics sampling rate

When SQL Server creates or updates statistics and a sampling rate is not manually specified, SQL Server calculates a default sampling rate. Depending on the real distribution of data in the underlying table, the default sampling rate may not accurately represent the data distribution and then cause degradation of query plan efficiency. To improve this…


New in SSMS: Searching in Showplan

Have you ever analyzed a somewhat big plan? And while doing so did you ever wish you could search for something like table name, index name or column name? In SSMS 17.2, we are including the ability to search all these and more in graphical showplan. Let’s look at an example. I executed a query…


New in SSMS: Performance Dashboard built-in

Back in 2007, we released the Microsoft SQL Server 2005 Performance Dashboard Reports, which were designed to provide fast insight into performance issues from some newly created system views – DMFs (Dynamic Management Views). These were updated for SQL Server 2008 and later to SQL Server 2012, and while being very helpful they had a…


Correlating xEvents with DMVs

Since the inception of xEvents there has been the need to occasionally correlate data from xEvent collections and DMVs. Specifically, using the query_hash and query_plan_hash actions and correlate with DMVs such as sys.dm_exec_requests and sys.dm_exec_query_stats for example. The blog post on Correlating XE query_hash and query_plan_hash to sys.dm_exec_query_stats in order to retrieve Execution plans for…