Tag Archives | SQL 2012

Traffic Flow With Read-Intent Routing

One of the big advantages to using SQL Server Availability Groups is the ability to automatically push read traffic over to a secondary server. This is particularly useful for larger queries that would take a few seconds to run and consume large amounts of resources. It’s not something recommended for short, fast queries, just because […]

Continue Reading 1

SQL Server 2012 Data Loss Bug

Microsoft have just posted a hotfix for a very serious bug in SQL Server 2012.  This bug could potentially cause you to lose data during online index rebuilds.   At this time I would not recommend downloading the hotfix (wait for a CU which will address the problem). In the meantime follow the posted workaround […]

Continue Reading 0

Change Tracking Cleanup – Going Beyond Automatic

As I’ve previously mentioned, the automatic cleanup process of the syscommittab table limits you to being able delete 14.4 million rows a day. This is a problem in a highly transactional system with volatile tables. Where the automated cleanup process let’s you down there is an undocumented stored procedure which will allow you to perform […]

Continue Reading 1

Change Tracking Cleanup – Example

In my last post I wrote about a limitation of Change Tracking and in particular a limitation in the cleanup process for the syscommittab table. I thought that a quick example of seeing this in action might be useful in allowing you to check for the issue yourself.   First things first, we setup a […]

Continue Reading 1

Change Tracking Cleanup Limitation

I’ve been “fortunate” enough to be working a great deal with Change Tracking recently and have run into a limitation that it’s worth keeping an eye out for on your servers. If you have a database, with Change Tracking enabled, and the total number of transactions exceeds 14.4 million for all of the tables that […]

Continue Reading 0