Here is a T-SQL query to Get Details of AlwaysOn HighAvailability Groups AvailabilityGroup Listeners

Here is a T-SQL query to Get Details of AlwaysOn HighAvailability Groups AvailabilityReplicas.

I was working on some reports and the report was rendered successfully. Then i went to have my lunch and then came back and to fetch the latest data, I clicked on referesh and Bammmm!!, I was hit with a error "the report execution has expired or cannot be found. (rsexecutionnotfound)"

Specific Error: the report execution wouibt55ln003rijpxkrbu45 has expired or cannot be found. (rsexecutionnotfound)

You may witness that a SQL Services on a cluster you have maintained failed over to another node unexpectedly. You might see the below error.

"The Cluster service is shutting down because quorum was lost."

You then try to troubleshoot and you will come across series of errors as below.

Well, many times you might have come across the error or warning saying, that buffer cache hit ratio is low, less, below some percentage etc.

So what is Buffer Cache Hit Ratio?

Wondering how to find out Buffer Cache Hit Ratio on SQL Server?

Below is a T-SQL script to get the Buffer Cache Hit Ratio on a SQL Server.

In my previous post I had written about SQL Server Central Management Server (CMS)

Now let us see how to Configure Central Management Server in SQL Server step by step.

1. Open SQL Server Management Studio, Go to View and Click on Registered Servers as shown below.

Microsoft always comes up with some really interesting features in its every release. Central Management Server popularly known as CMS was one such interesting and useful feature which was introduced in SQL Server 2008. So what is Central Management Server, is this a New Server, New license required, a new product or what? Answer is no.

Multiple Active Result Sets (MARS) is a feature that works with SQL Server to allow the execution of multiple batches on a single connection. When MARS is enabled for use with SQL Server, each command object used adds a session to the connection. The MARS feature is disabled by default. It can be enabled by adding the "MultipleActiveResultSets=True" keyword pair to your connection string and disable MARS by adding the "MultipleActiveResultSets=False" keyword pair to your connection string.

You have scheduled your backups to a Shared Location or Network Path. Your backup was running fine, one fine day you suddenly come across an error saying "A nonrecoverable I/O error occurred on file "" 64(The specified network name is no longer available.)."

When you check for more information in logs you will find more description such as