SQL Server Performance

help plz

Discussion in 'Performance Tuning for DBAs' started by lara99, Nov 26, 2007.

  1. lara99 New Member

    Hi All
    What are the different ways of gaining some space on production environment.
    1.Shrinking databases when they are live is not feasible. Can we run maintainance plan
    job during off peak hours to shrink the live databses, will it be a performance increase or decrease
    please help.
  2. Greg Larsen New Member

    Remove all files that are not needed that might be on the same drives as your databases, like database backups, old log files, etc.
  3. ranjitjain New Member

    Retriving hard disk space can only be done by deleting unwanted files, because shrinking the database is not a solution because, there must be some heavy logged operations and data inserts performed which neede db to grow.
    Look at the recovery model, if possible keep it to simple and read about each model in detail in BOL.
    Better option could be to attach a new drive and shift log or data file onto it

Share This Page