When DBCC INPUTBUFFER disappoints

Today we have an alert from one of the client server about blocking, I have immediately start looking at it using below statement SELECT * FROM MASTER..SYSPROCESSES WHERE BLOCKED != 0  Yes, I’ve found the culprit SPID that is occupying more resources, using DBCC INPUTBUFFER(SPID). so, instead of seeing what exactly this SPID is doing I have received SP_EXECUTESQL, surprised!!! No, it’s bound to happen when SPID is running dynamic TSQL (using SP_EXECUTESQL) and/or cursor. But, yes, at the same time I would like to know...

Read More

Rebuild System Databases

Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation goes like: FB Friend: Hi I : Hi FB Friend: I need your help FB Friend : My SQL Server is not starting... I : What is an error you are getting? FB Friend : Just nothing I : Ok, check the SQL Server Error Log and EventViewer I : you can find errologs at C:\Program Files\Microsoft SQL Server\MSSQL11.DENALI\MSSQL\Log I : open it...

Read More

Revamping SUG 2nd Meeting

Friends, Last Saturday, 21st we have 2nd meeting of SUG members and this time we made progress – I, Vinay and Matang was present in meeting .We have discussed following : We have decided that portal management will be done by I, Vinay and Matang initially, here are the module that we’ll be adding content on: Forums and Team section –> Hemantgiri S Goswami Article Section –> Matang Panchal Blog Section –> Vinay Pugalia ...

Read More

Roles and Responsibilty of SQL Server DBA

What is a role of a DBA in an organization? What are the daily activities of a DBA? What shall I check on regular basis? What all processes shall I automate ? What are the precautions, I have to take additionally? These are the common question being asked in-common on may forums, here is what my listing is • Design and implement Disaster Recovery • Design, development, upgrade and Migration of Database Server. • Providing support and handling most critical situations in vast variety of database systems. • Database...

Read More

Wishing you all a very Happy and Prosperous new year, may success comes to your doorstep Image source : Top CNN Ne...

Read More