Click here to monitor SSC


Dennes Torres

Identifying client timeouts


Long running queries often causes client timeout in our applications. One good solution to attack this problem is to identify the timeouts and optimize the queries causing the timeouts. Client timeouts or connection interruptions are identified as Attention events. We can capture the attention events using an Extended Events session. The script to create the […]

23 May 2016 4:33 am by
Tony Davis

SSMS Renaissance


For many good reasons, DBAs and database developers use SQL Server Management Studio (SSMS), not SQL Server Data Tools (SSDT). It is a great relief for them, after several SQL Server releases-worth of general neglect, to see some renewed developmental vigor behind SSMS. Until the approach of SQL Server 2016, DBAs could have been forgiven […]

20 May 2016 11:11 am by
Simple-Talk Editorial Team

Caption Competition 55 – Lupine Liaison


There looks to be shady dealings at hand between this pair, what are they up to? Leave a caption in the comments below and, as usual, our favourite will win an Amazon voucher worth $50.

18 May 2016 3:32 pm by
Laerte Junior

Quick Tip – Changing the SQLSERVER: location after import SQLPS module


You probably already must have realized when you import the SQLPS module the current location will be the SQL Server Provider :   If you want to change it and after imported it not keeps in the SQL Server Provider, just open the C:\Program Files (x86)\Microsoft SQL Server\XXX\Tools\PowerShell\Modules\SQLPS\SqlPsPostScript.PS1 and add the line Set-Location c: Set-Location SQLSERVER: […]

11 May 2016 1:37 pm by
Dennes Torres

How to identify contention in TempDb

1 comment

TempDb database is used to store all temp tables created for our applications. Whether explicit or implicit created, all temp tables activity is done in tempdb, creating a bottleneck. For this reason, it’s important to identify tempdb contention. Tempdb contention will appear in the form of latches. Latch is a synchronization object that protects internal […]

9 May 2016 7:31 pm by
Simple-Talk Editorial Team

Caption Competition 54 – Balancing Books


Teamwork, tomfoolery, or tug-of-war? Leave a caption in the comment and the best answer will win an Amazon giftcard worth $50. As usual, we’ll announce the winner in the next newsletter (May 23rd).

5 May 2016 5:04 pm by
Tony Davis

9 Clickbait Simple-Talk Titles You Won’t Believe Exist!


At Simple-Talk, we specialize in practical, down-to-earth technical articles, and usually choose our titles to match. There’s no mistaking what “Comparing Networking options in Azure“ might be about, for example. Nor is there much room to doubt what’s in store in “Debugging data flow in SQL Server Integration Services“. Are we wrong to be so […]

5 May 2016 4:03 pm by
Ben Emmett

Azure Database and Query Store support in ANTS Performance Profiler


Azure SQL DB support After identifying a slow-running SQL Server query, ANTS Performance Profiler allows you to view its execution plan. This has been great for on-premise SQL Server, but until now it hasn’t been possible for those using Azure SQL DB, primarily due to a different security model on Azure. The latest version of […]

3 May 2016 11:55 am by
Dennes Torres

How to find blocked process


Blocked processes are often a big problem to DBA’s. They are difficult to monitor. We receive desperate calls saying “Everything is slow!” and before we can do anything a second call “Oh, don’t worry, it’s everything ok again”. Most of times it happens because ill-behaved process that blocks other tasks for short periods. How can […]

2 May 2016 7:10 pm by
Dennes Torres

Are the statistics being updated?


The auto-update statistics configuration updates statistics when the amount of row changes in the table achieves 20% of total rows. However, for tables with too many rows, this threshold is too high. For example, a table with 1 million rows will only update statistics after 200 thousands changes. That’s too much and can affect query […]

27 April 2016 2:47 am by
Older posts

Blog archive