How Backup Affect Performance?

I would like to know whether the performance of a SQL server 2000 will be
slow down during a full database backup period?
I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase a
full backup during lunch time but I'm affraid of the backup will affect
application user.
Thanks
Black
Wow , you have to backup and the shink the log file immediatly
Regarding your question , it should not be any performance issues during the
backup.
"Black" <hoodworld@.hotmail.com> wrote in message
news:uckZOwPiFHA.3656@.TK2MSFTNGP09.phx.gbl...
> I would like to know whether the performance of a SQL server 2000 will be
> slow down during a full database backup period?
> I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase
a
> full backup during lunch time but I'm affraid of the backup will affect
> application user.
> Thanks
>
>
|||Thanks for your reply, Uri.
It's out of my control to shink the log.
BTW, is there any reference site in Microsoft stating that. I have to
provide some evidence to my client.
Thanks again.
Black
"Uri Dimant" <urid@.iscar.co.il> glsD
:OCOfzHQiFHA.320@.TK2MSFTNGP09.phx.gbl...
> Black
> Wow , you have to backup and the shink the log file immediatly
> Regarding your question , it should not be any performance issues during
the
> backup.
>
>
|||It depends on your IO system. If the system is not good enough, you would see
slowness of transactions, decrease of performance. If your IO system good
enough, you would not notice any effects of backups.
"Black" wrote:

> I would like to know whether the performance of a SQL server 2000 will be
> slow down during a full database backup period?
> I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase a
> full backup during lunch time but I'm affraid of the backup will affect
> application user.
> Thanks
>
>
|||Backups done on proper hardware should only affect the normal operation by
around 10% or so. But if you are backing up to the same drives that the
data itself is on you can impact it more depending on the hardware.
Andrew J. Kelly SQL MVP
"Black" <hoodworld@.hotmail.com> wrote in message
news:uckZOwPiFHA.3656@.TK2MSFTNGP09.phx.gbl...
> I would like to know whether the performance of a SQL server 2000 will be
> slow down during a full database backup period?
> I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase
> a
> full backup during lunch time but I'm affraid of the backup will affect
> application user.
> Thanks
>
>
|||Black wrote:
> Thanks for your reply, Uri.
> It's out of my control to shink the log.
> BTW, is there any reference site in Microsoft stating that. I have to
> provide some evidence to my client.
>
Then you need to explain to your client that it appears the log is not
being backed up. If your client is only performing full database
backups, then maybe they should be using the simple recovery model.
Other than being able to sniff the log file with a log reader, I can't
think of any reason to keep a huge log file around.
David Gugick
Quest Software
www.imceda.com
www.quest.com

How Backup Affect Performance?

I would like to know whether the performance of a SQL server 2000 will be
slow down during a full database backup period?
I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase a
full backup during lunch time but I'm affraid of the backup will affect
application user.
ThanksBlack
Wow , you have to backup and the shink the log file immediatly
Regarding your question , it should not be any performance issues during the
backup.
"Black" <hoodworld@.hotmail.com> wrote in message
news:uckZOwPiFHA.3656@.TK2MSFTNGP09.phx.gbl...
> I would like to know whether the performance of a SQL server 2000 will be
> slow down during a full database backup period?
> I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase
a
> full backup during lunch time but I'm affraid of the backup will affect
> application user.
> Thanks
>
>|||Thanks for your reply, Uri.
It's out of my control to shink the log.
BTW, is there any reference site in Microsoft stating that. I have to
provide some evidence to my client.
Thanks again.
Black
"Uri Dimant" <urid@.iscar.co.il> glsD
:OCOfzHQiFHA.320@.TK2MSFTNGP09.phx.gbl...
> Black
> Wow , you have to backup and the shink the log file immediatly
> Regarding your question , it should not be any performance issues during
the
> backup.
>
>|||It depends on your IO system. If the system is not good enough, you would se
e
slowness of transactions, decrease of performance. If your IO system good
enough, you would not notice any effects of backups.
"Black" wrote:

> I would like to know whether the performance of a SQL server 2000 will be
> slow down during a full database backup period?
> I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase
a
> full backup during lunch time but I'm affraid of the backup will affect
> application user.
> Thanks
>
>|||Backups done on proper hardware should only affect the normal operation by
around 10% or so. But if you are backing up to the same drives that the
data itself is on you can impact it more depending on the hardware.
Andrew J. Kelly SQL MVP
"Black" <hoodworld@.hotmail.com> wrote in message
news:uckZOwPiFHA.3656@.TK2MSFTNGP09.phx.gbl...
> I would like to know whether the performance of a SQL server 2000 will be
> slow down during a full database backup period?
> I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase
> a
> full backup during lunch time but I'm affraid of the backup will affect
> application user.
> Thanks
>
>|||Black wrote:
> Thanks for your reply, Uri.
> It's out of my control to shink the log.
> BTW, is there any reference site in Microsoft stating that. I have to
> provide some evidence to my client.
>
Then you need to explain to your client that it appears the log is not
being backed up. If your client is only performing full database
backups, then maybe they should be using the simple recovery model.
Other than being able to sniff the log file with a log reader, I can't
think of any reason to keep a huge log file around.
David Gugick
Quest Software
www.imceda.com
www.quest.com

