Post reply

Accessing Archive Data

  • May 14, 2008 at 9:56 am

    #185593

    Hi All

    I am currently having a database of 130 GB which contains tables for 3 years, splitted by months table. this is been accessed by an application.

    The data file is on a RAID 5 Lun, and its a 64 bit SQL 2005 std edition.

    i am planning to split the data into db's for each year and tables for each month,

    Will this improve performance while accessing data from 3 db's and 3 tables instead of 1 db and 36 tables.

    Is there any thing else i can do to improve performance of data retrival from this database

    Cheers

    Suji

  • May 19, 2008 at 9:18 am

    #817254

    Have you looked into partitioning, or at your indexing strategy? I know SQL doesn't do parallelism when crossing partitions, but if you do them right, you shouldn't have to worry about that too much.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

Viewing 2 posts - 1 through 1 (of 1 total)

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