Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Posts
    19

    Unanswered: Test: Server performance

    Hi ,
    How to test the server performance is Good or Bad before install sql server 2008 Ent. Edit.
    30 GB single file xcopy test from one drive to another drive is good one or not.


    G Arunagiri

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Depends on a lot of factors.
    Depends on the load (is this a dedicated SQL box or does it also host applications, IIS etc).
    How many instances
    How many simultaneous connections
    OLAP or OLTP
    Will this host mission critical databases
    how do you define good - do you have SLAs
    how big are the databases and estimated rate of growth

    You can check the disk system using SQLIOSIM before installation. The disks are typically the most likely bottleneck, but of course this all depends on the above.
    How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem

    What is the server spec?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2010
    Posts
    19

    Question TempDB

    Hi All,

    Is it good to store tempdb mdf file in one drive and log file in another drive.

    Daily our databases growths are 59 GB and we have only 70 GB free space out of 760 GB.

    IMPT: daily 29 GB text files are uploaded into different tables in sql server and same size of old tables are deleted.

    Thanks
    G Arunagiri

  4. #4
    Join Date
    Sep 2010
    Location
    Victoria, Australia
    Posts
    4

    Wink Short answer, yes.

    Quote Originally Posted by gkarung View Post
    Hi All,

    Is it good to store tempdb mdf file in one drive and log file in another drive.

    Daily our databases growths are 59 GB and we have only 70 GB free space out of 760 GB.

    IMPT: daily 29 GB text files are uploaded into different tables in sql server and same size of old tables are deleted.

    Thanks
    G Arunagiri
    Generally, moving the temp database to a different physical drive (not just a different partition on the same drive, of course) will improve performance, as the disk seek heads do not have to wait for each other when they're on different drives (that's a simplified picture, but it'll do for now).

    You probably still have it on the C: drive? It's perfectly ok to move tempdb somewhere else. I suggest a decent high-speed drive (ESATA II perhaps) not an outboard or USB drive.

    This MSDN link will show you how to move system databases.

    Cheers!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •