SQL in Stockholm

SQL Server thoughts from the support team in Stockholm

The end of the line

Today is my last day at Microsoft. I’m off to do something completely different, joining a small...

Author: Graham Kent [MSFT] Date: 02/04/2011

SQL Server blocking caused by database mirroring wait type DBMIRROR_DBM_EVENT

I was looking at a problem this morning about long blocking chains caused by the wait type...

Author: Graham Kent [MSFT] Date: 01/10/2011

Compatibility problems between DMO and SMO connectivity on newer versions of SQL Server

We've recently been looking at a problem which triggered this error: [Microsoft][ODBC SQL Server...

Author: Graham Kent [MSFT] Date: 01/05/2011

Extended Event to track and trace syntax errors

This might sounds like a strange requirement, but it can be converted to do a number of different...

Author: Graham Kent [MSFT] Date: 12/10/2010

SQL Server performance problems due to high privileged CPU time when running Windows Server 2008 R2

It's very rare that I tell people to blindy apply service packs or hotfixes (especially windows...

Author: Graham Kent [MSFT] Date: 11/01/2010

The Forefront TMG/UAG team in Stockholm is hiring

Following the success of my previous post about recruitment, we're advertising another position from...

Author: Graham Kent [MSFT] Date: 09/27/2010

The SQL Server Support Team in Stockholm is hiring

Update 23th August This position has now been filled - thanks for everything who submitted their...

Author: Graham Kent [MSFT] Date: 06/22/2010

Script to run in SQL Server Agent to monitor DMVs, log results and take action depending upon results

Here’s a script to play with which is useful for simple management tasks. I wrote it to help...

Author: Graham Kent [MSFT] Date: 06/11/2010

Access Denied error when running SQL Server Transfer Objects Task with a Proxy Account

Should you try to configure an SSIS package which uses the Transfer Objects Task, and then execute...

Author: Graham Kent [MSFT] Date: 03/12/2010

Troubleshooting SQL Server Management Studio with SQL Profiler and Debugging Tools – Part 3

(An alternate title for this post could be “How to debug SSMS managed code”) In the first 2 posts of...

Author: Graham Kent [MSFT] Date: 02/03/2010

Changed behaviour of OPTION RECOMPILE syntax in SQL Server 2008 SP1 cumulative update #5

On Monday we released Cumulative update package 5 for SQL Server 2008 Service Pack 1, under...

Author: Graham Kent [MSFT] Date: 11/18/2009

Troubleshooting SQL Server Management Studio with SQL Profiler and Debugging Tools – Part 1

This is the first in a series of 3 posts which discuss troubleshooting SQL Server Management Studio...

Author: Graham Kent [MSFT] Date: 10/20/2009

SQL Server Database Mirroring Pre-requisites and guidelines

I noticed that we have posted a really good summary of the above points through the new fast publish...

Author: Graham Kent [MSFT] Date: 10/19/2009

SQL Server 2008 SDK directory does not contain the opends60.lib file required for the creation of extended stored procedures

If you are trying to create extended stored procedures in SQL Server 2008, you will probably have...

Author: Graham Kent [MSFT] Date: 09/29/2009

SQL Server DMV script for monitoring USERSTORE_TOKENPERM size by token type and number

Here’s a script I was using last week. I wrote this so that it could be used in a custom PSSDIAG /...

Author: Graham Kent [MSFT] Date: 09/28/2009

SQL Server DMV script for searching the plan cache by query text, plan handle or execution time

I guess everyone has their own set of DMV scripts to hand when working with SQL Server nowadays. I...

Author: Graham Kent [MSFT] Date: 09/24/2009

Realistic troubleshooting example of extended events (XEvent) usage in SQL Server 2008 – Part 1

Here’s an example of how to collect and consume extended events in SQL Server 2008. It’s something...

Author: Graham Kent [MSFT] Date: 09/23/2009

Troubleshooting SQL Server performance problems associated with low memory conditions – should I use sys.dm_os_ring_buffers

I recently received a question through this blog about the use of the sys.dm_os_ring_buffers DMV...

Author: Graham Kent [MSFT] Date: 09/10/2009

Fixed - incorrect CPU time reported by sys.dm_exec_query_stats for parallel plans

I was discussing with Elisabeth back in this blog post about the above problem, and made comments...

Author: Graham Kent [MSFT] Date: 09/03/2009

Troubleshooting SQL Server deadlocks and performance when running SharePoint

I’ve worked on a lot of cases this year involving SharePoint. Here are some example problems I...

Author: Graham Kent [MSFT] Date: 06/15/2009

Download location for SQLDIAG Perfstats DMV scripts

I refer to this many times in my other posts, so here’s a direct link to the download location of...

