I wanted to start writing a series of blogs on mirroring to share what I’ve learned over the years and since SQL Server 2005 gave us this feature. Before we go into that I want to go over the operating modes that we have in mirroring. We have two operating modes, Asynchronous and synchronous. The first major key is Asynchronous operating mode is only available in Enterprise Edition (and Developer).

If you are using snapshots be aware that running sp_helpdb reports wrong files. Let's take a look by running some code

First create a test database

Here is something interesting to think about

Create this table and insert these 2 rows

To me it seems that Visual Studio Team System 2008 Database Edition is the stepchild of the Visual Studio family. Even in shops that have MSDN Universal/Ultimate subscriptions this version is just not used that much. Maybe it is that long name of this product, I still prefer DataDude. I would like to show you that if you do have licenses for this tool then you should use it because it has some great features. Today we will focus on static code analysis.

Before we start, make sure to grab Microsoft Visual Studio Team System 2008 Database Edition GDR R2

and install that on top o...

In order to figure out if you need more memory for a SQL Server you can start by taking a look at Buffer cache hit ratio and Page life expectancy.

Buffer cache hit ratio

Here is what Books On Line has to say about Buffer cache hit ratio

Buffer cache hit ratio

Percentage of pages found in the buffer cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups over the last few thousand page accesses. After a long period of time, the ratio moves very little. Because reading from the cache is m...