Skip to content
February 7, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Author: Vasudev Menon

SQL Server

SQL Server: Troubleshooting a SQL 2005 database that went into a suspect mode.

June 12, 2011July 12, 2014 - by Vasudev Menon - 8 Comments.

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 More
SQL Server

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.

May 24, 2011August 28, 2014 - by Vasudev Menon - 1 Comment

In 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 More
SQL Server

SQL Server: Performance counters used to study and analyze the current memory usage of SQL instance(s) to analyze memory pressure – Part 3

May 22, 2011August 28, 2014 - by Vasudev Menon - 1 Comment

In 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 More
SQL Server

SQL Server: Performance counters used to study and analyse the current memory usage of SQL instance(s) to analyze memory pressure – Part 1

May 21, 2011August 28, 2014 - by Vasudev Menon - Leave a Comment

Dear 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 More
SQL Server

SQL Server:Performance counters used to study and analyze the current memory usage of SQL instance(s) to analyze memory pressure – Part 2

May 21, 2011August 28, 2014 - by Vasudev Menon - Leave a Comment

In 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 More
SQL Server

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.

May 17, 2011August 28, 2014 - by Vasudev Menon - Leave a Comment

Yesterday, 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 More
SQL Server

SQL Server: Attempt to script replication properties using SSMS fails with error 512

May 8, 2011July 12, 2014 - by Vasudev Menon - 1 Comment

One 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 More
SQL Server

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.

May 8, 2011August 28, 2014 - by Vasudev Menon - Leave a Comment

Many 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 More
SQL Server

Troubleshooting Orphaned Users SQL Server. How to list them out and fix them.

May 8, 2011December 18, 2014 - by Vasudev Menon - 1 Comment

Today, 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 More
SQL Server

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”

April 28, 2011August 28, 2014 - by Vasudev Menon - 1 Comment

A 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

Posts navigation

1 2 Next

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.