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.

OMWWIZE and Copy Database Wizard

Please help.
I am trying to move one of our production databases (MSSQL7) to a larger,
more powerful box running MSSQL2000. Each time I run the copy database
wizard, I get a failure with the error message reading "Failed to create the
share OMWWIZE."
What is this share? Why do I need it? Why would this step fail? Where should
it be? How do I fix this?
I say again, please help.
--
Kerry CarrollHave a look here
http://support.microsoft.com/default.aspx?scid=kb;en-us;q274463
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Good Try" <test@.not.com> wrote in message
news:eL59ym$vDHA.1576@.TK2MSFTNGP11.phx.gbl...
> Please help.
> I am trying to move one of our production databases (MSSQL7) to a larger,
> more powerful box running MSSQL2000. Each time I run the copy database
> wizard, I get a failure with the error message reading "Failed to create
the
> share OMWWIZE."
> What is this share? Why do I need it? Why would this step fail? Where
should
> it be? How do I fix this?
> I say again, please help.
> --
> Kerry Carroll
>