Sign in
SQL Server Premier Field Engineer Blog
This is a shared team blog of the SQL Server Premier Field Engineer team
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
Analysis Services
Database Engine
Replication
Reporting Services
SSIS
Archive
Archives
June 2013
(2)
May 2013
(2)
April 2013
(6)
March 2013
(4)
February 2013
(5)
April 2011
(1)
August 2010
(1)
February 2010
(2)
December 2009
(2)
August 2009
(3)
July 2009
(4)
June 2009
(4)
May 2009
(2)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server Premier Field Engineer Blog
An overview of High Availability and Disaster Recovery solutions available for SQL Server
Posted
4 days ago
by
SQL Server Premier Field Engineering
2
Comments
With the more recent releases of SQL 2012 and Windows 2012, we are seeing the landscape of available options for SQL HA/DR specific architectures is improving significantly. Below is a summary of the high availability and disaster recovery solutions available...
SQL Server Premier Field Engineer Blog
SQL Server Analysis Services Multidimensional Model – Merging Partitions with Slice
Posted
16 days ago
by
SQL Server Premier Field Engineering
0
Comments
According to SQL Server Books Online: Partitions can be merged only if you meet all of the following criteria: http://technet.microsoft.com/en-us/library/ms175318.aspx . They are in the same cube. · They have...
SQL Server Premier Field Engineer Blog
Flow Control in Always On Availability Groups – what does it mean and how do I monitor it?
Posted
1 month ago
by
SQL Server Premier Field Engineering
0
Comments
A question was posed to me whether Flow Control which existed in Mirroring was still relevant for Availability groups. Flow Control is primarily a mechanism to gate or throttle messages to avoid use of excessive resource on the primary or secondary...
SQL Server Premier Field Engineer Blog
Implications of the SQL Server Bulk Logged recovery model on point in time restores
Posted
1 month ago
by
SQL Server Premier Field Engineering
0
Comments
Choosing the database recovery model is one of the more important choices DBAs have. If the business does not need to recover a database to a point in time (PIT) then the SIMPLE recovery model is the choice for you. However, if PIT recovery...
SQL Server Premier Field Engineer Blog
Compare SQL Failover Cluster Instance SQL and OS Node Versions using PowerShell
Posted
1 month ago
by
SQL Server Premier Field Engineering
0
Comments
It is a common check to see if all of the nodes in a cluster are equally patched. The reason behind this is because in order to ensure stable operations and a consistent experience, it is best practice to have all nodes of a failover cluster instance...
SQL Server Premier Field Engineer Blog
Identifying the cause of SQL Server IO bottlenecks using XPerf
Posted
1 month ago
by
SQL Server Premier Field Engineering
2
Comments
In a previous blog post ( Troubleshooting SQL High CPU usage using Xperf ), we covered the xperf basics, what types of scenarios are appropriate for xperf, and more specifically, how to look at CPU sampling within xperf. In general, user...
SQL Server Premier Field Engineer Blog
SQL 2012 System Health Reporting Dashboard – Visualizing sp_server_diagnostics results.
Posted
2 months ago
by
SQL Server Premier Field Engineering
14
Comments
We have introduced the System Health Session in SQL 2008 in order to capture some critical Events to make post mortem analysis much easier. However in SQL 2008, by default the system_health session was only collected to a ring buffer and not persisted...
SQL Server Premier Field Engineer Blog
Get the Active Power Plan of Multiple Servers with PowerShell
Posted
2 months ago
by
SQL Server Premier Field Engineering
0
Comments
It is a widely known and discussed performance hit when you don’t have an optimal power plan set on your database servers. This is one of those easy ways to get great gains by simply flicking a switch…almost literally. But what happens if...
SQL Server Premier Field Engineer Blog
SQL 2012 AlwaysOn Availability groups Automatic Failover doesn’t occur or does it – A look at the logs
Posted
2 months ago
by
SQL Server Premier Field Engineering
3
Comments
I was dealing with an issue where we had an AlwaysOn availability group with 2 replicas configured for Automatic failover. There was a 30 second glitch where folks could not connect to the Database on the primary and automatic failover did not...
SQL Server Premier Field Engineer Blog
Viewing SQL Server Non-Clustered Index Page Contents
Posted
2 months ago
by
SQL Server Premier Field Engineering
0
Comments
In this blog post I’ll take a look at what is actually stored in a non-clustered index and (re)introduce you to some tools that you can use for looking at the contents of a given data or index page. Hopefully, by the end of the examples you’ll...
SQL Server Premier Field Engineer Blog
SQL FileStream Restore and Anti-Virus
Posted
2 months ago
by
SQL Server Premier Field Engineering
0
Comments
I encountered an interesting case with FileStream and Antivirus which I looked at with Bob Dorr, blogged about it on the PSS SQL Blog, thought I’d share that link here as well http://blogs.msdn.com/b/psssql/archive/2013/03/29/the-case-of-anti-virus-filter...
SQL Server Premier Field Engineer Blog
Observing SQL Server Transaction Log Flush Sizes using Extended Events and Process Monitor
Posted
2 months ago
by
SQL Server Premier Field Engineering
0
Comments
In this blog post we’ll take a look at how SQL Server interacts with the transaction log file using Extended Events and Process Monitor. We will see how small transactions can have a negative impact on transaction log IO throughput and how larger...
SQL Server Premier Field Engineer Blog
Troubleshooting SQL Server High CPU usage using Xperf
Posted
3 months ago
by
SQL Server Premier Field Engineering
0
Comments
Xperf/WPA is a powerful Windows tracing tool that can be used to assist in troubleshooting numerous issues on a Windows server. The utility allows for in depth tracing without the high overhead typically associated with such tracing...
SQL Server Premier Field Engineer Blog
Dissecting SQL Server physical reads with Extended Events and Process monitor
Posted
3 months ago
by
SQL Server Premier Field Engineering
2
Comments
In this blog post I’ll (re)introduce you to a really neat tool to use alongside of SQL Server and use this tool to show you how SQL Server is handling IO under the covers. We will view the IOs as they occur, and then tie the IO back to the...
SQL Server Premier Field Engineer Blog
SQL Server 2012 Partially Contained Databases Part 2 - Collation
Posted
3 months ago
by
SQL Server Premier Field Engineering
0
Comments
In my last post, I went over partial database containment and contained users. This post will focus on the other piece of functionality in partial containment… collation. The collation of data determines how data is sorted and compared...
SQL Server Premier Field Engineer Blog
SQL Server 2012 Partially Contained Databases Part 1 - Contained Logins
Posted
3 months ago
by
SQL Server Premier Field Engineering
1
Comments
The concept of database containment basically means that all instance level dependencies are severed from the database. If you have ever implemented log shipping or mirroring, you are probably aware of many of these. Instance level logins...
SQL Server Premier Field Engineer Blog
Use PowerShell Script via startup Agent Job to balance Memory between two instances on a cluster on a Failover
Posted
3 months ago
by
SQL Server Premier Field Engineering
0
Comments
Scenario: You have a two instance, two node cluster. SQL1 is typically running on Node1, SQL2 is typically running on Node2. The Objective is to maximize memory usage when each instance is running on its own node, yet balance memory usage if both of them...
SQL Server Premier Field Engineer Blog
MDX: SET overwrite and the use of EXISTING function
Posted
4 months ago
by
SQL Server Premier Field Engineering
0
Comments
The SET overwrite is largely impacted by the attribute relationships and the behavior does depend on whether the attribute is below or above or no relationship in the relationship chains. For illustrate the point, I run a test base on the following...
SQL Server Premier Field Engineer Blog
SQL Collation and related performance impact, viewing collation in query plans
Posted
4 months ago
by
SQL Server Premier Field Engineering
0
Comments
It has been a while since there has been activity on this blog, we as a team will be trying to post weekly going forwards so as to share what we do on a regular basis – happy reading! I was posed a question by a fellow PFE during his performance...
SQL Server Premier Field Engineer Blog
Merge Replication Conflict Detection vs Conflict Resolution Part 2: Custom Business Logic Handler
Posted
over 2 years ago
by
SQL Server Premier Field Engineering
4
Comments
Attached is a sample Merge Conflict Handler sample I created. I am including a walkthrough of the sample below. 1. Create the sample merge publication/subscription databases Code Snippet: From file <1-CreatePub_Sub_DBs...
SQL Server Premier Field Engineer Blog
Backup compression behavior when appending backups to an existing Media Set
Posted
over 3 years ago
by
SQL Server Premier Field Engineering
0
Comments
There will be an upcoming Knowledge base article detailing this out as well When you append a compressed backup to an existing Media, it inherits the compression setting from the Media set. If you rely on the ‘backup compression’...
SQL Server Premier Field Engineer Blog
Merge Replication Conflict Detection v/s Conflict Resolution
Posted
over 3 years ago
by
SQL Server Premier Field Engineering
2
Comments
One common misconception about how merge replication handles column-level tracking (detection) is that when a conflict is encountered, the winning row will include column values which did not conflict in addition to the "winning columns". For...
SQL Server Premier Field Engineer Blog
Last Known Good Backup/DBCC
Posted
over 3 years ago
by
SQL Server Premier Field Engineering
4
Comments
Based on Paul Randal’s post telling how to get the last known good DBCC ran against a database, based on my job requirements, I decided to write a T-SQL script which has nothing new but returns last known good DBCC execution time and last backup...
SQL Server Premier Field Engineer Blog
SQL Server memory models (Part II)
Posted
over 4 years ago
by
SQL Server Premier Field Engineering
0
Comments
So what is part II about? It is about a change in Standard 64 bit Editions of SQL Server 2005 and 2008. This change implements the support of AWE APIs and “Lock Pages in Memory” privilege by these editions. It has been already advertised by Bob...
SQL Server Premier Field Engineer Blog
How and Why to Enable Instant File Initialization
Posted
over 4 years ago
by
SQL Server Premier Field Engineering
5
Comments
You may want to consider enabling Instant File Initialization (via SE_MANAGE_VOLUME_NAME a.k.a. "Perform volume maintenance tasks") for your SQL Server startup/service account. This option allows for much faster data file allocations (CREATE...
Page 1 of 2 (38 items)
1
2