SQL Server Performance

database restore performance

Discussion in 'Performance Tuning for DBAs' started by cb, Jan 22, 2003.

  1. cb New Member

    I have a 5 gb database which is taking half an hour to restore on remote server, which used to take 15 mintues just a month ago.

    Is this normal behaviour or any counters to check.
  2. satya Moderator

    I believe its a standard time its taking for restore. You need to assess the data growth since last time the restore operation was monitored.

    Are there any other jobs/processes are running at that remote server during this restore job or any users running large queries?

    HTH


    Satya SKJ
  3. chandru New Member

    I would suggest checking network connectivity to the remote server. Is it on a LAN or a WAN?

    -CR
  4. bradmcgehee New Member

    Thirty minutes for a 5GB is not too bad, although it might be better. At one time I ran into a program with restores taking longer than ususal (all of a sudden) and the problem was identifed as a problem with the switch we were using. It was not autosensing the network card in the server and was sometimes running at 100Mbs, and at other times, 10Mbs. Once we manually configured the network card to run at only 100Mbs, full duplex, the switch was happy and performance went back up. Of course this may not be your problem, but is just one other thing to look at.

    If you are really looking to speed up your backups and restored over a network, consider a third-party program like SQL LiteSpeed, which can greatly reduce backup and restore times. See these two urls for more information on this product:

    http://www.sql-server-performance.com/sql_litespeed_spotlight.asp
    http://www.sql-server-performance.com/gr_sql_litespeed.asp


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page