Doctor, this SQL Server appears to be sick….

I thought the PASS Summit was a great success this year. I always enjoy speaking at the PASS Summit (this year I spoke on Wait Types. I’m working now on starting to populate the Wait Type Repository) but I also really enjoy working at the SQL Server Clinic. This year CSS combined its efforts with…

5

Unable to run SQL CLR procedure with System.Security.SecurityException

Recently, we have troubleshoot a customer issue related to SQL CLR.  The problem is that the assembly is configured to use external_access but he kept getting an exception similar to this (this is a sample call stack): Msg 6522, Level 16, State 1, Procedure sp_test, Line 0A .NET Framework error occurred during execution of user-defined…

0

How It Works: Controlling SQL Server memory dumps

I just completed a lengthy bit of research and thought I would share it with everyone.   There are several trace flags and registry keys outlined in this post.    !!! As always USE WITH APPROPRIATE CAUTION !!!   From: Robert Dorr Sent: Tuesday, November 17, 2009 3:23 PM Subject: RE: SQL Server 2008 Trace Flag  …

2

How It Works: How many databases can be backed up simultaneously?

Previously I have posted details on backup/restore designs and how to tell what backup/restore is doing. http://blogs.msdn.com/psssql/archive/2009/03/03/how-it-works-sql-server-vdi-vss-backup-resources.aspx http://blogs.msdn.com/psssql/archive/2008/01/28/how-it-works-sql-server-backup-buffer-exchange-a-vdi-focus.aspx http://blogs.msdn.com/psssql/archive/2008/01/23/how-it-works-what-is-restore-backup-doing.aspx This post attempts to bring the concepts together to answer the question: "How many databases can be backed up simultaneously?"   The figure should look familiar as a combination of the previous posts.    The reason I…

0

The SQL Server Wait Type Repository…

12/10/2009: Significant updates to the blog. Check back in 2010 for more updates to the wait type table   As part of my talk at the 2009 US PASS Summit here in Seattle called Inside SQL Server Wait Types, I’m creating this blog post as a reference point that can be used to find out…

14