Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 516 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, 707 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

DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS

And try to understand the messages. Read more

0 comments, 213 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

1 comments, 1,190 reads

Posted in Vinay Thakur on 17 December 2011