One full day log disk performance

Hi,
I have a NT4 SP6, MSSQL7 SP4 server.
I want to check the max and the avg of disk read/sec during one day.
I am using with the Performance Monitor but when :
- I export in a csv file from the chart monitor, I only obtain a 2 or
3 minutes result set
- I export a csv file from the log monitor, I have no results in the
csv file. Even after collecting datas during one hour.
Does anyone know a procedure ?
TIA
RJPIn System Monitor, you could create a new 'Counter log' and specify a .CSV
output file, and then run that log.
In System Monitor, on the left hand pane, right click on 'Conter Logs'
(under the Performance Logs and Alerts node) , and select 'New Log Settings'
to create one.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"rjp" <rjp.l@.laposte.net> wrote in message
news:9b7a7215.0310290723.7095d599@.posting.google.com...
Hi,
I have a NT4 SP6, MSSQL7 SP4 server.
I want to check the max and the avg of disk read/sec during one day.
I am using with the Performance Monitor but when :
- I export in a csv file from the chart monitor, I only obtain a 2 or
3 minutes result set
- I export a csv file from the log monitor, I have no results in the
csv file. Even after collecting datas during one hour.
Does anyone know a procedure ?
TIA
RJP|||RJP
Here is a link to a very good article on using Perfmon
with SQL Server.
http://www.sql-server-
performance.com/performance_monitor_tips.asp
Hope this helps
John|||In article <9b7a7215.0310290723.7095d599@.posting.google.com>,
rjp.l@.laposte.net said...
> Hi,
> I have a NT4 SP6, MSSQL7 SP4 server.
> I want to check the max and the avg of disk read/sec during one day.
> I am using with the Performance Monitor but when :
> - I export in a csv file from the chart monitor, I only obtain a 2 or
> 3 minutes result set
> - I export a csv file from the log monitor, I have no results in the
> csv file. Even after collecting datas during one hour.
> Does anyone know a procedure ?
Exporting will just export what is on the graph at that time. You have to
log as you go.