Post reply

Application freezes during Multiple File Backup

  • November 28, 2011 at 6:28 am

    #390964

    We are running SQL Server 2005 SP3 Ent 64 Biot witht he Application Postilion Office 4.2.

    When we run the normal single file backups the application does not freeze, but when we run the backup to multiple files to a shared drive , the operators claim the application freezes. Has anyone come across similar incidents ?

  • November 28, 2011 at 6:34 am

    #1413393

    Backups do not interfare with other operations. Have you tried finding if there is any blocking during that period? You said the backups are on some shared drive (assuming not on the same drive where data/log files reside), so IO contention should not happen.


    Pradeep Singh

  • November 28, 2011 at 7:54 am

    #1413450

    We did not find any other locks during the process .

  • November 28, 2011 at 7:57 am

    #1413452

    Long running Queries? Find their SPids and see what are they waiting on..


    Pradeep Singh

  • November 28, 2011 at 8:00 am

    #1413456

    Will do that .

    Thanks

  • November 28, 2011 at 11:57 am

    #1413592

    Interesting issue. Do you have monitoring on the server? Does CPU, Disk, Memory use go up in different ways during the multi-file backup than during the single file backup? It's actually a common practice, a suggested best practice, to use multiple files for large backups to help speed them up. I'd expect a slight increase in CPU & Memory, but a decrease in disk during that operation.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply