SQL Server Education (by the geeks, for the geeks)
What happened? During the ongoing SQL migration on our TESTING environment cluster, things were not progressing as per plan. Initially the EVA SAN LUN(s) movement from source to target cluster node(s) …
SQL Server: Troubleshooting a SQL 2005 database that went into a suspect mode. Read MoreIn the month of February, during early morning hours, one of our DBA(s) mistakenly ran a script on a remote SQL instance, APPROVAL environment, which deleted all logins and groups from …
SQL Server: How to gain access back onto the SQL instance in case you get completely locked out of the instance with no sysadmin access available. Read MoreIn this section I am going to cover, as to how we went about analyzing the performance counter values captured and then based on the results, arriving to conclusions on the …
SQL Server: Performance counters used to study and analyze the current memory usage of SQL instance(s) to analyze memory pressure – Part 3 Read MoreDear Friends, Please do bear with me as I am going to cover this topic in 3 parts. Part 1 – To give a background on “why was this exercise initiated, …
SQL Server: Performance counters used to study and analyse the current memory usage of SQL instance(s) to analyze memory pressure – Part 1 Read MoreIn this section I am going to cover, how we went about setting up the performance counters to be collected for a duration of 18 hours and which counters were used. …
SQL Server:Performance counters used to study and analyze the current memory usage of SQL instance(s) to analyze memory pressure – Part 2 Read MoreYesterday, afternoon we had a support executive from a remote development approach our DBA team requesting help on understanding why is their SQL error log being flooded with the error message …
SQL Server: SQL Error log being flooded with error message “Time-out occurred while waiting for Buffer Latch — Type 3” and how this was investigated to understand the root cause. Read MoreOne of our DBA team mates got a task remit to refresh the complete testing environment. As part of the pre-implementation steps he was required to script out the various configurations, …
SQL Server: Attempt to script replication properties using SSMS fails with error 512 Read MoreMany a times a DBA wishes for the below information, during performance troubleshooting, Can I get to know what was being executed 30 minutes back. Can I get to know which …
SQL Server: Why is it necessary to capture and store information on sessions i.e. spid(s) running on a SQL instance for troubleshooting purpose. Read MoreToday, I was again requested for peer support from one of our DBA team mates who is racing against time to complete the TESTING environment refresh with LIVE data. As part …
Troubleshooting Orphaned Users SQL Server. How to list them out and fix them. Read MoreA couple of months back our infrastructure team had undertaken a project to upgrade server hardware and the OS as part of their objective to make systems more resilient. For the …
SQL Server: The curious case of SSIS package(s) failing with the message “The version number in the package is not valid. The version number cannot be greater than current version number” Read More