SQL Server Performance

what are Microsoft recommendation on how to format partition

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by avipenina, Jul 22, 2008.

  1. avipenina New Member

    Hi,
    I've HP Server with SmartArray Raid controller.i use 2 disk in mirror for the system operation and SQL Server Binaries,2 disk in mirror for the SQL Server Log files(LDF), 4 disk in raid5 for the SQL Server Data files (MDF).
    after that i create those Raid Array i need to format the partition,is there any meaning on how i format those partition concerning the Allocation Unit Size?
    THX
    avipenina, Jul 22, 2008
    #2

  2. moh_hassan20 New Member

    All Server volumes formated NTFS with allocation unit size 64 KB.
    moh_hassan20, Jul 22, 2008
    #3

  3. satya Moderator

    What kind of database is this, OLTP or DSS?
    Is it fully transactional or read only type of data?
    satya, Jul 23, 2008
    #4

  4. avipenina New Member

    Hi,
    it's OLTP database and fully transactional.
    avipenina, Jul 23, 2008
    #5

  5. satya Moderator

    satya, Jul 23, 2008
    #6

Share This Page