Profile cover photo
Profile photo
Ajay Dwivedi
51 followers -
Individual, Blogger, Programmer, SQL Server Professional, Son, Husband & Friend to Many :)
Individual, Blogger, Programmer, SQL Server Professional, Son, Husband & Friend to Many :)

51 followers
About
Ajay's posts

Post has attachment
In my previous organization, working as Senior SQL Developer, I was often asked for help by fellow colleagues for identifying issues inside long and complex TSQL codes. Finding issues becomes much trickier if the issue is Runtime error. So, as a solution…

Post has attachment
Hi Friends, in my previous blog post Log all Activities using sp_WhoIsActive, I shared how easy it is to log all sql server sessions using sp_whoIsActive and SQL Server Agent job. Today, let’s do the same logging activity but without Agent job. So below…

Post has attachment
In my organization, as part of our strategy we keep Data files in 2 TB sized Mount Point Volumes named like ‘Data’,’Data01′,’Data02′ etc. on E:\ drive. Similary, for Log files also, we have 2 TB sized Mount Point Volumes named like…

Post has attachment
I often receive the question – what is the best way to find issues when client/user complaints of deadlock issues? Msg 1205, Level 13, State 51, Line 10 Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen…

Post has attachment
Recently I received an incident for low disk space on mount point dedicated to system databases on development sql server. So I started checking SQL Server Error logs to find out what’s filling up the msdb database, and encountered multiple occurrences of…

Post has attachment
In my current organization, we have lot of servers where database mirroring is used as a disaster recovery option. Either we are setting up mirroring from scratch or dropping the existing mirroring and re-establishing it, it is going to take from 30 min…

Post has attachment
Recently I received an incident for CheckDB job failure on one of our production server. Job history suggested that the job has been continuously failing for past 15 weeks. But, no significant message was found in job history. So I started checking SQL…

Post has attachment
Today, I was working on an incident of slow running procedure. Procedure was running fine for most of the parameter values but, was getting stuck for few values. I could not find anything significant from wait stats. The session id was showing in runnable…

Post has attachment
It is not a new thing for a DBA to check what’s running currently on server in order to figure out issues. My personal favorite tool for finding out current activities is Adam Mechanic’s sp_WhoIsActive. Thanks to SQL Server communities like Brent Ozar…

Post has attachment
Hi Friends, Today at work I received an access request to provide multiple database permissions to multiple AD groups on servers. After providing appropriate db roles membership to requested AD groups using TSQL code EXEC sp_addrolemember [],[], I marked…
Wait while more posts are being loaded