Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Any free tool to monitor SQL I/O, network/sec

Author  Topic 

chih
Posting Yak Master

154 Posts

Posted - 2008-06-23 : 01:34:35
Hi Everyone,

I am looking for a tool which can store SQL I/O and network/sec data. According to this historical data, I can decide whether upgrade my hardware.

Is there any free tool?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-06-23 : 01:49:36
Check Perfomance Monitor on Windows . Also , 2005 has a significant amount of Dynamic Views which may be of interest

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-23 : 09:09:13
SQL 2005 comes with Standard Reports as well.
Go to Top of Page

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-24 : 17:24:16
You can use Windows Perfmon and set the counters. Foglight from Quest also give the results.

Manoj
MCP, MCTS
Go to Top of Page
   

- Advertisement -