Jay's Blog

[coding, debugging, and troubleshooting with Microsoft Technologies]

Browse by Tags

Tagged Content List
  • Blog Post: Do waiting or suspended tasks tie up a worker thread?

    I had a discussion the other day with someone about worker threads and their relation to tasks. I thought a quick demo might be worthwhile. When we have tasks that are waiting on a resource (whether it be a timer or a resource like a lock) we are tying up a worker thread. A worker thread is assigned...
  • Blog Post: Finding Missing Dependencies

      While working with a customer on a SQL port, I came across a system view that was new with SQL Server 2008.  Have you ever needed to check your database code (stored procedures) to see if it references any missing objects?  As of SQL Server 2008 this is easy thanks to: sys . sql_expression_dependencies...
  • Blog Post: Need to find the Database Version? Last Log Backup? Last DBCC execution? Ummm….

    Backup software and Maintenance plans usually take care of tracking backup schedules and maintenance schedules for us… but how else do we find this information inside SQL Server?  The following query will get the last backup date and time from MSDB: select database_name , max ( backup_finish_date...
  • Blog Post: Default Trace and System Health

    So it’s been a little while since my last posting – actually a long while.  Since my last post some 8 months ago I’ve changed customers in my role as a PFE here at Microsoft and that has had me quite busy. I have a couple of posts I wanted to write to answer some questions I get from customers in...
  • Blog Post: Searching through the SQL Server Errorlogs

    Sorry – It’s been a while since my last post.  The past few months have been very busy for me.  The other day, I had a brief discussion with a colleague on ways to search through all of the error logs in SQL Server.  Obviously there are a few ways to do this – through PowerShell, simple...
  • Blog Post: How do I track this in my Stored Procedure? (Using a custom trace event)

      It’s been a while since I’ve posted an entry as I’ve been busy with moving to a different position that has me working dedicated to one customer here in my PFE role at MS.  I’ve been keeping up with the topics I want to post about, so there are plenty more posts to come. Today I want to cover...
  • Blog Post: Creating a custom performance monitor counter for SQL Server

    If you have ever needed to monitor a value in SQL Server, or follow the trend of anything that can be expressed in a numerical value – then creating a custom performance monitor counter could be just what you need…. For this example, I am going to use a query that calculates the size...
  • Blog Post: How do I set a breakpoint in a CLR Stored Procedure already deployed and running on a live SQL Server and debug is using Visual Studio?

    For information on setup and debugging a CLR stored procedure in a direct-debug scenario by “stepping-through” the code from within Visual Studio, OR by using a test TSQL script from with Visual Studio, refer to the following MSDN article: http://msdn.microsoft.com/en-us/library/ms165051...
  • Blog Post: How can I create a dump of SQL Server?

    You can create a memory dump of the SQL Server process space in several ways. There are many external tools that can help you accomplish this such as userdump.exe, debugdiag.exe, and ADPlus.exe. In this post, I’ll cover 3 common ways to accomplish this for SQL Server: The most common way (sqldumper...
  • Blog Post: What do I need to know to be good at debugging?

    From time to time I will get this question from people learning to debug application code. Debugging is an unusual skill and is a combination of art and science. However, IMHO the following 3 items or characteristics are super important for being successful with your debugging: You don’t...
Page 1 of 1 (10 items)