Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

Checking i/o on SQL Server 2000

What is a good script to use to check current I/O on a SQL Server 2000
0
cheryl9063
Asked:
cheryl9063
1 Solution
 
Eugene ZCommented:
check
fn_virtualfilestats function
Returns I/O statistics for database files, including log files.

http://msdn.microsoft.com/en-us/library/aa258871(v=sql.80).aspx


SELECT * FROM ::fn_virtualfilestats(1, 1)

more

SQL Server Database File I/O Report
http://www.databasejournal.com/features/mssql/article.php/3796551/SQL-Server-Database-File-IO-Report.htm
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now