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,
>
>
>

changeing the table name while using transfer sql server object

Hi,
I am wondering using transfer sql server objects task in a sub-package and feeding tableslist property from the parent package. which works fine.
problem :

I want to be able to change the name in the fly so if I have
TableA I want to copy it for the destination as TableB
is there any work arround this just using transfer sql server objects task.
Thanks

A link to a similar thread of yours on this topic: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1094010&SiteID=1|||Thanks Phil for checking.
Although it is similar question but it is pointing to a different functionality of Transfer sql server object task.
I want to be able to copy a table between servers the tricky part is that I don not have the table in the destination and task creates the table in the target server.

so it captures a snapshot of the schema of the source table and applies it to the remote server and the then standard data copy between to tables.

problem: I want to be able to have a different table name for the target database. so I am wondering if it is possible with scripting to do so ( that is fi the task it self has got such a property ) or the task only will create the table with the same name (as the source).

Thanks
|||Just asking and am not trying to take away from your issue, but aren't there better tools for performing schema management rather than using SSIS? I'm not a DBA, so I don't really know the answer to that question, but it seems here that you're stretching the limits of what SSIS was designed to do (even if it *can* do it).

Are you going to run this one time, or many times?|||many times and con-currently
|||Not supported in the Transfer Objects task. However, you could use an Execute SQL after the table is copied to call sp_rename.|||yes, that's how I've done it , but I was wondering if there was a a nyway to stretch the Transfer sql server object task capability.
Cheers

change the server**

