Sql Server DAC error : Dedicated administrator connections are not supported. (ObjectExplorer)

Posted by Sqltimes
On November 28, 2015
0 Comments

Quick one today: Earlier this interesting error occurred in our environment. When we tried to use DAC, we ran into this error: Dedicated administrator connections are not supported. (ObjectExplorer) For a few moments it seemed unsettling. If a DAC connection cannot connect so Sql Server, then we are in big trouble. Upon some contemplation (a.k.a. […]

Posted by Sqltimes
On November 21, 2015
0 Comments

Quick one today: Interesting topic today: Does recompiling procedure stop current executions of the procedure? Of late, in our lab, we’ve been needing to run several performance tests (volume testing) to measure performance metrics under different load and traffic patterns. In one of those iterations, we ran into a peculiar situation, where we needed to […]

Posted by Sqltimes
On November 14, 2015
0 Comments

Quick one today: Sometimes, in our lab and performance testing environments, we end up in a situation where we need to remove and re-add indexes while running tests on different scenarios. In these situations, rather than DROPping and re-CREATing indexes, there is a simpler way to manage these things. The underlying activities that happen under […]

Posted by Sqltimes
On November 7, 2015
0 Comments

Recently we ran into some deadlocks in our performance test environment that resulted in some good analysis and resolution techniques. In this post, those techniques will be presented in an overly simplified way to be used only for reference. Thorough analysis and learning needs to happen on each of these techniques before they are implemented. […]

Sql Server DAC error : Dedicated administrator connections are not supported. (ObjectExplorer)

Sql Server : Does recompiling a procedure stop the current executions?

Sql Server : How to enable and disable indexes

Sql Server: Different types of deadlocks and possible resolution techniques