Author: Graham Kent [MSFT] Date: 06/11/2009

SQL Server 2005 Error: 701, Severity: 17, State: 193

Here’s another interesting example which we worked recently in the Stockholm office, which relates...

Author: Graham Kent [MSFT] Date: 06/02/2009

SQL Server Error: 7320 Cannot execute the query "xxx" against OLE DB provider "DB2OLEDB" for linked server "xxx"

Here's a little something that me and my colleagues were looking at this week. Our customer was...

Author: Graham Kent [MSFT] Date: 05/15/2009

New SQL Server 2008 DMV which I noticed this week - sys.dm_os_sys_memory

In the continuing series of "things I notice in SQL Server which I didn't know were there", I...

Author: Graham Kent [MSFT] Date: 04/24/2009

Unable to use forced parameterization when deploying plan guides in SQL Server 2005

I was working a case last week where I wanted to instate some fairly simple plan guides for a query...

Author: Graham Kent [MSFT] Date: 03/30/2009

How to Customise SQLDIAG in SQL Server 2008 to collect DBCC MEMORYSTATUS

Although Books Online makes some mention of SQLDIAG customizations, it doesn’t any explicit...

Author: Graham Kent [MSFT] Date: 03/27/2009

TechDays Sweden: post presentation questions and follow ups

Following my presentation here in Västerås yesterday there were a few people waiting to speak to me...

Author: Graham Kent [MSFT] Date: 03/18/2009

Come and say Hi at TechDays Sweden tomorrow....

I'll be presenting (my usual mantra on using SQLDIAG to troubleshoot your own problems) at 16:15...

Author: Graham Kent [MSFT] Date: 03/16/2009

sys.dm_exec_query_stats DMV can report invalid information for parallel plans

Elisabeth Redei asked me to respond to a question earlier today following a comment on her blog post...

Author: Graham Kent [MSFT] Date: 03/10/2009

No SQL posts this week - skiing again!

I am fortunate enough to be contining the testing of my hypothesis that skiing in Sweden is better...

Author: Graham Kent [MSFT] Date: 02/18/2009

Kill with rollback estimation

It's always amazing when you find something new in something so common that you thought you knew so...

Author: Graham Kent [MSFT] Date: 02/13/2009

SQL Server Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 1

[alternative title: Memory Troubleshooting using DBCC MEMORYSTATUS] The following samples are taken...

Author: Graham Kent [MSFT] Date: 02/03/2009

Which sessionid has the most locks in a SQL Server instance

Quick post today. Was playing around with something on Friday night, thinking how to answer this...

Author: Graham Kent [MSFT] Date: 02/02/2009

Thoughts about building a SQL Server 2008 cluster in Hyper-V

Having built a SQL Server 2005 cluster on virtualized hardware, using Virtual Server, i thought it...

Author: Graham Kent [MSFT] Date: 01/22/2009

Problems executing maintenance plans in SQL Server 2008 - Resolved by SQL 2008 CU#3

In November I wrote here about problems executing maintenance plans due to Integration Services...

Author: Graham Kent [MSFT] Date: 01/20/2009

Error 29528. The setup has encountered an unexpected error while Setting Internal Properties

We've just published a change to KB925976 on how to work around the following setup error: Error...

Author: Graham Kent [MSFT] Date: 01/19/2009

Sample Application to test database mirroring failover

Here's the source for a tiny C# app I wrote to test database mirroring failover at the application...

Author: Graham Kent [MSFT] Date: 01/16/2009

Starting SQLDIAG or PSSDIAG automatically using SQL Alerts

This is something I was thinking about this week whilst chatting with a customer. I've done it...

Author: Graham Kent [MSFT] Date: 01/15/2009

Changes to management of 'TokenAndPermUserStore' in SQL 2005 SP3

SQL Server 2005 service pack 3 released today and you can download it from here:...

Author: Graham Kent [MSFT] Date: 12/16/2008

SQL Server Database Mirroring error 1443 - Connection Handshake Failed

Here's another error that I picked from the forums today, which I see a fair number of occurrences...

Author: Graham Kent [MSFT] Date: 12/11/2008

Database Mirroring Error 1418 Troubleshooter

I've been posting in the MSDN and TECHNET mirroring forums in the last few days and I've noticed a...

Author: Graham Kent [MSFT] Date: 12/08/2008

More blogs from the SQL Server Support team in Europe

I just noticed that my colleague João blogs as well. You can find his blog here:...

Author: Graham Kent [MSFT] Date: 12/02/2008

Problems executing maintenance plans in SQL Server 2008

In the RTM build of SQL Server 2008 , if you install the tools in any edition, you are able to...

Author: Graham Kent [MSFT] Date: 11/27/2008

Next>