Monthly Archives: October 2013

TempDB Contention 2.1.%

Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of  2.1.103 check perfomance counter: Temp Tables Creation Rate Temp Tables For Destruction When you are performing many DML operations and makes … Continue reading

Posted in DB Design, DMV, Internal, Lock/Blocking, Performance Tuning, TempDB, Troubleshooting | Leave a comment

Cluster failover fails

you may get an error while trying to failover to another node cluster.   to resolve this issue create an alias on the node with the cluster name and it should work. will blog more on this later.  

Posted in High Avaliability, Troubleshooting | Leave a comment

LogReader agent failed

You may get an error on log reader agent failed with following error:   Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. … Continue reading

Posted in Replication, Transaction Log, Troubleshooting, What I learned today | Leave a comment