Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Read more

0 comments, 275 reads

Posted in Vinay Thakur on 16 October 2013

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.  

Read more

0 comments, 260 reads

Posted in Vinay Thakur on 16 October 2013

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

Read more

0 comments, 217 reads

Posted in Vinay Thakur on 16 October 2013