Rusanu.com

2017-09-23

I recently had to troubleshoot an ADO.Net connection pool exhaust issue. This problem may indicate a connection leak, but it can also be caused by an...

2016-04-01

Query Store was introduced in SQL Server 2016 and on Azure SQL DB v12 as a way to track query execution statistics. When Query Store is enabled it will...

2016-03-18

After 145 months of employment with Microsoft, at the beginning of March 2016 I quit the SQL Server team to pursue my dream of creating a better solution...

2015-03-06

I recently seen a discussion on the merits of using SQL Server as an application lock manager. Application would start a transaction and acquire app locks...

2014-06-17

Are INSERTs serialized because of row group locks? No. If a trickle INSERT requires an OPEN row group and it cannot place a lock on it it will create...

2014-05-30

One of the most useful performance tools I used internally at Microsoft was the WindowsXRay. I’m pleased to find that it was released the new name...

2014-03-31

One of the most common complains about using Service Broker in production is when administrators discover, usually after some months of usage, that sys...

2014-03-10

The SQL Server transaction log contains the history of every action that modified anything in the database. Reading the log is often the last resort when...

2014-02-24

So you have this SQL Server database that your application uses and it somehow seems to be slow. How do you troubleshoot this problem? Where do you look...

2013-12-02

The updateable clustered columnstore indexes introduced with SQL Server 2014 rely on a background task called the Tuple Mover to periodically compress...