Hi
I've a server which includes sql server2000
with somje databases,and now I want to transfer
all database into a new server(which just has a SQL server 2000 and SP3
with no databases) ,is it neccessary
to restore the master or model or any other default
databases in new server?
I want to do following steps:
Is there any more activities needed to transfer all info.?
1 - backup all DBs(except default dbs like master,..).
2 - restore DBs in new server.
3 - define logins and link them to users.
4 - define jobs or some maintanace plan.
Is there any better way to do this?
any help would be greatly thankful.Hi,
Your steps are 75% good, but if you restore the Master, MSD database then
you donot want create the logins, Jobs, Maintenance plans, operators ,
alerts etc..
Master holds the Logins, configuration parameters
MSDB Holds all the jobs, Maintenance plans, operators, alerts etc..
Go thru the below links to transfer all the databases including system
databases/
http://www.support.microsoft.com/?id=224071
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
Is it neccessary to restore the master or model or any other default
databases in new server?
Yes, this will reduce quite a lot of manual stuffs explained above.
Thanks
Hari
MCDBA
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsawkt1l8hqligo@.msnews.microsoft.com...
> Hi
> I've a server which includes sql server2000
> with somje databases,and now I want to transfer
> all database into a new server(which just has a SQL server 2000 and SP3
> with no databases) ,is it neccessary
> to restore the master or model or any other default
> databases in new server?
> I want to do following steps:
> Is there any more activities needed to transfer all info.?
> 1 - backup all DBs(except default dbs like master,..).
> 2 - restore DBs in new server.
> 3 - define logins and link them to users.
> 4 - define jobs or some maintanace plan.
> Is there any better way to do this?
> any help would be greatly thankful.|||thanks,
and the last question :
Is the order of restoring dbs (first system db,then the other)or (first
the other ,then system db) important?
On Sat, 10 Jul 2004 09:18:43 +0530, Hari Prasad
<hari_prasad_k@.hotmail.com> wrote:
> Hi,
> Your steps are 75% good, but if you restore the Master, MSD database then
> you donot want create the logins, Jobs, Maintenance plans, operators ,
> alerts etc..
> Master holds the Logins, configuration parameters
> MSDB Holds all the jobs, Maintenance plans, operators, alerts etc..
> Go thru the below links to transfer all the databases including system
> databases/
> http://www.support.microsoft.com/?id=224071
> http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
>
> Is it neccessary to restore the master or model or any other default
> databases in new server?
> Yes, this will reduce quite a lot of manual stuffs explained above.
> Thanks
> Hari
> MCDBA
>
> "RM" <m_r1824@.yahoo.co.uk> wrote in message
> news:opsawkt1l8hqligo@.msnews.microsoft.com...
>> Hi
>> I've a server which includes sql server2000
>> with somje databases,and now I want to transfer
>> all database into a new server(which just has a SQL server 2000 and SP3
>> with no databases) ,is it neccessary
>> to restore the master or model or any other default
>> databases in new server?
>> I want to do following steps:
>> Is there any more activities needed to transfer all info.?
>> 1 - backup all DBs(except default dbs like master,..).
>> 2 - restore DBs in new server.
>> 3 - define logins and link them to users.
>> 4 - define jobs or some maintanace plan.
>> Is there any better way to do this?
>> any help would be greatly thankful.
>|||Hi,
Go with system databases first and then restore the user databases. But
ensure that you restart the MSSQL server service only after
restoring all databases. Otherwise database will be marked suspect.
Thanks
Hari
MCDBA
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsawmhtkahqligo@.msnews.microsoft.com...
> thanks,
> and the last question :
> Is the order of restoring dbs (first system db,then the other)or (first
> the other ,then system db) important?
>
> On Sat, 10 Jul 2004 09:18:43 +0530, Hari Prasad
> <hari_prasad_k@.hotmail.com> wrote:
> > Hi,
> >
> > Your steps are 75% good, but if you restore the Master, MSD database
then
> > you donot want create the logins, Jobs, Maintenance plans, operators ,
> > alerts etc..
> >
> > Master holds the Logins, configuration parameters
> > MSDB Holds all the jobs, Maintenance plans, operators, alerts etc..
> >
> > Go thru the below links to transfer all the databases including system
> > databases/
> >
> > http://www.support.microsoft.com/?id=224071
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
> >
> >
> > Is it neccessary to restore the master or model or any other default
> > databases in new server?
> >
> > Yes, this will reduce quite a lot of manual stuffs explained above.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> > "RM" <m_r1824@.yahoo.co.uk> wrote in message
> > news:opsawkt1l8hqligo@.msnews.microsoft.com...
> >> Hi
> >>
> >> I've a server which includes sql server2000
> >> with somje databases,and now I want to transfer
> >> all database into a new server(which just has a SQL server 2000 and SP3
> >> with no databases) ,is it neccessary
> >> to restore the master or model or any other default
> >> databases in new server?
> >>
> >> I want to do following steps:
> >> Is there any more activities needed to transfer all info.?
> >>
> >> 1 - backup all DBs(except default dbs like master,..).
> >> 2 - restore DBs in new server.
> >> 3 - define logins and link them to users.
> >> 4 - define jobs or some maintanace plan.
> >>
> >> Is there any better way to do this?
> >>
> >> any help would be greatly thankful.
> >
> >
>|||Hi
as I read the article ,I 've got some question:
it said restore backup of your dbs in full case and with norecovery
and then restore the transaction log backup with recovery.
is it neccessary to restore transaction log file after we reostored
the database complete?
and why for the first we should do it with norecovery and for the second
we should do it with recovery?
and it said to change the location of dat and log files you
should use with move option in restioring database,but there
was no 'with move option' in restoring 2 tab pages,and
to change the location after we select the device ,I think
it is enough to change the path manually in option tab( second tab).
isn't it?
thanks
On Sat, 10 Jul 2004 09:18:43 +0530, Hari Prasad
<hari_prasad_k@.hotmail.com> wrote:
> Hi,
> Your steps are 75% good, but if you restore the Master, MSD database then
> you donot want create the logins, Jobs, Maintenance plans, operators ,
> alerts etc..
> Master holds the Logins, configuration parameters
> MSDB Holds all the jobs, Maintenance plans, operators, alerts etc..
> Go thru the below links to transfer all the databases including system
> databases/
> http://www.support.microsoft.com/?id=224071
> http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
>
> Is it neccessary to restore the master or model or any other default
> databases in new server?
> Yes, this will reduce quite a lot of manual stuffs explained above.
> Thanks
> Hari
> MCDBA
>
> "RM" <m_r1824@.yahoo.co.uk> wrote in message
> news:opsawkt1l8hqligo@.msnews.microsoft.com...
>> Hi
>> I've a server which includes sql server2000
>> with somje databases,and now I want to transfer
>> all database into a new server(which just has a SQL server 2000 and SP3
>> with no databases) ,is it neccessary
>> to restore the master or model or any other default
>> databases in new server?
>> I want to do following steps:
>> Is there any more activities needed to transfer all info.?
>> 1 - backup all DBs(except default dbs like master,..).
>> 2 - restore DBs in new server.
>> 3 - define logins and link them to users.
>> 4 - define jobs or some maintanace plan.
>> Is there any better way to do this?
>> any help would be greatly thankful.
>|||Hi,
is it neccessary to restore transaction log file after we reostored
the database complete?
No need.
This will be required when there is a recovery. Trasnaction log will be
restored if there are tranasctions after full database backup.
why for the first we should do it with norecovery and for the second we
should do it with recovery?
Say if you have 1 full backup and need to restore transaction log backup. So
restore the Full backup with NORECOVERY. This
Instructs the restore operation to not roll back any uncommitted
transactions. users cant access the database in this mode.
While restoring the final trasnaction log use the Recovery option. This
Instructs the restore operation to roll back any uncommitted transactions.
After the recovery process, the database is ready for use.
Move option for changing location of MDF and LDF.
Look into the RESTORE DATABASE command in Books online.
In Enter prise manager also you can change the location while restoring.
Chaging the path after restore
--
see the commands sp_detach_db and sp_attach_db in books online.
Thanks
Hari
MCDBA
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opsawnnkjqhqligo@.msnews.microsoft.com...
> Hi
> as I read the article ,I 've got some question:
> it said restore backup of your dbs in full case and with norecovery
> and then restore the transaction log backup with recovery.
> is it neccessary to restore transaction log file after we reostored
> the database complete?
> and why for the first we should do it with norecovery and for the second
> we should do it with recovery?
> and it said to change the location of dat and log files you
> should use with move option in restioring database,but there
> was no 'with move option' in restoring 2 tab pages,and
> to change the location after we select the device ,I think
> it is enough to change the path manually in option tab( second tab).
> isn't it?
> thanks
>
> On Sat, 10 Jul 2004 09:18:43 +0530, Hari Prasad
> <hari_prasad_k@.hotmail.com> wrote:
> > Hi,
> >
> > Your steps are 75% good, but if you restore the Master, MSD database
then
> > you donot want create the logins, Jobs, Maintenance plans, operators ,
> > alerts etc..
> >
> > Master holds the Logins, configuration parameters
> > MSDB Holds all the jobs, Maintenance plans, operators, alerts etc..
> >
> > Go thru the below links to transfer all the databases including system
> > databases/
> >
> > http://www.support.microsoft.com/?id=224071
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
> >
> >
> > Is it neccessary to restore the master or model or any other default
> > databases in new server?
> >
> > Yes, this will reduce quite a lot of manual stuffs explained above.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> > "RM" <m_r1824@.yahoo.co.uk> wrote in message
> > news:opsawkt1l8hqligo@.msnews.microsoft.com...
> >> Hi
> >>
> >> I've a server which includes sql server2000
> >> with somje databases,and now I want to transfer
> >> all database into a new server(which just has a SQL server 2000 and SP3
> >> with no databases) ,is it neccessary
> >> to restore the master or model or any other default
> >> databases in new server?
> >>
> >> I want to do following steps:
> >> Is there any more activities needed to transfer all info.?
> >>
> >> 1 - backup all DBs(except default dbs like master,..).
> >> 2 - restore DBs in new server.
> >> 3 - define logins and link them to users.
> >> 4 - define jobs or some maintanace plan.
> >>
> >> Is there any better way to do this?
> >>
> >> any help would be greatly thankful.
> >
> >
>