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.

Old transaction log is reported as missing during recovery

I've done this at least 50 times without issue on various databases, but this
one just doesn't want to play nice.
So I have a SQLServer2K database setup. I've got a home-grown disaster
recovery process in place, so that transactions are taken from one server and
migrated to a backup server every hour. Once it's up and running, the
process is pretty flawless. However, getting it setup can be tricky.
1) Set the recovery model to "Full".
2) Backup your transaction logs
3) Do a full backup
4) Copy the backup to the backup server
5) Restore in to a read only database
Transaction logs can now be backed up on the source database, copied over
and applied to the backup server.
This isn't working this time though. No matter what I've tried, I still get
a message during the restore of the transaction logs such as the following:
"Executed as user: dbo. The log in this backup set begins at LSN
83111000001460600001, which is too late to apply to the database. An earlier
log backup that includes LSN 83075000002839600001 can be restored. [SQLSTATE
42000] (Error 4305) RESTORE LOG is terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed."
Given the large gap between the two LSN #'s, I'm assuming that the database
thinks there is a very old transaction I'm missing. However, that is sheer
guesswork on my part.
The source box has been cycled, I've tried turning the recovery back and
forth between Full and Simple. This error is from my latest attempt, when I
swear I've done everything by the book.
Any suggestions of what might be causing this or where I should go from here?
Fred...
SQL lost a log somehow, I often had problems similar to this w/ home grown
log shipping.
Solution mostly relied upon: re-execute full backup, then restore & fire up
log shipping again. Full backup restores should be done nightly if
affordable...
Also - transactional replication ultimately proved the best solution for us,
transactions replicated within seconds, if we ever had to failover to backup,
I am much more confident minimal data would be lost as opposed to hourly log
restores...
Regards,
ChrisB
MCDBA OCP
www.MyDatabaseAdmin.com
"fkutz" wrote:

> I've done this at least 50 times without issue on various databases, but this
> one just doesn't want to play nice.
> So I have a SQLServer2K database setup. I've got a home-grown disaster
> recovery process in place, so that transactions are taken from one server and
> migrated to a backup server every hour. Once it's up and running, the
> process is pretty flawless. However, getting it setup can be tricky.
> 1) Set the recovery model to "Full".
> 2) Backup your transaction logs
> 3) Do a full backup
> 4) Copy the backup to the backup server
> 5) Restore in to a read only database
> Transaction logs can now be backed up on the source database, copied over
> and applied to the backup server.
> This isn't working this time though. No matter what I've tried, I still get
> a message during the restore of the transaction logs such as the following:
> "Executed as user: dbo. The log in this backup set begins at LSN
> 83111000001460600001, which is too late to apply to the database. An earlier
> log backup that includes LSN 83075000002839600001 can be restored. [SQLSTATE
> 42000] (Error 4305) RESTORE LOG is terminating abnormally. [SQLSTATE 42000]
> (Error 3013). The step failed."
> Given the large gap between the two LSN #'s, I'm assuming that the database
> thinks there is a very old transaction I'm missing. However, that is sheer
> guesswork on my part.
> The source box has been cycled, I've tried turning the recovery back and
> forth between Full and Simple. This error is from my latest attempt, when I
> swear I've done everything by the book.
> Any suggestions of what might be causing this or where I should go from here?
> Fred...