Tags » SQL Server

SQL SERVER - Using Buffer Pool Extension with In-Memory OLTP?

I am always amazed to see the questions asked by my blog reader which lead me to learn more about SQL Server.  Here is the question which took me little time to figure out the answer. 278 more words

SQL Authority

Find IO statistics of a Database - SQL server

USE
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE .
as
;with IOS as(SELECT TOP 100
= (total_logical_reads + total_logical_writes) / qs.execution_count, 173 more words

SQL Server

Checklist for Database File Movement

Below are the steps, which I usually follow as part of any database file movement activity.

  • Check the last full database backup completed successfully. If your change windows allows, prefer to take a latest full backup of the database.
  • 401 more words
SQL Server

Installing a SQL Server failover cluster and configuring and migrating databases (Part 2)

So, you have a Windows 2012 R2 Cluster, you have your copy of SQL Server 2008 R2 all slipstreamed with SP2 or above, you’re good to go, you launch the installer and at the cluster verification check you get a “Cluster Service verification rule” failure.   142 more words

Clustering

Installing a SQL Server failover cluster and configuring and migrating databases (Part1)

Today I installed SQL Server 2008 R2 Standard on a Windows Server 2012 R2 cluster.  Not my preferred choice of SQL Server product but needs must. 213 more words

Clustering

SQL Server Buffer Pool Not Expanding Beyond 16GB

I thought I would share one of the problem I’ve been looking at lately. Basically we have identified (so far) 3 instances where the buffer pool won’t expand beyond 16GB. 597 more words

SQL Server