SET TRAN ISOLATION LEVEL READ UNCOMMITTED SELECT DB_NAME(database_id) AS [DatabaseName] , SUM(CAST(io_stall / 1000.0 AS DECIMAL(20,2))) AS ...
Blog đang chỉnh sửa
SET TRAN ISOLATION LEVEL READ UNCOMMITTED SELECT DB_NAME(database_id) AS [DatabaseName] , SUM(CAST(io_stall / 1000.0 AS DECIMAL(20,2))) AS ...
I love to research SQL Server Internal and SQL Server Architect. Today I found out the knowledge about Server Message Block, that is useful....
SQLIO is a tool provided by Microsoft which can also be used to determine the I/O capacity of a given configuration. For more information: h...
Here is the script give us I/O statistics in each data/log file SELECT DB_NAME(fs.database_id) AS [Database Name], mf.physical_name, io_st...