Xác định I/O wait cho mỗi database trong SQL Server

SET TRAN ISOLATION LEVEL READ UNCOMMITTED SELECT DB_NAME(database_id) AS [DatabaseName] , SUM(CAST(io_stall / 1000.0 AS DECIMAL(20,2))) AS ...

Công nghệ Server Message Block trong SQL Server

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 Disk Subsystem Benchmark Tool

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...

Diagnose database at database level

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...