Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » sql server 2005   (RSS)
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, June 02, 2009 1:20 PM

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

Here’s another interesting example which we worked recently in the Stockholm office, which relates also back to one of my previous entries. We had a customer whose error log was filled with a variety of critical errors such as these: Error: 701, Severity:
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
Monday, January 19, 2009 9:55 AM

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 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation. We've also just published
Posted by grahamk | 0 Comments
Filed under: , ,
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
 
Page view tracker