Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » sql server 2008   (RSS)
Wednesday, November 18, 2009 9:32 AM

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
Posted by grahamk | 0 Comments
Tuesday, October 20, 2009 12:02 PM

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
Posted by grahamk | 0 Comments
Monday, October 19, 2009 11:56 AM

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
Posted by grahamk | 0 Comments
Tuesday, September 29, 2009 1:35 PM

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
Posted by grahamk | 0 Comments
Wednesday, September 23, 2009 9:08 AM

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
Posted by grahamk | 0 Comments
Thursday, September 03, 2009 10:15 AM

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 that there were no plans currently to backport this to SQL 2005 or 2008. This changed following feedback both from customers and from us within CSS, and
Posted by grahamk | 0 Comments
Filed under: ,
Friday, April 24, 2009 2:00 PM

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 noticed the very simple but very useful sys.dm_os_sys_memory earlier this week. Why do I like this? Well obviously you can extract the memory information exposed
Posted by grahamk | 1 Comments
Filed under: ,
Friday, March 27, 2009 4:08 PM

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 examples, so here’s one for you. I documented previously here about how to customize your XML configuration file to connect to different machines, and collect
Posted by grahamk | 1 Comments
Tuesday, March 10, 2009 11:14 AM

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 about performance monitoring using DMVs . The question asked was "when will sys.dm_exec_query_stats be fixed to report worker time (cpu) for queries with
Posted by grahamk | 1 Comments
Thursday, January 22, 2009 12:38 PM

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 was time to do this on hyper-v with SQL 2008. Here’s some thoughts to get you thinking about trying this. The one single most important point here, is how
Posted by grahamk | 1 Comments
Attachment(s): hyperv_sql2008_cluster.pdf
Tuesday, January 20, 2009 9:22 AM

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 edition compatibility issues. Last night we released cumulative update #3 for SQL Server 2008 RTM, and it contains a fix / design change for this problem.
Posted by grahamk | 0 Comments
Friday, January 16, 2009 4:06 PM

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 level, including a sample database mirroring connection string. It assumes that you have already set up a mirroring partnership. It doesn't matter whether
Posted by grahamk | 0 Comments
Thursday, January 15, 2009 12:55 PM

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 before on occasions, but never really documented it. Consider the fact that you have a problem which occurs extremely intermittently, let's say on average every
Posted by grahamk | 0 Comments
Tuesday, December 16, 2008 12:47 PM

Changes to management of 'TokenAndPermUserStore' in SQL 2005 SP3

SQL Server 2005 service pack 3 released today and you can download it from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en One of the most interesting and useful bits which I am interested
Posted by grahamk | 0 Comments
 
Page view tracker