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 KB975977. Contained in this was a very interesting fix to a long running issue with regards to the option recompile syntax and its changed behaviour in SQL Server 2008. This fix has its own KB article at KB976603. In…

0

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

This is the second in a series of 3 posts which discuss troubleshooting SQL Server Management Studio when it encounters errors or unexpected behaviour. In this post we collect a memory dump of SSMS based upon specific .NET exception codes, for subsequent analysis. As a reminder, here are the symptoms of the problem we are…

0

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 when it encounters errors or unexpected behaviour. In this post we look at using profiler, in the 2nd and 3rd we debug SSMS using public Microsoft debugging tools. Here are the symptoms of the problem we are looking at:…

0

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 system for KBs. (Note the disclaimer at the bottom which is not normally shown on full KBs). There are some really good points here to consider about setting up and configuring a mirroring environment. Things to…

0

Using Xquery to query Extended Events asynchronous file target results

This is the follow up (part 2) to the following post: http://blogs.msdn.com/grahamk/archive/2009/09/23/realistic-troubleshooting-example-of-extended-events-xevent-usage-in-sql-server-2008-part-1.aspx In the original post we configured an extended event session and issued a very simple query to review the results as XML. Here are some more intelligent XQuery examples. I’m documenting these purely because I hate XQuery so much, and it takes so…

1

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 read the BOL article here: Creating Extended Stored Procedures Hopefully you will have noticed that this feature is deprecated, and so firstly you’ll only be using this functionality for legacy requirements. That said you may have noticed that…

0

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 that we in CSS are starting to use more and more frequently with the uptake of SQL 2008, and I believe it’s something that everyone who troubleshoots SQL can gain benefit from. Here’s a relatively simple example which…

0

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 with regard to troubleshooting performance problems and low memory conditions. Here are some excerpts – edits from my reply which might provide some ideas for you. Here’s an interesting article you might like to read about monitoring memory usage with…

0