Sign In
Craig Freedman's SQL Server Blog
A discussion of query processing, query execution, and query plans in SQL Server.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Aggregation
Common Table Expressions
Conversions
Hints
I/O
Isolation Levels
Joins
Parallelism
Partitioned Tables
Pivot and Unpivot
Ranking Functions
Rollup and Cube
Scans and Seeks
Subqueries
Top
Updates
Archive
Archives
January 2010
(1)
July 2009
(1)
June 2009
(1)
April 2009
(1)
March 2009
(2)
February 2009
(1)
October 2008
(2)
September 2008
(1)
August 2008
(2)
July 2008
(1)
June 2008
(2)
May 2008
(2)
April 2008
(1)
March 2008
(2)
February 2008
(1)
January 2008
(2)
November 2007
(1)
October 2007
(3)
September 2007
(3)
August 2007
(3)
July 2007
(4)
June 2007
(2)
May 2007
(5)
April 2007
(2)
December 2006
(1)
November 2006
(4)
October 2006
(4)
September 2006
(4)
August 2006
(5)
July 2006
(4)
June 2006
(6)
October, 2008
MSDN Blogs
>
Craig Freedman's SQL Server Blog
>
October, 2008
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Craig Freedman's SQL Server Blog
What is the difference between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats?
Posted
over 4 years ago
by
Craig Freedman
6
Comments
SQL Server includes two DMVs - sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats - that are extremely useful for monitoring which indexes are used as well as how and when they are used. Both DMVs report similar statistics on information...
Craig Freedman's SQL Server Blog
Random Prefetching
Posted
over 4 years ago
by
Craig Freedman
1
Comments
In my last post , I explained the importance of asynchronous I/O and described how SQL Server uses sequential read ahead to boost the performance of scans. In this post, I'll discuss how SQL Server uses random prefetching. Let's begin with a simple example...
Page 1 of 1 (2 items)