Tag Archives | SQL

Getting the SQL Server Install Path

One of the challenges that comes along with a large number of SQL Servers, that aren’t always built out in a standard fashion, is that you run into problems whereby correct AV exclusions are not set, leading to performance problems (and other issues). Going through and quickly grabbing the location of the SQL Server executable, […]

Continue Reading 0

sp_GetAGInformation – Updated

Yesterday I posted sp_GetAGInformation, a stored procedure for gathering information about configuration of Availability Groups. Based on feedback I’ve added an additional column to indicate the health state of the AG.   Download the updated version for this additional information.

Continue Reading 3

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

SHOWPLAN Permission Denied For A Sysadmin

I came across a curious issue the other day when trying to look at the actual execution plan of a stored procedure that was being developed. Strangely I couldn’t get an estimated plan either. All I got was the confusing error:   SHOWPLAN permission denied in database ‘TestDB’ As a sysadmin on the system in […]

Continue Reading 0

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 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