<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SQL Server 2005 -  RDTSC Truths and Myths Discussed</title><link>http://blogs.msdn.com/psssql/archive/2007/08/19/sql-server-2005-rdtsc-truths-and-myths-discussed.aspx</link><description>I posted some updates to my blog entry about the RDTSC and drift warnings in May. See the following link http://blogs.msdn.com/psssql/archive/2006/11/27/sql-server-2005-sp2-will-introduce-new-messages-to-the-error-log-related-to-timing-activities.aspx</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>delta  &amp;raquo; Blog Archive   &amp;raquo; SQL Server 2005 - RDTSC Truths and Myths Discussed</title><link>http://blogs.msdn.com/psssql/archive/2007/08/19/sql-server-2005-rdtsc-truths-and-myths-discussed.aspx#6170472</link><pubDate>Tue, 13 Nov 2007 14:54:02 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:6170472</guid><dc:creator>delta  » Blog Archive   » SQL Server 2005 - RDTSC Truths and Myths Discussed</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://delta.wpbloggers.com/delta/?p=144"&gt;http://delta.wpbloggers.com/delta/?p=144&lt;/a&gt;&lt;/p&gt;
</description></item><item><title>Precision Performance for Microsoft SQL Server using RML Utilities 9.0</title><link>http://blogs.msdn.com/psssql/archive/2007/08/19/sql-server-2005-rdtsc-truths-and-myths-discussed.aspx#7382438</link><pubDate>Sat, 02 Feb 2008 07:47:13 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:7382438</guid><dc:creator>Technical Notes</dc:creator><description>&lt;p&gt;Author: Robert Dorr, Keith Elmore, Lindsey Allen Introduction Have you ever asked the question: &amp;amp;#8220;If&lt;/p&gt;
</description></item><item><title>re: SQL Server 2005 -  RDTSC Truths and Myths Discussed</title><link>http://blogs.msdn.com/psssql/archive/2007/08/19/sql-server-2005-rdtsc-truths-and-myths-discussed.aspx#8333756</link><pubDate>Mon, 24 Mar 2008 19:04:30 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8333756</guid><dc:creator>RobertDavis</dc:creator><description>&lt;P&gt;We have a situation where we are being told by our storage team that the I\O stall warnings are due to CPU drift. However, we are not seeing any warnings in the SQL log related to CPU drift itself.&lt;/P&gt;
&lt;P&gt;Is it feasible that CPU drift could cause stall warnings to be falsely reported but the CPU drift itself would not be reported?&lt;/P&gt;
&lt;P&gt;Thanks in advance for any insight and for this great reference article.&lt;/P&gt;
&lt;P&gt;Regards,&lt;/P&gt;
&lt;P&gt;Robert Davis.&lt;/P&gt;
&lt;P&gt;[RDORR] Robert, the CPU drift can cause the stalled warnings but I have never seen the warning without the SQL Server error log warning.&amp;nbsp;&amp;nbsp; To cause the I/O warning the drift would have to be over 15 seconds and I simply have yet to see a case like this.&amp;nbsp;&amp;nbsp; If you are getting stall warnings start looking at PerfMon avg disk sec/transfer during these windows.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description></item><item><title>I/O requests taking longer than 15 seconds to complete on file</title><link>http://blogs.msdn.com/psssql/archive/2007/08/19/sql-server-2005-rdtsc-truths-and-myths-discussed.aspx#8622285</link><pubDate>Thu, 19 Jun 2008 19:33:55 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8622285</guid><dc:creator>Troubleshooting Microsoft SQL Server</dc:creator><description>&lt;p&gt;What does the “I/O request” error below represent? 2008-04-21 13:26:42.480 spid364 Microsoft SQL Server&lt;/p&gt;
</description></item><item><title>How It Works: SQL Server No Longer Uses RDTSC For Timings in SQL 2008 and SQL 2005 Service Pack 3 (SP3)</title><link>http://blogs.msdn.com/psssql/archive/2007/08/19/sql-server-2005-rdtsc-truths-and-myths-discussed.aspx#9229175</link><pubDate>Wed, 17 Dec 2008 02:47:11 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9229175</guid><dc:creator>CSS SQL Server Engineers</dc:creator><description>&lt;p&gt;Many of you have encountered the RDTSC timing variances that I outlined in an earlier blog post:&amp;amp;#160;&amp;amp;#160;&lt;/p&gt;
</description></item><item><title>More information on SQL Server 2005 SP3 + Cumulative Updates</title><link>http://blogs.msdn.com/psssql/archive/2007/08/19/sql-server-2005-rdtsc-truths-and-myths-discussed.aspx#9231343</link><pubDate>Wed, 17 Dec 2008 21:11:51 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9231343</guid><dc:creator>Aaron Bertrand</dc:creator><description>&lt;p&gt;I recently posted about the availability of SQL Server 2005 SP3. I have a bit more information about&lt;/p&gt;
</description></item><item><title>How It Works: SQL Server Timings and Timer Output  (GetTickCount, timeGetTime, QueryPerformanceCounter, RDTSC, …)</title><link>http://blogs.msdn.com/psssql/archive/2007/08/19/sql-server-2005-rdtsc-truths-and-myths-discussed.aspx#9655676</link><pubDate>Fri, 29 May 2009 20:25:46 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9655676</guid><dc:creator>CSS SQL Server Engineers</dc:creator><description>&lt;p&gt;A series of questions related to start time, duration, end time, T-SQL waitfor delay command and others&lt;/p&gt;
</description></item></channel></rss>