<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>DotNetBob on SQL</title>
	<link>http://sql.dotnetbob.com</link>
	<description>My thoughts on SQL - the beast within</description>
	<lastBuildDate>Mon, 05 Apr 2010 15:29:17 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>TempDB Capacity Planning, Optimizing For Performance and Troubleshooting Insufficient Disk Space</title>
		<description><![CDATA[There are three must read articles  by Microsoft regarding the TempDB

Capacity Planning for tempdb
Optimizing tempdb Performance
Troubleshooting Insufficient Disk Space in tempdb

Be sure to check them out!

    

	]]></description>
		<link>http://sql.dotnetbob.com/?p=140</link>
			</item>
	<item>
		<title>Plan Caching in SQL Server 2008</title>
		<description><![CDATA[I had the pleasure of meeting Greg Low recently, a Microsoft Certified Master. Greg is an amazingly intelligent individual, with all kinds of SQL Server experience. Greg has updated the Plan Caching paper originally written for SQL 2005, and made it relevant for SQL 2008. You can find that paper located here. I encourage you [...]]]></description>
		<link>http://sql.dotnetbob.com/?p=138</link>
			</item>
	<item>
		<title>SQL Server Wait Types</title>
		<description><![CDATA[Been meaning to blog more, but yowsas, time flies by. Anyhoo, this link is great for determining the exact nature of a wait type, and what it means. I frequently refer to the Microsoft SQL Server Tuning Blue Print white paper, and sometimes, as you may know, there are a lot of wait types not [...]]]></description>
		<link>http://sql.dotnetbob.com/?p=136</link>
			</item>
	<item>
		<title>Working with tempdb in SQL Server 2005</title>
		<description><![CDATA[Wow, it&#8217;s been a while since I posted last, so let&#8217;s get right to it. Microsoft has an interesting read on this article concerning the TempDB.

http://technet.microsoft.com/en-us/library/cc966545.aspx
What caught my eye was the section concerning the number of files for TempDB. Although it isn&#8217;t a new concept to me, it is still intersting to get more feedback [...]]]></description>
		<link>http://sql.dotnetbob.com/?p=134</link>
			</item>
	<item>
		<title>Disk Partition Alignment Best Practices For SQL Server</title>
		<description><![CDATA[You know, Microsoft has been putting out a steady stream of pretty cool articles. This one, shows some quantifiable data as it relates to disk partitioning. (Thanks to my buddy Marc for pointing this one out to me!)
http://msdn.microsoft.com/en-us/library/dd758814.aspx
 
If you weren&#8217;t interested in Windows 2008 before, you should be now. The conclusion also has an interesting [...]]]></description>
		<link>http://sql.dotnetbob.com/?p=128</link>
			</item>
	<item>
		<title>Performance Analysis With Logs (PAL)</title>
		<description><![CDATA[Have you guys seen the new Performance Analysis with Logs (PAL) tool posted by Microsoft at codeplex for tuning any type of system using performance counters? It&#8217;s pretty amazing to say the least. Now, I&#8217;ve discovered some bugs recently with it, but aside from that, the output is very satisfying. Here&#8217;s a link, tell me [...]]]></description>
		<link>http://sql.dotnetbob.com/?p=122</link>
			</item>
	<item>
		<title>How to Read the Log With TSQL (fn_dblog)</title>
		<description><![CDATA[Hi again, 
This undocumented command in TSQL reads your log file and returns results. If you&#8217;ve ever used a log reader such as the one from APEX, or any other log reader for that matter, you will see the resemblence. Here&#8217;s the syntax on how to call this particular function:
 
SELECT *
FROM ::fn_dblog(NULL, NULL)

From what I can [...]]]></description>
		<link>http://sql.dotnetbob.com/?p=115</link>
			</item>
	<item>
		<title>Troubleshooting Performance Problems in SQL Server 2005</title>
		<description><![CDATA[Hi all, the following guide was taken from Microsoft&#8217;s best practices site. I&#8217;ve found out through the years that our product has been challenged by many of the performance problems listed in this guide, so it is definitely a good read!
You can find the Microsoft link here:
Here is the document for your reference as well: tshootperfprobs

 [...]]]></description>
		<link>http://sql.dotnetbob.com/?p=109</link>
			</item>
	<item>
		<title>How to Troubleshoot SQL Server CPU Bottlenecks</title>
		<description><![CDATA[Assuming you don&#8217;t have already have a fancy tool like Quest Software&#8217;s Performance Analyzer, or you aren&#8217;t using the Performance Dashboard offered by Microsoft, one way to quickly determine if you are CPU bound and what is actually utilizing your CPU utilization is to use a couple queries. I borrowed some information from the Microsoft [...]]]></description>
		<link>http://sql.dotnetbob.com/?p=96</link>
			</item>
	<item>
		<title>DMV Stats by Microsoft, a Hit or Miss?</title>
		<description><![CDATA[DMV Stats, hit or miss?]]></description>
		<link>http://sql.dotnetbob.com/?p=91</link>
			</item>
</channel>
</rss>
