| Author |
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
| |
| Uri Dimant 2005-07-15, 3:23 am |
| 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> ¼¶¼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
>
>
>
>
| |
| Andrew J. Kelly 2005-07-15, 7:23 am |
| 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
>
>
>
| |
| David Gugick 2005-07-15, 1:23 pm |
| 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
|
|
|
|