T SQL Date format convert function

Here is the script which can give you SQL Server file IO Statistics for each file and file group. Using this data you can find out sql server read/write performance of your disks. DECLARE @TotalIO BIGINT, @TotalBytes BIGINT, @TotalStall BIGINT …

Measure the I/O load on database files and file group using fn_virtualfilestats Read more »