Changes that 15MB/Sec to 25 MB/Sec

For the last 6 months our database disk transfer rate has been at 15MB/Sec
during normal business hours.
Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one day
and has stayed at that rate since. The number of transactions/sec is the
same from the change 15MB/Sec to 25MB/Sec.
What could make this rate change so quickly?
Changes in index planes, larger transactions, and etc.?
Please help me with this issue.
Thanks,
Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>
|||Then there is always system patches, bios updates, and driver version
changes.
Anthony Thomas

"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eaju62IOFHA.164@.TK2MSFTNGP12.phx.gbl...
Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>

Changes that 15MB/Sec to 25 MB/Sec

For the last 6 months our database disk transfer rate has been at 15MB/Sec
during normal business hours.
Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one day
and has stayed at that rate since. The number of transactions/sec is the
same from the change 15MB/Sec to 25MB/Sec.
What could make this rate change so quickly?
Changes in index planes, larger transactions, and etc.?
Please help me with this issue.
Thanks,Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>|||Then there is always system patches, bios updates, and driver version
changes.
Anthony Thomas
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eaju62IOFHA.164@.TK2MSFTNGP12.phx.gbl...
Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>

Changes that 15MB/Sec to 25 MB/Sec

For the last 6 months our database disk transfer rate has been at 15MB/Sec
during normal business hours.
Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one day
and has stayed at that rate since. The number of transactions/sec is the
same from the change 15MB/Sec to 25MB/Sec.
What could make this rate change so quickly?
Changes in index planes, larger transactions, and etc.?
Please help me with this issue.
Thanks,Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>|||Then there is always system patches, bios updates, and driver version
changes.
Anthony Thomas
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:eaju62IOFHA.164@.TK2MSFTNGP12.phx.gbl...
Hi
I would not expect this to happen on it's own. Have you checked the event
log?
I would expect the something like defragging, changing the disc layout,
moving the pagefile (or some other application that caused excess head
movement) may cause this sort of thing.
John
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DBFE6B6D-BA72-4081-801F-8DB6A9D7D746@.microsoft.com...
> For the last 6 months our database disk transfer rate has been at 15MB/Sec
> during normal business hours.
> Last we the disk transfer rate changed from 15MB/Sec to 25MB/Sec in one
> day
> and has stayed at that rate since. The number of transactions/sec is the
> same from the change 15MB/Sec to 25MB/Sec.
> What could make this rate change so quickly?
> Changes in index planes, larger transactions, and etc.?
> Please help me with this issue.
> Thanks,
>
>
>

Changed sa password, db maint plan not working

Our in-house developer changed the "sa" password on the Sql 2000 server and now the database maintenance plan that I created for backups to disk isn't working. The day it stopped I received the following errors in the log:

"2003-02-13 09:20:41.37 spid58 Error: 15457, Severity: 0, State: 1

2003-02-13 09:20:41.37 spid58 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..

2003-02-13 09:20:41.48 spid58 Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.

2003-02-13 15:54:25.59 spid53 Error: 15457, Severity: 0, State: 1

2003-02-13 15:54:25.59 spid53 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..:"I don't think that changing the sa password has got anything to do with the DBMaintenance plan unless you are using DTS for running the DB Backup etc etc.