Log in | Register

Vasudev Menon, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Vasudev Menon, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

VasudevMenon

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

About Vasudev Menon

This author has not yet filled in any details.
So far Vasudev Menon has created 12 entries.

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

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) gave some major headaches. Solving our way through it took up a major amount of time.

Actual SQL DB migration was already running late, when […]

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.

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 the instance concerned.

The SQL instance was configured under windows authentication, not mixed and hence sa was also disabled. “BUILTIN\Administrators” group also got dropped […]

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

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 new “minimum and maximum memory settings” to be proposed for the 5 SQL instance(s) concerned.

Anyone interested in reading up the background on this, […]

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

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, to collect performance counter values and then to study and analyse the memory pressure on the current SQL instance(s)”

Part 2 – How we went about […]

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

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.

Anyone interested in reading up the background on this, can find it here.

With the requirements clear to us on what was needed, we finalized […]

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.

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 “Time-out occurred while waiting for Buffer Latch — Type 3, bp 039FE530, page 1:44377, stat 0xc00009, database id: 9, allocation unit Id: 72057594058833920, […]

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

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, security mappings inclusive of replication properties on all of the SQL instances on the testing environment.

On one of the SQL instances while attempting […]

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.

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 were the most long running sessions, spid(s), during the last 30 minutes back.
Can I get know on who was blocking whom during the last 30 […]

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”

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 boxes, the mandate was to carry out a side by side upgrade. OS was to be upgraded to windows 2008. SQL instance version […]

By |April 28th, 2011|Categories: SQL Server||1 Comment
Newsletter_Footer