How Backup Affect Performance?

I would like to know whether the performance of a SQL server 2000 will be
slow down during a full database backup period?
I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase a
full backup during lunch time but I'm affraid of the backup will affect
application user.
ThanksBlack
Wow , you have to backup and the shink the log file immediatly
Regarding your question , it should not be any performance issues during the
backup.
"Black" <hoodworld@.hotmail.com> wrote in message
news:uckZOwPiFHA.3656@.TK2MSFTNGP09.phx.gbl...
> I would like to know whether the performance of a SQL server 2000 will be
> slow down during a full database backup period?
> I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase
a
> full backup during lunch time but I'm affraid of the backup will affect
> application user.
> Thanks
>
>|||Thanks for your reply, Uri.
It's out of my control to shink the log.
BTW, is there any reference site in Microsoft stating that. I have to
provide some evidence to my client.
Thanks again.
Black
"Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D
:OCOfzHQiFHA.320@.TK2MSFTNGP09.phx.gbl...
> Black
> Wow , you have to backup and the shink the log file immediatly
> Regarding your question , it should not be any performance issues during
the
> backup.
>
>|||It depends on your IO system. If the system is not good enough, you would see
slowness of transactions, decrease of performance. If your IO system good
enough, you would not notice any effects of backups.
"Black" wrote:
> I would like to know whether the performance of a SQL server 2000 will be
> slow down during a full database backup period?
> I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase a
> full backup during lunch time but I'm affraid of the backup will affect
> application user.
> Thanks
>
>|||Backups done on proper hardware should only affect the normal operation by
around 10% or so. But if you are backing up to the same drives that the
data itself is on you can impact it more depending on the hardware.
--
Andrew J. Kelly SQL MVP
"Black" <hoodworld@.hotmail.com> wrote in message
news:uckZOwPiFHA.3656@.TK2MSFTNGP09.phx.gbl...
> I would like to know whether the performance of a SQL server 2000 will be
> slow down during a full database backup period?
> I have a server with 1.5GB MDF file and 4GB .LDF file. I want to increase
> a
> full backup during lunch time but I'm affraid of the backup will affect
> application user.
> Thanks
>
>|||Black wrote:
> Thanks for your reply, Uri.
> It's out of my control to shink the log.
> BTW, is there any reference site in Microsoft stating that. I have to
> provide some evidence to my client.
>
Then you need to explain to your client that it appears the log is not
being backed up. If your client is only performing full database
backups, then maybe they should be using the simple recovery model.
Other than being able to sniff the log file with a log reader, I can't
think of any reason to keep a huge log file around.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

how about the performance about "sa" a/c?

any consideration of performance issue when i use "sa" a/c to connect SQL SERVER in java program? will be faster or slower?Why do you want/need to use the sa account in your application ? This is a big security issue. This account should only be used in a dba capacity situation - outside of an application.|||my connection string is : xxxxx:1433;DatabaseName=rims;User=sa;Password=xxxx

in my JAVA program, is it wrong? should i use another a/c?

Originally posted by rnealejr
Why do you want/need to use the sa account in your application ? This is a big security issue. This account should only be used in a dba capacity situation - outside of an application.|||Yes. What are you using the connection for ?

hot spots

I've read a little about drives having "hot spots" as a performance issue.
Hot would one go about detecting this? I can't think of a direct way to
monitor accesses to a certain physical area of the disk, are there
performance counters from which this condition might logically be inferred?
tia,
Mark McGinty
Hi,
See the performance monitor counters
http://www.sql-server-performance.co...ounters_io.asp
Thanks
Hari
SQL Server MVP
"Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
news:O73iDtxWFHA.1384@.TK2MSFTNGP09.phx.gbl...
> I've read a little about drives having "hot spots" as a performance issue.
> Hot would one go about detecting this? I can't think of a direct way to
> monitor accesses to a certain physical area of the disk, are there
> performance counters from which this condition might logically be
> inferred?
> tia,
> Mark McGinty
>
|||Not sure if this will help but take a look at this:
http://www.passmark.com/products/diskcheckup.htm
Message posted via http://www.droptable.com
|||"Sameer Premji via droptable.com" <forum@.droptable.com> wrote in message
news:8dcfe4c84c2a420c92d85c5923b07a61@.droptable.co m...
> Not sure if this will help but take a look at this:
> http://www.passmark.com/products/diskcheckup.htm
> --
> Message posted via http://www.droptable.com
Interesting tool, thanks! Sadly, its lack of ability to query drives
connected via SCSI or RAID cuts it's usefulness to the bone, as nearly all
of the storage on production machines I see uses either or both of those
interface technologies.
-Mark
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eLX3TvxWFHA.616@.TK2MSFTNGP12.phx.gbl...
> Hi,
> See the performance monitor counters
> http://www.sql-server-performance.co...ounters_io.asp
Wow that was fast! :-) Very interesting article, thanks!
-Mark

