Tools for checking disk I/O

Question

I have a Dell 1850 with dual 3.2 proc and 2-300GB RAID 0 drives running Server 2003.   We have a 43 GB database that we zip up weekly and it takes 2 hours.   I am just trying to speed up the process if possible and verify if/where the bottleneck would be.    The database is on this machine so network is not the bottleneck.Is there a Dell tool or recommended tool that would show detailed disk I/O , etc ....   Thanks

sdcarroll · Answer

Performance Monitor: c:\windows\system32\perfmon.exe works like a champ.

Most databases have a "dump" command that allows you to export the entire configuration (tables, data, etc) rather quickly to a file. You can then backup (or zip) that file while the database is back online.

If you're running mySQL, see this page for backup commands.

Syntax: mysqldump --tab=/path/to/some/dir --opt db_name

If you're running MS-SQL2000, see this page.

Syntax: BACKUP DATABASE db_name TO DISK =

'd:\path\to\some\dir\file_name.bak'

PowerEdge OS Forum

Was this post helpful?