Performance Problem

After a server restart the server performance is much better
until the first backup at night occurs.
What could be the problem?
Thanks for some ideas!In article <eXY7Js$CIHA.748@.TK2MSFTNGP04.phx.gbl>, $Patrick.Gassmann
$@.selectchemie.ch says...
> After a server restart the server performance is much better
> until the first backup at night occurs.
> What could be the problem?
> Thanks for some ideas!
Maybe if you told us about the server, hardware, memory, typical memory
in use, what app you're using for backup, are you doing a backup to disk
and then disk to tape?
Leythos
- Igitur qui desiderat pacem, praeparet bellum.
- Calling an illegal alien an "undocumented worker" is like calling a
drug dealer an "unlicensed pharmacist"
spam999free@.rrohio.com (remove 999 for proper email address)|||Hi
http://dimantdatabasesolutions.blogspot.com/2007/04/whats-version-of-sql-server.html
Did you monitor your server?
<$Patrick.Gassmann$@.selectchemie.ch> wrote in message
news:eXY7Js$CIHA.748@.TK2MSFTNGP04.phx.gbl...
> After a server restart the server performance is much better
> until the first backup at night occurs.
> What could be the problem?
> Thanks for some ideas!|||Windows 2000 SP4
MSSQL 2000 SP3 Standard Edition
Not Clustered
HP ML530 with 4 Raid 0 (System, Temp, LOG, Data)
Memory 3 GB
Memory used by SQL-Server 1.8 GB
Backup to Disk (not with a SQL-Agent) , Files are backuped
with BackupExec 9.1. (on the same server) to a tape.
Patrick|||Hi
I'm not fimilar with BackupExec 9.1 software, have you turned on SQL Server
Profiler while the backup is running?
<$Patrick.Gassmann$@.selectchemie.ch> wrote in message
news:unN8sSADIHA.4752@.TK2MSFTNGP04.phx.gbl...
> Windows 2000 SP4
> MSSQL 2000 SP3 Standard Edition
> Not Clustered
> HP ML530 with 4 Raid 0 (System, Temp, LOG, Data)
> Memory 3 GB
> Memory used by SQL-Server 1.8 GB
> Backup to Disk (not with a SQL-Agent) , Files are backuped
> with BackupExec 9.1. (on the same server) to a tape.
>
> Patrick
>
>|||Hi
I don't know how to use the profiler
>> Uri Dimant<urid@.iscar.co.il> 11.10.07 14:55:54 >>
Hi
I'm not fimilar with BackupExec 9.1 software, have you
turned on SQL Server
Profiler while the backup is running?
<$Patrick.Gassmann$@.selectchemie.ch> wrote in message
news:unN8sSADIHA.4752@.TK2MSFTNGP04.phx.gbl...
> Windows 2000 SP4
> MSSQL 2000 SP3 Standard Edition
> Not Clustered
> HP ML530 with 4 Raid 0 (System, Temp, LOG, Data)
> Memory 3 GB
> Memory used by SQL-Server 1.8 GB
> Backup to Disk (not with a SQL-Agent) , Files are
backuped
> with BackupExec 9.1. (on the same server) to a tape.
>
> Patrick
>
>