> Thanks
> Hari
> SQL Server MVP
> "Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
> news:O73iDtxWFHA.1384@.TK2MSFTNGP09.phx.gbl...
>

hot spots

I've read a little about drives having "hot spots" as a performance issue.
Hot would one go about detecting this? I can't think of a direct way to
monitor accesses to a certain physical area of the disk, are there
performance counters from which this condition might logically be inferred?
tia,
Mark McGintyHi,
See the performance monitor counters
http://www.sql-server-performance.com/performance_monitor_counters_io.asp
Thanks
Hari
SQL Server MVP
"Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
news:O73iDtxWFHA.1384@.TK2MSFTNGP09.phx.gbl...
> I've read a little about drives having "hot spots" as a performance issue.
> Hot would one go about detecting this? I can't think of a direct way to
> monitor accesses to a certain physical area of the disk, are there
> performance counters from which this condition might logically be
> inferred?
> tia,
> Mark McGinty
>|||Not sure if this will help but take a look at this:
http://www.passmark.com/products/diskcheckup.htm
--
Message posted via http://www.sqlmonster.com|||"Sameer Premji via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8dcfe4c84c2a420c92d85c5923b07a61@.SQLMonster.com...
> Not sure if this will help but take a look at this:
> http://www.passmark.com/products/diskcheckup.htm
> --
> Message posted via http://www.sqlmonster.com
Interesting tool, thanks! Sadly, its lack of ability to query drives
connected via SCSI or RAID cuts it's usefulness to the bone, as nearly all
of the storage on production machines I see uses either or both of those
interface technologies.
-Mark|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eLX3TvxWFHA.616@.TK2MSFTNGP12.phx.gbl...
> Hi,
> See the performance monitor counters
> http://www.sql-server-performance.com/performance_monitor_counters_io.asp
Wow that was fast! :-) Very interesting article, thanks!
-Mark
> Thanks
> Hari
> SQL Server MVP
> "Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
> news:O73iDtxWFHA.1384@.TK2MSFTNGP09.phx.gbl...
>> I've read a little about drives having "hot spots" as a performance
>> issue. Hot would one go about detecting this? I can't think of a direct
>> way to monitor accesses to a certain physical area of the disk, are there
>> performance counters from which this condition might logically be
>> inferred?
>> tia,
>> Mark McGinty
>

hot spots

I've read a little about drives having "hot spots" as a performance issue.
Hot would one go about detecting this? I can't think of a direct way to
monitor accesses to a certain physical area of the disk, are there
performance counters from which this condition might logically be inferred?
tia,
Mark McGintyHi,
See the performance monitor counters
http://www.sql-server-performance.c...counters_io.asp
Thanks
Hari
SQL Server MVP
"Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
news:O73iDtxWFHA.1384@.TK2MSFTNGP09.phx.gbl...
> I've read a little about drives having "hot spots" as a performance issue.
> Hot would one go about detecting this? I can't think of a direct way to
> monitor accesses to a certain physical area of the disk, are there
> performance counters from which this condition might logically be
> inferred?
> tia,
> Mark McGinty
>|||Not sure if this will help but take a look at this:
http://www.passmark.com/products/diskcheckup.htm
Message posted via http://www.droptable.com|||"Sameer Premji via droptable.com" <forum@.droptable.com> wrote in message
news:8dcfe4c84c2a420c92d85c5923b07a61@.SQ
droptable.com...
> Not sure if this will help but take a look at this:
> http://www.passmark.com/products/diskcheckup.htm
> --
> Message posted via http://www.droptable.com
Interesting tool, thanks! Sadly, its lack of ability to query drives
connected via SCSI or RAID cuts it's usefulness to the bone, as nearly all
of the storage on production machines I see uses either or both of those
interface technologies.
-Mark|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eLX3TvxWFHA.616@.TK2MSFTNGP12.phx.gbl...
> Hi,
> See the performance monitor counters
> http://www.sql-server-performance.c...counters_io.asp
Wow that was fast! :-) Very interesting article, thanks!
-Mark

> Thanks
> Hari
> SQL Server MVP
> "Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
> news:O73iDtxWFHA.1384@.TK2MSFTNGP09.phx.gbl...
>