[coding, debugging, and troubleshooting with Microsoft Technologies]
Translate This Page
Translate this page
Browse by Tags
Tagged Content List
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...
29 Jul 2012
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...
22 Jul 2012
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...
8 Jul 2012
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...
28 Jun 2012
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...
10 Oct 2011
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...
10 Sep 2010
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...
18 Feb 2010
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...
7 Feb 2010
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...
5 Feb 2010
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...
3 Feb 2010
Page 1 of 1 (10 items)
© 2013 Microsoft Corporation.
Privacy & Cookies