SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2011

Good Bye 2011

Good Bye 2011

Hey there, this year is going to an end and just want to recall what all happened this year in my life both personally (cannot disclose much J) and professionally.

The good news about this year is on 24th Dec 2011, we blessed a second… Read more

0 comments, 1,130 reads

Posted in Vinay Thakur on 31 December 2011

Basics QA on Extended Event

Basics QA on Extended Event



I am learning Extended Event so this is my first blog on extended event, There is a great whitepaper on XEvent by Jonathan Kehayias.

Q1. What is extended event?

A1. It is a light weighted profiler kind of trace introduced on sql… Read more

0 comments, 1,588 reads

Posted in Vinay Thakur on 23 December 2011

Suspect Database

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to check and correct the issue. And sql server dba has to monitor it.

Check the database consistence using


And try to understand the messages. Read more

0 comments, 444 reads

Posted in Vinay Thakur on 19 December 2011

spid in Killed/Rollback cannot kill

We come across a situation where we have to kill one spid which was running for quite some time, so we though killing will help us, but after killing found that that spid is not killed but stuck in our processes spid. And we could not able to kill even Read more

0 comments, 2,512 reads

Posted in Vinay Thakur on 17 December 2011