Resource Monitor and Performance Monitor - Microsoft SQL Server 2012 Performance Tuning - page 78

5. To check the disk I/O activity on the server, click on the tab captioned Disk. Because
we have already selected sqlservr.exe from the list of available processes, we will see
disk I/O activity that is caused by only the SQL Server service. Let's run a query to cause
some I/O activity to occur. Connect SSMS to SQL Server, and in a new query window,
type and execute following query against the AdventureWorks2012 database:
USE AdventureWorks2012
GO

SELECT
SalesOrderID
,SalesOrderDetailID
,CarrierTrackingNumber
,OrderQty
,ProductID
,SpecialOfferID
,UnitPrice
,UnitPriceDiscount
,LineTotal
,rowguid
,ModifiedDate
FROM Sales.SalesOrderDetail WITH (NOLOCK)

GO

6. After running the preceding query, immediately switch to Resource Monitor, and

you will be able to monitor disk I/O activity performed on AdventureWorkk2012
database files, along with few others, as shown in the following screenshot: