Re: Backing up transaction logs gives poor performance.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

The only option I have at the moment is saving them to a network drive, but I haven't checked to see if this is even possible.
Do you think it would make so much difference that it would be worth installing new disks?

Thanks,
SW

"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in message news:0C271F78-637B-4E18-AFB3-C56C79EE2937@xxxxxxxxxxxxxxxx
Do you have everything on the RAID5 array? RAID5 is famous for being slow for writes. First step would be to write the log backups to some other drive. And perhaps even separating the log file(s) so an isolated RAID1 or RAID10.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"SW" <anonymousgravy@xxxxxxxxxxx> wrote in message news:7D564181-5EC5-4B6F-A0A0-2B9B0D04E6A8@xxxxxxxxxxxxxxxx
Hi,

I have a problem with SQL server being very slow to access and use while I'm backing up transaction logs. I'm backing up the logs every half hour, and it makes the whole thing run so slowly it's driving the users nuts. It puts the application into a spin while the logs are being backed up and it's being used by a lot of people. If there's less people its still noticeable but not as severe.
Its SQL 2000, on a W2003 server, XP clients. Server has twin Xeon 2.8 cpus with 4GB RAM and a RAID 5 array. There's 2 instances of SQL server hosting 2 separate, different applications. The database sizes are varied. On one of the apps there's a database with a 11.5GB .mdf file, and a 6GB .ldf file. Transaction log backup files from this database are typically about 20MB while the application is busy. The users of both apps complain of the same problem - intermittent slowness so bad it sometimes makes the app unusable.
The log backup seems to cripple the entire machine.
Where do I start to cure this problem?
Is there a way I can get the maintenance plan to use less cpu? Or is it more likely a memory problem?
Any help appreciated, Thanks in advance,

SW



.

Relevant Pages

  • Re: Backing up transaction logs gives poor performance.
    ... Do you have everything on the RAID5 array? ... On one of the apps there's a database with a 11.5GB .mdf file, ... Transaction log backup files from this database are typically about 20MB while the application is busy. ... The users of both apps complain of the same problem - intermittent slowness so bad it sometimes makes the app unusable. ...
    (microsoft.public.sqlserver.setup)
  • Re: Sync Database via Internet
    ... I develop apps on MS Access and SQL Server. ... database on the main server. ... Most of them do their syncing through ActiveSync which does not support ...
    (microsoft.public.pocketpc.developer)
  • Re: newbie setup question
    ... database setup thing in the VB.Net Express 2008 software. ... how to get started on setting up data source, just on setting up forms apps ... Make sure you have the service packs for SQL Server and Visual Studio. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Relocate MSDE 2000 database?
    ... I've already hammered on the vendors for not offering database placement as ... part of the installation, and to use a more current database engine. ... Back to William Vaughn's first post, a suggestion to use SQL Server ... post -- these databases are installed and deployed by 3rd party apps ...
    (microsoft.public.sqlserver.msde)
  • Re: How to "undo" a delete with cascades
    ... > Somebody accidently deleted a record with cascade deletes ... > is how to restore the database to a point in time. ... > (We do a full backup every week and log backup every day) ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)